Exam AZ-304 topic 13 question 4 discussion

N,N,Y 1. You can use online database migration service for minimal downtime, which does not require a storage account. 2. There is no mention about website data. So, website data can be migrated to Azure App Service. 3. Database metrics must be available for administrators, so you store metrics in a storage account.

N,N,N 1: Database migration can use stretch Database https://azure.microsoft.com/en-au/services/sql-server-stretch-database/ 2: Any website data is part of the Web App 3: You create a Log Analytics workspace https://docs.microsoft.com/en-us/azure/azure-monitor/logs/quick-create-workspace https://docs.microsoft.com/en-us/azure/azure-monitor/insights/azure-sql

YNY Create or make a note of Standard Performance tier, Azure Storage Account, that allows DMS service to upload the database backup files to and use for migrating databases. Make sure to create the Azure Storage Account in the same region as the Azure Database Migration Service instance is created.

Storage account settings The SAS URI that provides Azure Database Migration Service with access to your storage account container to which the service uploads the backup files and that is used for migrating databases to SQL Managed Instance. Learn how to get the SAS URI for blob container. This SAS URI must be for the blob container, not for the storage account. https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance

Azure Database Migration tool creates storage account, so you don't have to provision storage account: https://docs.microsoft.com/en-us/azure/migrate/replicate-using-expressroute Web App doesn't require storage account You can use Log analytics workspace to store Database metrics, instead of Storage account. So answers are N-N-N

Metric to disk : To configure writing audit logs to a storage account, select Storage when you get to the Auditing section. Select the Azure storage account where logs will be saved, and then select the retention period by opening Advanced properties. Then click Save. Logs older than the retention period are deleted. https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview The default value for retention period is 0 (unlimited retention) Last option is 'Y'

On exam today 22-Dec-21

Given answers are correct. YNY 1. Requirement: Database backups must be retained for a minimum of seven years to meet compliance requirements. Which storage option is cheaper than archive tier ? Stretched database data storage Data storage is charged based at $0.16/GB/month https://azure.microsoft.com/en-ca/pricing/details/sql-server-stretch-database/ Standard (GPv2) storage Archive tier First 50 terabyte (TB) / month: $0.00099 per GB https://azure.microsoft.com/en-ca/pricing/details/storage/blobs/ ---or to use long-term backup With Azure SQL Database, you can set a long-term backup retention policy (LTR) to automatically retain backups in separate Azure Blob storage containers for up to 10 years. https://docs.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?tabs=portal 2. There is no storage requirement for web site content 3. Requirement: Database metrics for the production instance of WebApp1 must be available for analysis so that database administrators can optimize the performance settings. We do need storage to analyze database metrics

Y N N ---

I would say No to all There is another qn for this case study "You need to recommend a strategy for migrating the database content of WebApp1 to Azure. What should you include in the recommendation?" in which answer is transactional replication to me. Storage account is not needed. Web App comes with its own storage (https://docs.microsoft.com/en-us/azure/app-service/overview-hosting-plans) For metrics monitoring you can use Azure Monitor

YNN stroage account seems being reauired as described here: https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-guide

https://www.examtopics.com/discussions/microsoft/view/14121-exam-az-301-topic-15-question-1-discussion/ Same question. Even there no consensus.

NYN 2. Key things to note Web site content must be easily updated from a single point. Any new deployments to Azure must be redundant in case an Azure region fails. AppService needs seperate instances per region for redundancy meaning it's data would not be updateable in a single location unless stored in a GRS storage account

Y Y N 1. Need to provision the azure storage for database 2. Website data is part of the webapp 3. Use log analytics workspace for metrics

on exam (7-19-2021). passed 304

no, It should be look at in conjunction with the case study and not as generic one. Given answer is correct... Please look at this statement...To avoid disrupting customer access