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?