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

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

Which type of transformation in the Mapping Data Flow is used to route data rows to different streams based on matching conditions?

Answer :
  • Conditional Split

An Extract Transform and Load (ETL) process require____.

Answer :
  • data that is fully processed before being loaded to the target datastore

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 infer the data types and column names when reading a JSON file?

Answer :
  • spark.read.option( "inferSchema ", "true ").json(jsonFile)

How do you cache data into the memory of the local executor for instant access?

Answer :
  • .cache()

Transcribing audio files an example of______.

Answer :
  • Cognitive