DP-203 Exam Question 1
You need to implement an Azure Databricks cluster that automatically connects to Azure Data lake Storage Gen2 by using Azure Active Directory (Azure AD) integration. How should you configure the new clutter? To answer, select the appropriate options in the answers are a. NOTE: Each correct selection is worth one point.
DP-203 Exam Question 2
You have the following Azure Stream Analytics query.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
DP-203 Exam Question 3
You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and will include the following columns:
You identify the following usage patterns:
* Analysts will most commonly analyze transactions for a warehouse.
* Queries will summarize by product category type, date, and/or inventory event type.
You need to recommend a partition strategy for the table to minimize query times.
On which column should you partition the table?
You identify the following usage patterns:
* Analysts will most commonly analyze transactions for a warehouse.
* Queries will summarize by product category type, date, and/or inventory event type.
You need to recommend a partition strategy for the table to minimize query times.
On which column should you partition the table?
DP-203 Exam Question 4
You have the Azure Synapse Analytics pipeline shown in the following exhibit.
You need to add a set variable activity to the pipeline to ensure that after the pipeline's completion, the status of the pipeline is always successful.
What should you configure for the set variable activity?
You need to add a set variable activity to the pipeline to ensure that after the pipeline's completion, the status of the pipeline is always successful.
What should you configure for the set variable activity?
DP-203 Exam Question 5
A company plans to use Platform-as-a-Service (PaaS) to create the new data pipeline process. The process must meet the following requirements:
Ingest:
* Access multiple data sources.
* Provide the ability to orchestrate workflow.
* Provide the capability to run SQL Server Integration Services packages.
Store:
* Optimize storage for big data workloads.
* Provide encryption of data at rest.
* Operate with no size limits.
Prepare and Train:
* Provide a fully-managed and interactive workspace for exploration and visualization.
* Provide the ability to program in R, SQL, Python, Scala, and Java.
* Provide seamless user authentication with Azure Active Directory.
Model & Serve:
* Implement native columnar storage.
* Support for the SQL language
* Provide support for structured streaming.
You need to build the data integration pipeline.
Which technologies should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Ingest:
* Access multiple data sources.
* Provide the ability to orchestrate workflow.
* Provide the capability to run SQL Server Integration Services packages.
Store:
* Optimize storage for big data workloads.
* Provide encryption of data at rest.
* Operate with no size limits.
Prepare and Train:
* Provide a fully-managed and interactive workspace for exploration and visualization.
* Provide the ability to program in R, SQL, Python, Scala, and Java.
* Provide seamless user authentication with Azure Active Directory.
Model & Serve:
* Implement native columnar storage.
* Support for the SQL language
* Provide support for structured streaming.
You need to build the data integration pipeline.
Which technologies should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
