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?

Answer :
  • Type 1 SCD