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:

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/

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

Comments

Submit Cancel

Greysi

Highly Voted 2 years, 11 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 69 times

trap

2 years, 8 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, 1 month 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, 1 month 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

2 years, 9 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

2 years, 8 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

8 months, 3 weeks 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

2 years, 7 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 1 year, 11 months ago

Appeared 2023/01/04 in the exam

upvoted 13 times

...

SeMo0o0o0o

Most Recent 2 weeks, 6 days ago

WRONG Yes No No

upvoted 1 times

...

ishqms24

3 weeks, 2 days ago

Need to sort out correct answer

upvoted 2 times

...

Teerawee

2 months, 3 weeks ago

Y,Y,N i'm think correct

upvoted 1 times

...

Sephethus

3 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 1 times

...

jhahn.gp

3 months, 4 weeks 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 2 times

ValB

1 month, 2 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

1 month, 2 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

3 weeks, 6 days 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

7 months, 1 week ago

in the Exam April 2024

upvoted 4 times

...

varinder82

8 months ago

Final Answer : N N Y

upvoted 1 times

...

varinder82

8 months ago

Final Answer: YYN

upvoted 1 times

...

Paul_white

1 year 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 ago

it was a exam Question

upvoted 1 times

...

Red0101

1 year, 2 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 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

1 year, 7 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, 3 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

1 year, 10 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

...

OPT_001122

1 year, 10 months ago

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

upvoted 8 times

...

RandomNickname

1 year, 10 months ago

#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

upvoted 7 times

testtaker13

1 year, 9 months ago

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

upvoted 2 times

RandomNickname

1 year, 9 months ago

Nice. Good spot. Cheers

upvoted 1 times

...

Load full discussion...