Free DP-203 sample questions
These free DP-203 sample questions come with answers and explanations from the retired exam's outline. They cover partitioning, batch and stream processing, and data security. Use them as review, since DP-700 is now the exam to book.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 5 of 11 free sample questions.
You have an enterprise data warehouse in Azure Synapse Analytics.Using PolyBase, you create an external table named [Ext].[Items] to query Parquet files stored in Azure Data Lake Storage Gen2 without importing the data to the data warehouse.The external table has three columns.You discover that the Parquet files have a fourth column named ItemID.Which command should you run to add the ItemID column to the external table?A.B.C.D.

You have an Azure Data Lake Storage Gen2 container that contains 100 TB of data.You need to ensure that the data in the container is available for read workloads in a secondary region if an outage occurs in the primary region. The solution must minimize costs.Which type of data redundancy should you use?
You plan to implement an Azure Data Lake Gen 2 storage account.You need to ensure that the data lake will remain available if a data center fails in the primary Azure region. The solution must minimize costs.Which type of replication should you use for the storage account?
You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated SQL pool. The table contains purchases from suppliers for a retail store. FactPurchase will contain the following columns.FactPurchase will have 1 million rows of data added daily and will contain three years of data.Transact-SQL queries similar to the following query will be executed daily.SELECT -SupplierKey, StockItemKey, IsOrderFinalized, COUNT(*)FROM FactPurchase -WHERE DateKey >= 20210101 -AND DateKey <= 20210131 -GROUP By SupplierKey, StockItemKey, IsOrderFinalizedWhich table distribution will minimize query times?

6 more free samples are waiting
Create a free account to unlock the whole DP-203 sample bank, or get full access to all 302 practice questions in the simulator.