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:
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, 5 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, 3 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, 5 months ago
Appeared 2023/01/04 in the exam
upvoted 13 times
...
Aikendrum
Most Recent 3 weeks, 4 days 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, 1 week ago
So, what is the final answer for this?
upvoted 1 times
...
ahhatem
2 months, 4 weeks 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
...
[Removed]
7 months, 2 weeks ago
WRONG Yes No No
upvoted 3 times
...
ishqms24
7 months, 2 weeks ago
Need to sort out correct answer
upvoted 2 times
...
Teerawee
9 months, 2 weeks ago
Y,Y,N i'm think correct
upvoted 2 times
...
Sephethus
9 months, 4 weeks 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
10 months, 3 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 3 times
ValB
8 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
8 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
7 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
1 year, 1 month 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, 2 months ago
Final Answer: YYN
upvoted 1 times
...
Paul_white
1 year, 6 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, 7 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, 1 month 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
...
...
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