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

Question 1

You need to store petabytes of unstructured data in Azure with geo-redundant replication and hierarchical namespace support for analytics. Which storage option best meets these requirements?

Accepted Answer

Azure Data Lake Storage Gen2 with GRS

Answer

Azure Data Lake Storage Gen2 provides hierarchical namespace support for analytics workloads along with geo-redundant replication options.

Question 2

Which Azure Synapse Analytics pool type is best suited for running T-SQL queries against data stored in Azure Data Lake Storage Gen2 without loading the data into a dedicated pool?

Accepted Answer

Serverless SQL pool

Answer

Serverless SQL pool in Azure Synapse Analytics allows querying data directly in Azure Data Lake Storage Gen2 using T-SQL without ingesting it.

Question 3

An organization needs to enforce column-level encryption on sensitive data stored in Azure SQL Database. Which feature should they implement?

Accepted Answer

Always Encrypted

Answer

Always Encrypted protects sensitive data at the column level, ensuring the database engine never has access to plaintext values.

Question 4

You are designing a data lake architecture that requires ACID transactions, schema enforcement, and time-travel capabilities on large datasets. Which format should you use?

Accepted Answer

Delta Lake

Answer

Delta Lake provides ACID transactions, schema enforcement, and time-travel (versioning) capabilities on top of data lake storage.

Question 5

Which Azure storage redundancy option provides the highest durability by replicating data synchronously to a secondary region in addition to local copies?

Accepted Answer

Geo-Zone-Redundant Storage (GZRS)

Answer

GZRS combines zone-redundant storage within the primary region with geo-replication to a secondary region, offering the highest durability.

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 2