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








 

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

This question is in DP-201 Designing an Azure Data Solution Exam
For getting Microsoft Certified: Azure Data Engineer Associate Certificate



Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.