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:
My answer is No No No No, you do not need a Storage account to migrate SQL, all can be done with a replication No, The app service plan comes with a storage No, db metrics does not require it
Correct Answers are No No Yes You can use the Database Migration service to carry out an online migration. Here you don’t need to have a storage account. You can migrate the web site content as it, and you don’t need a separate storage account for this. Yes, for enabling diagnostic setting which stores the database metrics, you can choose the data store as a storage account.
Static website hosting in Azure Storage | Microsoft Docs
Stream metrics and resource logs to Azure Storage. Use Azure storage to archive vast amounts of diagnostic telemetry for a fraction of the cost of the previous two streaming options.
"Web site content must be easily updated from a single point", it clearly indicated it's using storage account for static web contents. So, No, Yes, Yes
Sorry! it is No Yes No. https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal Data streamed to a Log Analytics workspace can be consumed by SQL Analytics. SQL Analytics is a cloud only monitoring solution that provides intelligent monitoring of your databases that includes performance reports, alerts, and mitigation recommendations. So should be log analytics workspace instead of storage account
How do we know that it's a static website? We don't know anything about it. Are they referring to the files of WebApp1? In that case it's an app, not a static website (thus no Storage Account). Or is it something else, which is not related to WebApp1? In that case we have no idea whether it's static or not, whether we need multiple instances or not, whether it must be HA or not. And even if it would be static, we could use App Service Static Web Apps (which does not require a Storage Account). So I'd vote for NNN
Sorry! it is No Yes No. https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal Data streamed to a Log Analytics workspace can be consumed by SQL Analytics. SQL Analytics is a cloud only monitoring solution that provides intelligent monitoring of your databases that includes performance reports, alerts, and mitigation recommendations. So should be log analytics workspace instead of storage account
How do we know that it's a static website? We don't know anything about it. Are they referring to the files of WebApp1? In that case it's an app, not a static website (thus no Storage Account). Or is it something else, which is not related to WebApp1? In that case we have no idea whether it's static or not, whether we need multiple instances or not, whether it must be HA or not. And even if it would be static, we could use App Service Static Web Apps (which does not require a Storage Account). So I'd vote for NNN
Very confusing.... to my knowledge it should be No, Yes, No. Not must to provising Storage account for DB migration. we can do without it. web site content storage we need storage. the last, metric does not use storage, instead log analytic need storage account. I will go for No, Yes, No
Given answers are correct - verified and tested
it says Web site content must be easily updated from a single point. Doesnt that need a storage account?
storage account is not a "must" requirement for metric monitoring. It is one of the possible destinations. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-metrics-diag-logging?tabs=azure-portal
its B1 - NO B2 - NO B3 - YES
No No Yes Database migration service doesn't need a storage account for the migration https://docs.microsoft.com/en-us/azure/dms/dms-overview
SQL Server DB migration, storage account required? > No. The requirement says that database downtime must be minimized while migration is taking place, which I would solve by using "Data Migration Assistant". Web site content, storage account required? > No. I don't see any need for this when using an App Service (PaaS requirement). Database metric monitoring, storage account required? > I'd say No as well, although I am not sure. We would enable the recording of the DB metrics via "Diagnostic Settings". There we can choose between "Send to Log Analytics", "Archive to a storage account" and "Stream to an event hub". Streaming to an event hub doesn't make sense in this scenario as we don't want to do any stream based analysis on top of the metrics. I think its important to keep the metrics for some time for later analysis and both Log Analytics and a storage account would allow for this. So in this scenario I would select Log Analytics and therefor we don't need a storage account.
Requirement Box1: YES minimize downtime, so needs to be an online migration. For online migrations from SQL Server to SQL Managed Instance using Azure Database Migration Service, you must provide the full database backup and subsequent log backups in the SMB network share that the service can use to migrate your databases. When configuring the migration, you need to select the Azure Storage Account that DMS can upload the backup files from the SMB network share to and use for database migration. We recommend selecting the Storage Account in the same region as the DMS service for optimal file upload performance. Requirement Box2: NO Web site content must be easily updated from a single point -> Azure App Services Unpredictable workloads -> The Standard plan includes auto-scale which can automatically adjust the number of virtual machine instances running to match your traffic needs. Requirement Box3: NO you can stream SQL diagnostic telemetry to the following destinations: Log Analytics and SQL Analytics Event Hubs Azure Storage
I agree, although it's a bit hard to read the docs. Only MI explicitly says that you need a Storage account. With SQL DB it only says to open port 445 and allow Storage endpoint, but doesn't explicitly say you need a Storage account. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online#prerequisites https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online#prerequisites
looks like we would need storage account if we use online mode for db migration, since nothing is mentioned whether it would be offline/online i would assume online in that case we would defintely need an storage account for migration. check the important section marked in blue in prerequisites section https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online
Actually, I correct what I said earlier, If it said NO downtime, then you would need to use Azure Database Migration for online migration, which requires a storage account. However, as it says minimize downtime, you can use SQL Transactional replication, which doesn't require a storage account. So storage account is not a must. https://www.sqlshack.com/sql-server-database-migration-to-azure-sql-database-using-sql-server-transactional-replication/
i would say yes, yes, no. storage account is needed for db migration using database migration service and for use as a shared file system between the IIS servers. SQL database analytics appears to create its own storage
actually having see the next question about the migration method I now think migration would be done using transactional replication to minimize downtime so it doesn't need a storage account for the database migration. answers would then be no, yes, no
No, No, Yes Stream metrics and resource logs to Azure Storage. Use Azure storage to archive vast amounts of diagnostic telemetry for a fraction of the cost of the previous two streaming options.
Answer is No No Yes. You need storage for migration only when using BACPAC file , not with DMS. Azure Database Migration Service is a fully managed service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime (online migrations). DMS integrates some of the functionality of our existing tools and services. It provides customers with a comprehensive, highly available solution. The service uses the Data Migration Assistant to generate assessment reports that provide recommendations to guide you through the changes required prior to performing a migration. It's up to you to perform any remediation required. When you're ready to begin the migration process, Azure Database Migration Service performs all of the required steps. You can fire and forget your migration projects with peace of mind, knowing that the process takes advantage of best practices as determined by Microsoft. https://docs.microsoft.com/en-us/azure/dms/dms-overview
no, no , yes
given answer is correct
Does anyone know why this is the correct answer
Focus for this question is in the word "must". You MUST need storage for web content "No" you can use other options too. but for logs and data migration we need storage
No No No
Actually this time you got it wrong.. The first is definitely yes, for online migration you need a cache storage account with either SQL DB and SQL MI. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online#prerequisites https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online#prerequisites
Actually this time you got it wrong.. The first is definitely yes, for online migration you need a cache storage account with either SQL DB and SQL MI. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online#prerequisites https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online#prerequisites
No No No
Actually this time you got it wrong.. The first is definitely yes, for online migration you need a cache storage account with either SQL DB and SQL MI. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online#prerequisites https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online#prerequisites
Actually this time you got it wrong.. The first is definitely yes, for online migration you need a cache storage account with either SQL DB and SQL MI. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online#prerequisites https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online#prerequisites
its right. its a webApp to to place and track orders. Storage is must for CDN. not necessary for this
my answer: no, no, no Log anlytics requests workspace but no storage account
On my exam I will go for No, No and No. Makes most sense to me.
wrong answer. you only need this Yes, for enabling diagnostic setting which stores the database metrics, you can choose the data store as a storage account.
Yes No No
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. From <https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online> Make sure to create a general-purpose v2 Standard storage account . Static websites aren't available in any other type of storage account. From <https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-static-website> You can store metrics and resource logs in Azure Storage by using the built-in Archive to a storage account option in the Azure portal. You can also enable Storage by using diagnostics settings via PowerShell cmdlets, the Azure CLI, or the Azure Monitor REST API. From <https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal> So the answer is YYY
I think the tricky point is in all statements it says "You MUST provision...." Website content storage is optional. Hence the given answer (YNY) seems correct...
For Online DB Migration with DMS we need Storage Account, so it is yes Web Site Content, Not sure but for static Web Sites it is recommended to have Storage account For DB Metrics since requirement is seven years then we must have Storage account I would go for YYY in the exam
Please ignore my previous comment. After seeing other questions and going through the requirements again. I will go for N,N,N :)
Please ignore my previous comment. After seeing other questions and going through the requirements again. I will go for N,N,N :)
For Online DB Migration with DMS we need Storage Account, so it is yes Web Site Content, Not sure but for static Web Sites it is recommended to have Storage account For DB Metrics since requirement is seven years then we must have Storage account I would go for YYY in the exam
Please ignore my previous comment. After seeing other questions and going through the requirements again. I will go for N,N,N :)
Please ignore my previous comment. After seeing other questions and going through the requirements again. I will go for N,N,N :)
Ref: Stream metrics and resource logs to Azure Storage. Use Azure storage to archive vast amounts of diagnostic telemetry for a fraction of the cost of the previous two streaming options. https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview Ans: Yes, NO, Yes (Given answers are correct)