Azure Data Engineer Exam Questions

Q1) Which data platform technology is a globally distributed, multimodel database that can perform queries in less than a second?

• Azure SQL Database
• Azure Cosmos DB
• Azure SQL Data Warehouse
• Azure SQL Managed Instance
  

Correct: Azure Cosmos DB is a globally distributed, multimodel database that can offer subsecond query
performance.

Q2) Which data store is the least expensive choice when you want to store data but don't need to query it?

• Azure Stream Analytics
• Azure Cosmos DB
• Azure Databricks
• Azure Storage
  

Correct: Azure Storage offers a massively scalable object store for data objects and file system services for
the cloud. If you create a Blob storage account, you can't directly query the data.

Q3) Which role works with Azure Cognitive Services, Cognitive Search, and the Bot Framework?

• A data engineer
• A data Analyst
• A data scientist
• An AI engineer
  

Correct: Artificial intelligence (AI) engineers work with AI services such as Cognitive Services, Cognitive Search, and the Bot Framework.

Q4) A JSON file is an example of which type of data?

• Structured
• Semi-structured
• Unstructured
  

Correct: Semi-structured data contains tags that make the organization and hierarchy of the data apparent.

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

• Azure Data Lake.
• Azure Synapse SQL Pools.
• Azure Cosmos DB
• Azure Synapse Spark Pools
  

Correct: Azure Data Lake Store Gen 2 is the technology that will be used to stage data before loading it into the various components of Azure Synapse Analytics.

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

• Studio.
• Copy activity.
• Linked services
• Mapping data flow.
  

Correct: You can natively perform data transformations with Azure Data Factory code free using the Mapping
Data Flow task.