Valid DP-201 Dumps shared by ExamDiscuss.com for Helping Passing DP-201 Exam! ExamDiscuss.com now offer the newest DP-201 exam dumps, the ExamDiscuss.com DP-201 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-201 dumps with Test Engine here:
Access DP-201 Dumps Premium Version
(207 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 30/69
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?
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?
Correct Answer: D
Explanation
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.
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
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.
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
- Question List (69q)
- Question 1: You are designing a solution that will use Azure Databricks ...
- Question 2: You are designing a storage solution to store CSV files. You...
- Question 3: You need to design the system for notifying law enforcement ...
- Question 4: You need to design the solution for the government planning ...
- Question 5: You need to ensure that performance requirements for Backtra...
- Question 6: A company stores large datasets in Azure, including sales tr...
- Question 7: You have a Windows-based solution that analyzes scientific d...
- Question 8: You need to recommend a backup strategy for CONT_SQL1 and CO...
- Question 9: The following code segment is used to create an Azure Databr...
- Question 10: What should you recommend as a batch processing solution for...
- Question 11: You have a large amount of sensor data stored in an Azure Da...
- Question 12: You have an Azure subscription that contains an Azure virtua...
- Question 13: You need to design storage for the solution. Which storage s...
- Question 14: You store data in an Azure SQL data warehouse. You need to d...
- Question 15: Note: This question is part of a series of questions that pr...
- Question 16: You are designing a solution that uses Azure Cosmos DB to st...
- Question 17: Note: This question is part of a series of questions that pr...
- Question 18: You have an on-premises MySQL database that is 800 GB in siz...
- Question 19: You are planning a design pattern based on the Lambda archit...
- Question 20: You are evaluating data storage solutions to support a new a...
- Question 21: You are designing a solution to process data from multiple A...
- Question 22: You are designing a new application that uses Azure Cosmos D...
- Question 23: You are planning a design pattern based on the Kappa archite...
- Question 24: You have an Azure Databricks workspace named workspace1 in t...
- Question 25: You are designing a solution for the ad hoc analysis of data...
- Question 26: You are designing an application that will have an Azure vir...
- Question 27: Note: This question is part of a series of questions that pr...
- Question 28: You need to design the storage for the visual monitoring sys...
- Question 29: You are designing a log storage solution that will use Azure...
- Question 30: You plan to deploy a reporting database to Azure. The databa...
- Question 31: Note: This question is part of a series of questions that pr...
- Question 32: Note: This question is part of a series of questions that pr...
- Question 33: Note: This question is part of a series of questions that pr...
- Question 34: You are designing an Azure SQL Data Warehouse. You plan to l...
- Question 35: You are designing an Azure Synapse solution that will provid...
- Question 36: You are designing a big data storage solution. The solution ...
- Question 37: You manage an on-premises server named Server1 that has a da...
- Question 38: You are designing a solution to store flat files. You need t...
- Question 39: Note: This question is part of a series of questions that pr...
- Question 40: You are planning a streaming data solution that will use Azu...
- Question 41: You design data engineering solutions for a company. You mus...
- Question 42: What should you recommend using to secure sensitive customer...
- Question 43: You discover that the highest chance of corruption or bad da...
- Question 44: You are planning a big data solution in Azure. You need to r...
- Question 45: You are designing a solution for a company. You plan to use ...
- Question 46: You need to design a telemetry data solution that supports t...
- Question 47: A company has locations in North America and Europe. The com...
- Question 48: Note: This question is part of a series of questions that pr...
- Question 49: You have an Azure Data Lake Storage account that has a virtu...
- Question 50: You need to design a solution that meets the business requir...
- Question 51: You need to design the vehicle images storage solution. What...
- Question 52: You are designing an enterprise data warehouse in Azure Syna...
- Question 53: You need to design a solution to meet the SQL Server storage...
- Question 54: You are designing an application. You plan to use Azure SQL ...
- Question 55: You are evaluating the use of an Azure Cosmos DB account for...
- Question 56: You need to recommend a security solution that meets the req...
- Question 57: A company purchases IoT devices to monitor manufacturing mac...
- Question 58: Note: This question is part of a series of questions that pr...
- Question 59: Note: This question is part of a series of questions that pr...
- Question 60: Note: This question is part of a series of questions that pr...
- Question 61: You need to design the storage for the Health Insights data ...
- Question 62: You are designing a data storage solution for a database tha...
- Question 63: You are planning a design pattern based on the Lambda archit...
- Question 64: Which consistency level should you use for Health Interface?...
- Question 65: You are designing a serving layer for data. The design must ...
- Question 66: You need to recommend a solution for storing the image taggi...
- Question 67: You need to design the disaster recovery solution for custom...
- Question 68: A company purchases IoT devices to monitor manufacturing mac...
- Question 69: You plan to use an Azure SQL data warehouse to store the cus...
