Question 1

A data engineering team is building a data lake architecture on Azure. They have petabytes of raw data stored in Azure Data Lake Storage Gen2 in Parquet format.

Data scientists need to run ad-hoc, exploratory SQL queries directly against this data. The query workload is highly unpredictable—some days there are hundreds of complex queries, and other days there are none. The company wants to pay only for the queries executed, without provisioning dedicated compute clusters that sit idle.

Which Azure Synapse Analytics component should you recommend?

Accepted Answer

Match 'ad-hoc SQL queries directly on data lake' and 'pay only for queries executed' to the serverless compute model.

Question 2

What mistakes do candidates make on this AZ-305 question?

Accepted Answer

Choosing Dedicated SQL pool, which is designed for traditional enterprise data warehousing with predictable, continuous workloads.

How to approach this question

Full Answer

Common mistakes

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3

More questions from this exam