DP-203T00: Data Engineering on Microsoft Azure Quiz Questions and Answers
Performing ad hoc data exploration in Azure Synapse Analytics uses which resource model?
Answer :
Serverless SQL pools
Which Azure Synapse Studio hub is where you assign administrator privileges to an Azure Synapse workspace?
Answer :
Manage
What are Azure Synapse Studio notebooks based on?
Answer :
Apache Spark
How can all notebooks in Synapse studio be saved?
Answer :
Select the Publish all button on the workspace command bar
When is it unnecessary to use import statements for transferring data between a dedicated SQL and Apache Spark pool?
Answer :
Use the integrated notebook experience from Azure Synapse Studio
What is a lambda architecture, and what does it try to solve?
Answer :
An architecture that splits incoming data into two paths - a batch path and a streaming path. This architecture helps address the need to provide real-time processing in addition to slower batch computations.
How do you cache data into the memory of the local executor for instant access?
Answer :
.cache()
Which type of transformation in the Mapping Data Flow route data rows to different streams based on matching conditions?
Answer :
Conditional Split
Which SCD type would you use to keep the history of changes in dimension members by adding a new row to the table for each change?
Answer :
Type 2 SCD
Which SCD type would you use to update the dimension members without keeping track of history?
