Big Quiz - Azure Data Engineer

Which feature of Azure Synapse Analytics enables you to transfer data from one store to another and apply transformations to the data at scheduled intervals?

• Serverless SQL pool

• Pipelines

• Apache Spark pool

You want to create a data warehouse in Azure Synapse Analytics in which the data is stored and queried in a relational data store. What kind of pool should you create?

• Serverless SQL pool

• Apache Spark pool

• Dedicated SQL pool

A data analyst wants to analyze data by using Python code combined with text descriptions of the insights gained from the analysis. What should they use to perform the analysis?

• A notebook connected to an Apache Spark pool

• A KQL script connected to a Data Explorer pool

• A SQL script connected to a serverless SQL pool

Which Azure Service is Azure Synapse Pipelines based on?

• Azure Data Explorer

• Azure Data Factory

• Azure Stream Analytics

Which Azure Synapse Studio hub would you go to create Notebooks?

• Data

• Integrate

• Develop

Which technology is typically used as a staging area in a modern data warehousing architecture?

• Azure Data Lake

• Azure Synapse Spark Pools

• Azure Synapse SQL Pools

Which component enables you to perform code free transformations in Azure Synapse Analytics?

• Studio

• Mapping Data Flow

• Copy activity

In which order should you load tables in the data warehouse?

• Staging tables, then dimension tables, then fact tables

• Dimension tables, then staging tables, then fact tables

• 
  Staging tables, then fact tables, then dimension tables

Which command should you use to load a staging table with data from files in the data lake?

• COPY

• INSERT

• LOAD

When a customer changes their phone number, the change should be made in the existing row for that customer in the dimension table. What type of slowly changing dimension does this scenario require?

• Type 0

• Type 1

• Type 2