Your company has an app named App1 that uses data from the on-premises Microsoft SQL Server databases shown in the following table.

App1 and the data are used on the first day of the month only. The data is not expected to grow more than 3% each year.
The company is rewriting App1 as an Azure web app and plans to migrate all the data to Azure.
You need to migrate the data to Azure SQL Database. The solution must minimize costs.
Which service tier should you use?
Suggested Answer: C
Get Premium AZ-305 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
DTU-based Standard supports databases up to 1 TB in size.
https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu
14 comments · newest first
JI
Jillian
12 months ago
Wait, are we really considering Basic for production? That seems risky!
AR
Aron
1 year ago
vCore-based General Purpose might be a better long-term choice.
VI
Vincenza
1 year ago
But what if performance becomes an issue later?
ME
Melvin
1 year ago
Totally agree, Basic should work fine for low usage!
SH
Sherell
1 year ago
I think DTU-based Basic would be the cheapest option.
CL
Clay
1 year ago
Since the data growth is minimal, maybe the DTU-based Basic tier could work? But I worry it might not handle the app's needs effectively.
CL
Clorinda
1 year ago
I feel like we practiced a similar question about choosing between DTU and vCore models, but I can't recall the exact details.
DE
Desire
1 year ago
I think the DTU-based Standard tier might be a good fit since it balances performance and cost, but I need to double-check the specifics.
TY
Tyra
1 year ago
I remember we discussed the vCore-based options in class, but I'm not sure which one is more cost-effective for this scenario.
CO
Cornell
1 year ago
I'm feeling pretty confident about this one. The best approach is definitely option B - sharing the folders with a 'Sales Managers' public group. That way, you can easily add or remove users from the group as needed, without having to worry about manually updating folder permissions.
TH
Theodora
1 year ago
From what I studied, it seems like both statements could be true, but I'm not entirely confident about that. Should we select option D?
SK
Skye
1 year ago
This is a good question to test our understanding of cloud computing responsibilities. I think the cloud service developer is the role that creates and validates the cloud services, but I'll double-check the other options just to be sure.
DE
Della
1 year ago
Hmm, I'm a bit unsure about the differences between these packet types. I'll need to review my PIM protocol notes to refresh my memory.
AL
Alona
1 year ago
I'm pretty sure Ptunnel and Itunnel are the tools used for ICMP tunneling, but I'll double-check the other options just to be sure.