DP-201

DP-201 practice questions, page 8 of 9, with answer review and explanations.

Question 36

You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytic in a star schema. You plan to have a fact table for website visits. The table will be approximately 5 GB. You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance. What should you recommend? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point. Hot Area:

Question 37

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?

  1. an Azure HDInsight cluster
  2. Azure SQL Database Hyperscale
  3. Azure SQL Database Business Critical
  4. Azure SQL Database serverless

Question 38

You are designing a solution for the ad hoc analysis of data in Azure Databricks notebooks. The data will be stored in Azure Blob storage. You need to ensure that Blob storage will support the recovery of the data if the data is overwritten accidentally. What should you recommend?

  1. Enable soft delete.
  2. Add a resource lock.
  3. Enable diagnostics logging.
  4. Use read-access geo-redundant storage (RA-GRS).

Question 39

You are planning a solution that combines log data from multiple systems. The log data will be downloaded from an API and stored in a data store. You plan to keep a copy of the raw data as well as some transformed versions of the data. You expect that there will be at least 2 TB of log files. The data will be used by data scientists and applications. You need to recommend a solution to store the data in Azure. The solution must minimize costs. What storage solution should you recommend?

  1. Azure Data Lake Storage Gen2
  2. Azure Synapse Analytics
  3. Azure SQL Database
  4. Azure Cosmos DB

Question 40

You are designing a serving layer for data. The design must meet the following requirements: ✑ Authenticate users by using Azure Active Directory (Azure AD). ✑ Serve as a hot path for data. ✑ Support query scale out. ✑ Support SQL queries. What should you include in the design?

  1. Azure Data Lake Storage
  2. Azure Cosmos DB
  3. Azure Blob storage
  4. Azure Synapse Analytics