DP-200 exam

An application will use Microsoft Azure Cosmos DB as its data solution. The application will use the Cassandra API to support a column-based database type that uses containers to store items. You need to provision Azure Cosmos DB. Which container name and item name should you use? Each correct answer...

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...

Load the data using the CREATE TABLE AS SELECT statement. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: You need to create an external file format and external table using the external data source. You then load the data using the CREATE TABLE AS SELECT...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column Master...

You are the data engineer tor your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. Developers need to access data in the database using an API. You need to determine which API to use for the database model...

Load the data using the CREATE TABLE AS SELECT statement. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: You load the data using the CREATE TABLE AS SELECT statement. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure­data-lake-store

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 questions sets might have more than one correct solution, while others might not have a correct solution. After you...

HOTSPOT You need to ensure phone-based polling data upload reliability requirements are met. How should you configure monitoring? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: FileCapacity FileCapacity is the amount of storage used by...

Topic 3, Misc Questions Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. You develop a data ingestion process that will import data to a Microsoft Azure...

A company has a Microsoft Azure HDInsight solution that uses different cluster types to process and analyze data. Operations are continuous. Reports indicate slowdowns during a specific lime window. You need to determine a monitoring solution to track down the issue in the least amount of time. What should you...