Microsoft Azure Data Fundamentals DP-900 Practice Question
You are selecting a file format for a large fact-sales dataset that will be saved in Azure Data Lake Storage Gen2 and queried by Azure Synapse Analytics and Azure Databricks. The chosen format must minimize storage size, embed schema information, and let the engines read only the required columns instead of scanning every row. Which file format should you use?
Apache Parquet is a columnar storage format that stores data by column rather than by row. Because it is column-oriented, analytical engines such as Synapse and Databricks can read only the columns they need, which reduces I/O. Parquet files also include metadata that describes the schema and apply efficient compression and encoding to reduce storage size. CSV, JSON, and fixed-width text are row-oriented formats that lack built-in column pruning and typically consume more space for large analytical datasets.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
Why is Apache Parquet a columnar format, and how does it differ from row-oriented formats like CSV?
Open an interactive chat with Bash
What is schema information, and why is it important for file formats like Parquet?
Open an interactive chat with Bash
How does Parquet's compression improve storage efficiency compared to other file formats like JSON?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Describe core data concepts
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .