Microsoft Azure Security Engineer Certification Data Engineering on Microsoft Azure: Design & Implement Data Storage 3 — Questions and Answers
Question 1: You need to partition a large fact table in Azure Synapse dedicated SQL pool to optimize query performance. Which column is typically the best partition key?
- A high-cardinality string column like product name
- A date or datetime column used in most queries (Correct answer)
- A foreign key column with low cardinality
- A GUID primary key column
Correct answer: A date or datetime column used in most queries
Date columns are ideal partition keys because most analytical queries filter by time ranges, enabling partition elimination.
Question 2: Which distribution strategy in Azure Synapse dedicated SQL pool minimizes data movement for large fact-to-fact table joins?
- Round-robin distribution
- Replicated distribution
- Hash distribution on the join key (Correct answer)
- Range distribution
Correct answer: Hash distribution on the join key
Hash distributing both tables on the same join key co-locates matching rows on the same node, eliminating data movement during joins.
Question 3: You are implementing Azure Databricks for a machine learning pipeline. Which cluster mode should you use to automatically terminate idle clusters and minimize costs?
- Standard cluster with auto-terminate enabled
- High Concurrency cluster
- Single Node cluster
- Job cluster (Correct answer)
Correct answer: Job cluster
Job clusters are created for a specific job run and automatically terminated when the job completes, minimizing costs for scheduled workloads.
Question 4: Which Azure Purview feature enables data consumers to discover trusted, certified datasets across the organization?
- Data Policy
- Business Glossary (Correct answer)
- Data Classification
- Data Collection
Correct answer: Business Glossary
The Business Glossary in Microsoft Purview allows organizations to define, certify, and document authoritative data assets for discovery.
Question 5: You need to ingest streaming IoT telemetry data into Azure at millions of events per second before processing. Which service should be used as the entry point?
- Azure Service Bus
- Azure Event Hubs (Correct answer)
- Azure Event Grid
- Azure Queue Storage
Correct answer: Azure Event Hubs
Azure Event Hubs is designed for high-throughput telemetry ingestion at millions of events per second, making it the ideal streaming entry point.
Question 6: An Azure Stream Analytics job needs to detect when a sensor reading exceeds a threshold for more than 5 consecutive minutes. Which construct should you use?
- Tumbling window
- Hopping window
- Sliding window (Correct answer)
- Session window
Correct answer: Sliding window
Sliding windows trigger whenever an event occurs and look back a specified duration, making them ideal for detecting sustained conditions.
Question 7: Which feature of Azure Data Lake Storage Gen2 allows you to grant read access to a specific folder without exposing the entire storage account?
- Shared Access Signatures (SAS)
- Storage Account Keys
- ACLs (Access Control Lists) (Correct answer)
- Azure AD Conditional Access
Correct answer: ACLs (Access Control Lists)
ADLS Gen2 supports POSIX-like ACLs at the file and folder level, enabling fine-grained permission control within a hierarchical namespace.
Microsoft Azure Security Engineer Certification Data Engineering on Microsoft Azure: Design & Implement Data Storage 3
You need to partition a large fact table in Azure Synapse dedicated SQL pool to optimize query performance.
Which column is typically the best partition key?