Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Suggested Answer:C🗳️
The data engineers must set the SQL Data Warehouse compute resources to consume 300 DWUs. Note: There are three architectural models that are used in Azure SQL Database: ✑ General Purpose/Standard ✑ Business Critical/Premium ✑ Hyperscale Incorrect Answers: A: Business Critical service tier is designed for the applications that require low-latency responses from the underlying SSD storage (1-2 ms in average), fast recovery if the underlying infrastructure fails, or need to off-load reports, analytics, and read-only queries to the free of charge readable secondary replica of the primary database. Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-business-critical
1. "CONT_SQL1 and CONT_SQL2 must use the vCore model", so the answer would be either "Business Critical" or "General Purpose"
2. "replicas and zone redundancy are required", so the final answer is "Business Critical", because it is the only option which offers "zone redundancy storage".
In the vCore-based purchasing model, you can choose between the General Purpose and Business Critical service tiers for SQL Database and SQL Managed Instance.
In the DTU-based purchasing model, you can choose between the basic, standard, and premium service tiers for Azure SQL Database.
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models
>>> CONT_SQL1 and CONT_SQL2 must use the vCore model
VCore allow only general purpose or business critical service tiers.
Since one goal is to contain costs, I'd vote for B (General Purpose)
the diagram on this page can be useful -
https://www.mssqltips.com/sqlservertip/5571/whats-in-a-dtu-choosing-the-right-resource-model-and-service-tier-for-azure-db/
VCore model doesn't have Standart/Premium It has General Purpose, Bus Critical, Hyper..
https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-vcore?tabs=azure-portal
answer B - General purpose
Business critical because it is vCore model and supports 8500 IOP required:
General Purpose boasts 500 IOPS per vCore to a maximum of 7000, while Business Critical is 5000 per vCore up to a maximum of 200,000 IOPS.
https://www.clicdata.com/blog/microsoft-azure-sql-database-vcore-versus-dtu-which-one-to-chose/
"CONT_SQL1 and CONT_SQL2 must use the vCore model"
so C,D and E are out
Between A and B, I'd pick A
https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-business-critical#when-to-choose-this-service-tier
From the above link, there is a segment on updates. Since "The storage should be configured to optimized storage for database OLTP workloads.", Business Critical is the answer
Basic, Standard & Premium are all DTU models - so no!
Both, general purpose & business critical are vCore models. Both support 2TB if you choose at least 12 vCores.
Business critical has the option "zone redundancy", but the scenario asked for "regional outage", so "zone redundancy" isnt enough.
I would take general purpose, because there is no option with a regional redundancy.
By selecting a zone redundant configuration, you can make your Premium or Business Critical databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic. You can also convert any existing Premium or Business Critical databases or pools to the zone redundant configuration.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability#zone-redundant-configuration
Premium supports Zone redundant configuration
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.
Luke97
Highly Voted 4 years agoSedos
3 years, 9 months agoACSC
3 years, 3 months agomemo43
2 years, 11 months agomauromi
Highly Voted 4 years, 5 months agoMK_
4 years, 4 months agomaynard13x8
3 years agomaynard13x8
3 years agodavita8
Most Recent 2 years, 12 months agovmakhija
3 years agoAlexD332
3 years, 1 month agoAlexD332
3 years, 1 month agofelmasri
3 years, 1 month agoJony2
3 years, 1 month agomaynard13x8
3 years agowatata
3 years, 1 month agosyu31svc
3 years, 4 months ago198981309810839189283928938298
3 years, 5 months agoM0e
3 years, 6 months agoDer
3 years, 6 months agoHeady978
3 years, 7 months agowilldy123
3 years, 11 months agoazurearch
3 years, 11 months agoNehuuu
4 years, 1 month agomcurko123
4 years, 2 months agoaratnat
3 years, 4 months ago