Exam DP-201 topic 1 question 37 discussion

Actual exam question from Microsoft's DP-201

Question #: 37
Topic #: 1

You plan to deploy a reporting database to Azure. The database will contain 30 GB of data. The amount of data will increase by 300 MB each year.
Rarely will the database be accessed during the second and third weeks of each month. During the first and fourth week of each month, new data will be loaded each night.
You need to recommend a solution for the planned database. The solution must meet the following requirements:
✑ Minimize costs.
✑ Minimize administrative effort.
What should you recommend?

A. an Azure HDInsight cluster
B. Azure SQL Database Hyperscale
C. Azure SQL Database Business Critical
D. Azure SQL Database serverless

Show Suggested Answer

Suggested Answer: D 🗳️
Serverless is a compute tier for single Azure SQL Databases that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.
Incorrect Answers:
A: Azure HDInsight is a managed Apache Hadoop service that lets you run Apache Spark, Apache Hive, Apache Kafka, Apache HBase, and more in the cloud.
B, C: Azure SQL Database Hyperscale and Azure SQL Database Business Critical are based on SQL Server database engine architecture that is adjusted for the cloud environment in order to ensure 99.99% availability even in the cases of infrastructure failures.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview https://docs.microsoft.com/en-us/azure/hdinsight/ https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale

by syu31svc at Dec. 8, 2020, 4:08 p.m.