A team needs an integrated Azure analytics environment with SQL, Spark, and pipelines, plus allocated distributed warehouse capacity. Which service/configuration fits?

Choose the single best answer.

A.Azure Synapse Analytics with a suitable dedicated SQL pool
B.Synapse serverless SQL assumed to have every dedicated warehouse capability
C.Azure SQL Database alone assumed to supply the integrated SQL/Spark/pipeline environment
D.Data Factory Copy Activity alone as the allocated distributed warehouse serving engine

Show the answer and explanation

✓ Correct answer

Azure Synapse Analytics with a suitable dedicated SQL pool

Synapse dedicated SQL pools supply allocated distributed warehouse processing within the broader SQL/Spark/pipeline platform. Serverless has different capabilities/cost. SQL Database alone does not provide that integrated environment, and Copy Activity moves data rather than supplies the warehouse serving engine. Source guide: PDF page 33-34.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.