ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam
Go to Exam

Exam AZ-305 topic 7 question 1 discussion

Actual exam question from Microsoft's AZ-305
Question #: 1
Topic #: 7
[All AZ-305 Questions]

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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Greysi
Highly Voted 3 years, 2 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 70 times
trap
2 years, 11 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, 4 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, 4 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 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, 11 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
11 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, 10 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, 1 month ago
Appeared 2023/01/04 in the exam
upvoted 13 times
...
[Removed]
Most Recent 3 months, 2 weeks ago
WRONG Yes No No
upvoted 2 times
...
ishqms24
3 months, 3 weeks ago
Need to sort out correct answer
upvoted 2 times
...
Teerawee
5 months, 3 weeks ago
Y,Y,N i'm think correct
upvoted 1 times
...
Sephethus
6 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
6 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
4 months, 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
4 months, 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 months, 3 weeks 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
10 months, 1 week ago
in the Exam April 2024
upvoted 4 times
...
varinder82
11 months ago
Final Answer : N N Y
upvoted 1 times
...
varinder82
11 months ago
Final Answer: YYN
upvoted 1 times
...
Paul_white
1 year, 3 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, 3 months ago
it was a exam Question
upvoted 1 times
...
Red0101
1 year, 5 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, 3 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
1 year, 10 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, 6 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, 1 month 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
2 years, 1 month 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
2 years, 1 month 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
2 years 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
2 years ago
Nice. Good spot. Cheers
upvoted 1 times
...
...
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago