Pertemuan 4 - 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

• Apache Spark pool

• Pipelines

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

• Dedicated SQL pool

• Apache Spark 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 SQL script connected to a serverless SQL pool.

• A KQL script connected to a Data Explorer pool.

Which Azure Service is Azure Synapse Pipelines based on?

• Azure Data Explorer

• Azure Stream Analytics

• Azure Data Factory

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

• Data

• Develop

• Integrate

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

• Azure Data Lake

• Azure Synapse SQL Pools

• Azure Synapse Spark Pools

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

• Studio

• Copy activity

• Mapping Data Flow