ExpertAZ-305 · Question 20 · Domain 2.2: Design data integration
A data engineering team is building a modern data warehouse in Azure.
They have 500 TB of historical telemetry data stored in Parquet format in Azure Data Lake Storage Gen2. Data analysts need to run ad-hoc SQL queries against this data using their existing BI tools (like Power BI and Tableau). The queries are run infrequently (a few times a week), but when they run, they require massive compute power. The company wants to pay only for the queries executed, rather than provisioning dedicated compute clusters 24/7.
Which Azure Synapse Analytics component should you recommend?
A data engineering team is building a modern data warehouse in Azure.
They have 500 TB of historical telemetry data stored in Parquet format in Azure Data Lake Storage Gen2. Data analysts need to run ad-hoc SQL queries against this data using their existing BI tools (like Power BI and Tableau). The queries are run infrequently (a few times a week), but when they run, they require massive compute power. The company wants to pay only for the queries executed, rather than provisioning dedicated compute clusters 24/7.
Which Azure Synapse Analytics component should you recommend?
Answer options:
Serverless SQL pool
Dedicated SQL pool
Apache Spark pool
Azure Data Factory
How to approach this question
Full Answer
Common mistakes
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 1
55 questions · hints · full answers · grading