Question 1

You are designing a data analytics platform using Azure Synapse Analytics.

The data science team needs to query 50 TB of historical log data stored in Azure Data Lake Storage Gen2. They only run these queries sporadically, typically at the end of the month, to generate ad-hoc reports. They require a solution that uses standard T-SQL but minimizes costs by only charging for the queries executed, rather than paying for continuous compute capacity.

Which Synapse Analytics component should you recommend?

Accepted Answer

Match 'sporadic queries', 'T-SQL', and 'pay per query' to the serverless offering in Synapse.

Question 2

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

Accepted Answer

Choosing Dedicated SQL pool. Candidates often assume large data (50 TB) requires a dedicated pool, but serverless is specifically designed for ad-hoc data lake exploration.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam