Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 7 question 1 discussion

Actual exam question from Microsoft's AZ-305

Question #: 1
Topic #: 7

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:

Show Suggested Answer

Suggested Answer:

by default_wizard at Dec. 13, 2021, 2:32 p.m.

Comments

Submit Cancel

Greysi

Highly Voted 3 years, 6 months ago

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.

upvoted 72 times

trap

3 years, 3 months ago

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

upvoted 10 times

Galron

2 years, 8 months ago

I agree with this. Been researching all the comments and articles and this is closest fit to the requirement.

upvoted 1 times

Galron

2 years, 8 months ago

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

upvoted 3 times

...

Nichols

3 years, 4 months ago

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).

upvoted 4 times

FrancisFerreira

3 years, 3 months ago

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.

upvoted 6 times

...

chair123

1 year, 3 months ago

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

upvoted 1 times

...

AberdeenAngus

3 years, 2 months ago

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.

upvoted 3 times

...

Load full discussion...

...

honzar

Highly Voted 2 years, 6 months ago

Appeared 2023/01/04 in the exam

upvoted 13 times

...

Aikendrum

Most Recent 1 month ago

To meet Fabrikam's database requirements, the necessary Azure Storage accounts are: 1️⃣ Storage for Performance Metrics & Analysis 1 Azure Storage Account (StorageV2 - General Purpose v2) Stores Azure Monitor & Log Analytics data. Enables historic query performance tracking for optimization. 2️⃣ Storage for Migration & Redundancy 1 Azure Storage Account (Premium Managed Disks / Blob Storage) Ensures fast database replication to minimize downtime. Used for temporary migration backups before full cutover. 3️⃣ Storage for Long-Term Backup Retention 1 Azure Storage Account (Blob Storage with Archive Tier) Enables 7+ years of database backups for compliance. Uses Geo-Redundant Storage (GRS) or Locally Redundant Storage (LRS). Total: 3 Storage Accounts

upvoted 1 times

...

Rwj

2 months, 2 weeks ago

So, what is the final answer for this?

upvoted 1 times

...

ahhatem

3 months ago

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.

upvoted 2 times

...

ishqms24

7 months, 3 weeks ago

Need to sort out correct answer

upvoted 2 times

...

Teerawee

9 months, 3 weeks ago

Y,Y,N i'm think correct

upvoted 2 times

...

Sephethus

10 months ago

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.

upvoted 2 times

...

jhahn.gp

11 months ago

***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

upvoted 3 times

ValB

8 months, 3 weeks ago

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.

upvoted 1 times

ValB

8 months, 3 weeks ago

However the requirement that web content must be easily updated from a single point suggests that we need a storage account.

upvoted 1 times

ValB

8 months ago

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.

upvoted 1 times

...

MHguy

1 year, 2 months ago

in the Exam April 2024

upvoted 4 times

...

varinder82

1 year, 2 months ago

Final Answer : N N Y

upvoted 1 times

...

varinder82

1 year, 3 months ago

Final Answer: YYN

upvoted 1 times

...

Paul_white

1 year, 7 months ago

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.

upvoted 2 times

...

babakeyfgir

1 year, 7 months ago

it was a exam Question

upvoted 1 times

...

Red0101

1 year, 9 months ago

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

upvoted 2 times

kodathedog

1 year, 8 months ago

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

upvoted 1 times

...

yonie

2 years, 2 months ago

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/

upvoted 4 times

sawanti

1 year, 10 months ago

You can use Log Analytics Workspace to store the metrics, so it surely NO. Yes No No seems fine

upvoted 1 times

...

upwork

2 years, 5 months ago

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.

upvoted 1 times

...

Load full discussion...