DP-201 exam

HOTSPOT You have a data model that you plan to implement in an Azure SQL data warehouse as shown in the following exhibit. All the dimension tables will be less than 5 GB after compression, and the fact table will be approximately 6 TB. Which type of table should you...

You are evaluating data storage solutions to support a new application. You need to recommend a data storage solution that represents data by using nodes and relationships in graph structures. Which data storage solution should you recommend?A . Blob StorageB . Cosmos DBC . Data Lake StoreD . HDInsightView AnswerAnswer:...

You are designing an application that will have an Azure virtual machine. The virtual machine will access an Azure SQL database. The database will not be accessible from the Internet You need to recommend a solution to provide the required level of access to the database. What should you include...

You are designing an Azure Cosmos DB database that will support vertices and edges. Which Cosmos DB API should you include in the design?A . SQLB . CassandraC . GremlinD . TableView AnswerAnswer: C Explanation: The Azure Cosmos DB Gremlin API can be used to store massive graphs with billions...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

HOTSPOT You need to design the storage for the Health Insights data platform. Which types of tables should you include in the design? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Hash-distributed tables The new...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

You need to recommend the appropriate storage and processing solution? What should you recommend?A . Enable auto-shrink on the database.B . Flush the blob cache using Windows PowerShell.C . Enable Apache Spark RDD (RDD) caching.D . Enable Databricks IO (DBIO) caching.E . Configure the reading speed using Azure Data Studio.View...

Testlet 1 Case study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that...