Analysts occasionally query eligible lake files and want data-scanning cost rather than permanently allocated warehouse compute. Which two choices should be evaluated? Select 2 answers.

Select all that apply. Every correct option and no extras are required for credit in the app.

A.Columnar formats and filter-aligned file partitioning to reduce scanned data
B.A dedicated pool solely because it always bills only bytes scanned
C.Unpartitioned row-oriented files as the guaranteed cheapest scan layout
D.Synapse serverless SQL if its capabilities meet the queries

Show the answer and explanation

✓ Correct answers

Columnar formats and filter-aligned file partitioning to reduce scanned data
Synapse serverless SQL if its capabilities meet the queries

Serverless SQL and efficient file layouts can fit occasional eligible queries. Dedicated capacity bills differently; unpartitioned row-oriented scans may process more data and are not guaranteed cheapest. Source guide: PDF page 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.