Microsoft Azure Security Engineer Certification Data Engineering on Microsoft Azure: Design & Implement Data Storage 5

Question 1

You need to implement a medallion architecture in Azure Data Lake Storage Gen2. Which layer should contain cleaned, validated, and conformed data ready for analytics?

Accepted Answer

Silver layer

Answer

The Silver layer in the medallion architecture contains cleansed, validated, and conformed data that has been processed from the raw Bronze layer.

Question 2

Which Azure Synapse Analytics feature allows you to query external data sources like Azure Cosmos DB directly using T-SQL without data movement?

Accepted Answer

Azure Synapse Link

Answer

Azure Synapse Link creates a direct connection to Cosmos DB's analytical store, enabling T-SQL and Spark queries without ETL or data movement.

Question 3

You must encrypt data stored in Azure Data Lake Storage Gen2 using customer-managed keys. Where should the keys be stored?

Accepted Answer

Azure Key Vault

Answer

Customer-managed keys for Azure Storage encryption must be stored in Azure Key Vault, which manages the key lifecycle and access.

Question 4

In Azure Databricks, which table format feature allows you to query data as it existed at a specific point in the past using a timestamp or version number?

Accepted Answer

Delta Lake time travel

Answer

Delta Lake's time travel feature lets you query historical versions of a table using VERSION AS OF or TIMESTAMP AS OF syntax.

Question 5

Which Azure Stream Analytics windowing function creates non-overlapping, fixed-duration windows that group events into distinct time buckets?

Accepted Answer

Tumbling window

Answer

Tumbling windows are fixed-duration, non-overlapping windows where each event belongs to exactly one window.

Microsoft Azure Security Engineer Certification Practice Test

Microsoft Azure Security Engineer Certification Practice Test

Microsoft Azure Security Engineer Certification Data Engineering on Microsoft Azure: Design & Implement Data Storage 5