Online Access Free DP-201 Exam Questions

You have a MongoDB database that you plan to migrate to an Azure Cosmos DB account that uses the MongoDB API.
During testing, you discover that the migration takes longer than expected.
You need to recommend a solution that will reduce the amount of time it takes to migrate the data.
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.Increase the Request Units (RUs).
• B.Create compound indexes.
• C.Create unique indexes.
• D.Turn off indexing.
• E.Add a write region.

You need to recommend an Azure Cosmos DB solution that meets the following requirements:
* All data that was NOT modified during the last 30 days must be purged automatically.
* The solution must NOT affect ongoing user requests.
What should you recommend using to purge the data?

• A.Time To Live (TTL) setting in Azure Cosmos DB
• B.an Azure Cosmos DB REST API Delete Document operation called by an Azure function
• C.an Azure Cosmos DB change feed queried by an Azure function
• D.an Azure Cosmos DB stored procedure executed by an Azure logic app

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.
Which type of disk should you recommend?

• A.Standard SSD Managed Disk
• B.Premium SSD Managed Disk
• C.Ultra SSD Managed Disk

You are designing a log storage solution that will use Azure Blob storage containers.
CSV log files will be generated by a multi-tenant application. The log files will be generated for each customer at five-minute intervals. There will be more than 5,000 customers. Typically, the customers will query data generated on the day the data was created.
You need to recommend a naming convention for the virtual directories and files. The solution must minimize the time it takes for the customers to query the log files.
What naming convention should you recommend?

• A.{minute}/{hour}/{day}/{month}/{year}/{CustomeriD}.csv
• B.{year}/{month}/{day}/{CustomerID}/{hour}/{minute}.csv
• C.{year}/{month}/{day}/{hour}/{minute}/{CustomerID}.csv
• D.{CustomerID}/{year}/{month}/{day}/{hour}/{minute}.csv

You have an on-premises data warehouse that includes the following fact tables. Both tables have the following columns: DataKey, ProductKey, RegionKey. There are 120 unique product keys and 65 unique region keys.

Queries that use the data warehouse take a long time to complete.
You plan to migrate the solution to use Azure SQL Data Warehouse. You need to ensure that the Azure-based solution optimizes query performance and minimizes processing skew.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

References:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-distribute