HOTSPOT -
You are evaluating the components of the migration to Azure that require you to provision an Azure Storage account. For each of the following statements, select
Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Box 1: No -
Online migration will work fine. It does not require an Azure Storage account.
Box 2: No -
Data for the web site can migrated to Azure app service.
Box 3: Yes -
Scenario: Database metrics for the production instance of WebApp1 must be available for analysis so that database administrators can optimize the performance settings.
Reference:
https://azure.microsoft.com/en-au/services/sql-server-stretch-database/
Y,N,N - just another solution 1. SQL Migration: Because onprem licenses must be used, whenever possible=> BYOL. Preferred SQL Migration in this case is uploading VHD from onprem Hyper-V-VM and create a new Azure VM https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/migrate-to-vm-from-sql-server#choose-a-migration-method 2. WebApp: https://docs.microsoft.com/en-us/azure/app-service/deploy-continuous-deployment?tabs=github Single point source: GitHub Repository can be configured as source for continous Deployment 3. Database metrics: https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview Also for SQL Server on Azure VMs it is possible to send metrics to 3 services: a) Log Analytics workspace in Azure Monitor b) Azure Event Hub c) Azure Storage 2 of 3 do not need a dedicated Azure Storage account.. It is not REQUIRED to create a storage account to fulfill requirements.
2. Website content storage is more like html, css, media. I think you would need a storage account for that.
I have the same doubt
The web app gets some PaaS storage, the amount depending on the plan. This is where the html, css etc go. So I think you shouldn't need a storage account. I saw a good explanation from the Microsoft person in https://docs.microsoft.com/en-us/answers/questions/102686/azure-web-app-dlocal-storage-has-hit-storage-limit.html
I have the same doubt
The first question is N: You can migrate to SQL MI without storage account Azure Hybrid Benefit allows you to use SQL Server licenses with Software Assurance or qualifying subscription licenses to pay a reduced base rate* for these products and services for SQL Server on Azure: vCPU-based service tiers of Azure SQL Database (excluding serverless). Azure SQL Managed Instance. SQL Server in Azure Virtual Machines. SQL Server Integration Services. *When you apply Azure Hybrid Benefit to your existing deployments, the base rate will be calculated beginning with when you select the benefit in the Azure portal. Credit will not be issued retroactively. https://azure.microsoft.com/en-us/pricing/hybrid-benefit/faq/#:~:text=Azure%20Hybrid%20Benefit%20allows%20you,SQL%20Database%20(excluding%20serverless).
Without storage account we can only do offline migrations, which means longer downtime. So, to minimize downtime as per requirement, we do need a storage account.
I agree with your answer Yes: Migrate to SQL Managed Instance needs storage account https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online#configure-migration-settings No: use Azure Web app where the app can be upgraded from a single point and can scale in /out with its own storage https://docs.microsoft.com/en-us/azure/azure-monitor/autoscale/autoscale-get-started?toc=/azure/app-service/toc.json No: Storage account is not mandatory, you can use Log Analytics workspace instead. Storage account can be used as a cheap option when you want to "archive" Stream metrics and resource logs https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview#azure-storage
I agree with this. Been researching all the comments and articles and this is closest fit to the requirement.
In fact with SQL MI, you don't even need Log Analytics workspace, it has native metrics built into the offer: https://learn.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql
In fact with SQL MI, you don't even need Log Analytics workspace, it has native metrics built into the offer: https://learn.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql
Without storage account we can only do offline migrations, which means longer downtime. So, to minimize downtime as per requirement, we do need a storage account.
The web app gets some PaaS storage, the amount depending on the plan. This is where the html, css etc go. So I think you shouldn't need a storage account. I saw a good explanation from the Microsoft person in https://docs.microsoft.com/en-us/answers/questions/102686/azure-web-app-dlocal-storage-has-hit-storage-limit.html
I don't see why we must migrate to SQL Server on Azure VM. The requirement to reuse on-prem licenses can be met with Azure Hybrid Benefit which works with SQL Managed Instance and SQL Database (vCore) too. As others have pointed out, if we go to SQL Managed Instance then we can meets the requirement to minimize downtime with the online migration method, which requires a storage account. I can't see anything in https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql which says a storage account is always required so I'm also going YNN, but for slightly different reasons.
In this question we are supposing that we will use SQL Server on VM (IaaS). Altough in previous questions we suppose we will use Azure SQL Databases with Long-term retention (PaaS). If I understood, we can't use long-term backup retention in SQL Server VM. Then we have to use IaaS database or PaaS database?
I agree with this. Been researching all the comments and articles and this is closest fit to the requirement.
In fact with SQL MI, you don't even need Log Analytics workspace, it has native metrics built into the offer: https://learn.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql
In fact with SQL MI, you don't even need Log Analytics workspace, it has native metrics built into the offer: https://learn.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql
in No. 3 , if you used (log analytics workspace, event hub,...etc.) they all require a storage account/container to save the logs and events in it? you got to save them in some storage account. I think it's yes. Please let me know if i missed something
Appeared 2023/01/04 in the exam
topic 7: Fabrikam-Question #1-Page-44 topic 7: Fabrikam-Question #2-Page-44 topic 9: Fabrikam-Question #1-Page-45 topic 9: Fabrikam-Question #2-Page-46 topic 9: Fabrikam-Question #3-Page-46 topic 11: Fabrikam-Question #1-Page-47 topic 16: Fabrikam-Question #1-Page-48 ==================================== Total = 7
#1 Y. "database downtime must be minimized when databases are migrated." Offline isn't applicable which doesn't need storage account. Online migration required which needs storage account https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online#configure-migration-settings #2 Y. If this is as per the question is referring to ensure you have storage to render content then Y due to article reference below for static content, otherwise N “Website content must be easily updated from a single point.” https://learn.microsoft.com/en-us/azure/storage/blobs/storage-blob-static-website #3 N. No need for storage for metrics, these will be sent to other Azure services like log analytics
1. Y. Your link is under older tutorials. But it seems under Azure Data Studio the information is similar. Storage or SMB share is required. https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online-ads
Nice. Good spot. Cheers
Nice. Good spot. Cheers
Was in my exam om March. 10
https://www.examtopics.com/discussions/microsoft/view/14121-exam-az-301-topic-15-question-1-discussion/ same ^^
I think it is Yes No Yes Same as question from az-304 - this question has been around for a long time. https://www.examtopics.com/discussions/microsoft/view/56780-exam-az-304-topic-13-question-4-discussion/
You can use Log Analytics Workspace to store the metrics, so it surely NO. Yes No No seems fine
in the Exam April 2024
N,N,Y - lets talk about next kvestion
The first answer should be Y. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online
Yeah seems like from that article, in the prerequisites "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."
Yeah seems like from that article, in the prerequisites "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."
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.
Y,N,Y seem correct if one considers the database requirement of the case study. Be sure to check the requirement before selecting an answer.
I now agree with Y,N,N. It is not compulsory to create a storage account for metrics analysis, Log Analytics workspace in Azure Monitor will suffice.
Answer NO NO YES - are correct
1. SQL Migration: Y because Database migration assistant requires a Storage Account to store the database backup files 2. Web app content: Y Content needs to be updated from an easy to use single point. That's a storage account. I don't consider the available storage that's built into an App Service as easily accessible or a 'single point' 3. Database metrics: N Log Analytics workspace has its own storage, it doesn't require you to link your own storage account (although it's possible)
***Yes:*** [Azure SQL Managed Instance](https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/?view=azuresql): Migrating a database to Azure SQL Managed Instance using Azure Database Migration Service (DMS) requires a storage account. ***Yes:*** [Azure App Service](https://learn.microsoft.com/en-us/azure/app-service/manage-automatic-scaling): Azure App Service can scale and update a web app from a single point with its own built-in storage. ***No:*** [Azure SQL Database Monitoring](https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor?view=azuresql): A storage account is not mandatory for Azure SQL Database monitoring with Log Analytics workspace. You can use Log Analytics workspace for streaming data, but for archiving large amounts of data, storage account is a cheaper option
In my opinion, about the azure app service , "its own built-in storage" suggests exactly the opposite, that is a "NO", meaning that you do not need to buy a separate storage account for that because azure app service already comes with a built-in storage.
However the requirement that web content must be easily updated from a single point suggests that we need a storage account.
To complete my point, I think that because we need to deploy the app to multiple regions, and because the app service plans are per region, then it seems for me that we need a storage account as a single point for keeping the content.
To complete my point, I think that because we need to deploy the app to multiple regions, and because the app service plans are per region, then it seems for me that we need a storage account as a single point for keeping the content.
However the requirement that web content must be easily updated from a single point suggests that we need a storage account.
To complete my point, I think that because we need to deploy the app to multiple regions, and because the app service plans are per region, then it seems for me that we need a storage account as a single point for keeping the content.
To complete my point, I think that because we need to deploy the app to multiple regions, and because the app service plans are per region, then it seems for me that we need a storage account as a single point for keeping the content.
WRONG Yes No No
Website content must be easily updated from a single point. - Y,Y,Y
ANSWER : NO NEED STORAGE ACCOUNT FOR SQL SERVER DATABASE MIGRATION https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance
Without storage account we can only do offline migrations, which means longer downtime. So, to minimize downtime as per requirement, we do need a storage account.
Answer is Y - Y - N no need to have storage account for Metrics Monitoring the below link NO mention of Storage Account needs https://docs.microsoft.com/en-us/azure/azure-monitor/essentials/data-platform-metrics
Answer for Q1 - Storage Account is required. Whether you use the Manual Method of Backup file upload to storage account and restore, or use the DMS Service of Microsoft, Storage Account is a must. https://docs.microsoft.com/en-us/shows/Azure-Videos/Data-migration-demo-using-Azure-Migrate-DMA-and-DMS
YNN Make sure to create the Azure Storage Account in the same region as the Azure Database Migration Service instance is created
They've not provided enough information on the database and application requirement to determine whether we want to do a lift & shift to an Azure VM, migrate to MI or SQL Database. So the suggestion that we must create a storage account is inacurate - you have options where you can migrate without the need for a storage account. Hence, both first and second options have to be false. Answer is: N,o No, Yes.
I think NO NO NO You can use Azure Hybrid Benefits for the Azure SQL database too; the live migration with DMS does not require a storage account for Azure SQL Database You are not forced to use a storage account for the content storage; you could simply upload it to the the web app instances You are not forced to use a storage account to store DB logs, in fact for the database engine telemetry, you need the log analytic workspace https://learn.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql
DMS requires a storage account for both online and offline migration, because that is where it gets the database backup files from to do the restore to the destination SQL database. See https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online-ads
1. **You must provision an Azure storage account for the SQL server database migration**: Yes. Azure Storage is often used as a staging area for migrations, including SQL Server databases. 2. **You must provision an Azure storage account for the web site content storage**: Yes. Azure Storage can be used to store static website content such as HTML, CSS, JavaScript, and image files. 3. **You must provision an Azure storage account for the Database metric monitoring**: No. Database metrics are typically monitored using Azure Monitor and Log Analytics, not Azure Storage. However, logs and metrics could potentially be exported to Azure Storage for long-term retention or further analysis.
Literally no one agrees on this answer so I'll take ChatGPT 4o's answer of YYN and the provided links of jhahn.gp who posted below.
Y,Y,N i'm think correct
Need to sort out correct answer
1. SQL migration. It request minimum downtime. Because of reusing the license requirement from other question with same situation, this migration uses SQL managed instance. There is no need of storage account to create a SQL MI. - The migration entails establishing a network connection between SQL Server and SQL Managed Instance, and opening communication ports. - Uses Always On availability group technology to replicate database near real-time, making an exact replica of the SQL Server database on SQL Managed Instance. - The database can be used for read-only access on SQL Managed Instance while migration is in progress. - Provides the best performance during migration with minimum downtime. Managed Instance link is for customers who require the most performant minimum downtime migration. https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-overview?view=azuresql
SQL Server db migration does not require a storage account in some min.downtime scenarios and I would go with NO for the first point, but what about the existing backups? According to the case study "Database backups must be retained for a minimum of seven years to meet compliance requirements." so perhaps we already have a bunch of them.
it was a exam Question
Final Answer: YYN
Final Answer : N N Y
In case anyone is confused like I was, Azure DMS nearly always require a storage account, whether online or offline, backups are uploaded to a storage account first. It doesn't support live data replication like AWS DMS. The only exception not requiring a storage account is when migrating Azure SQL DB to Azure SQL DB, which is considered a logical migration so the data doesn't actually move.
So, what is the final answer for this?