Azure Data Fundamentals · 29% of the exam

Describe core data concepts: free practice questions

5 sample questions from our 20-question bank for this domain — answers and explanations included. These are the same scenario-based style as the real Azure exam.

1. Which statement about the difference between a database and a simple file store is MOST accurate?

  • A. A database provides query processing, indexing, and transactional guarantees over managed data; a file store simply persists files✓ Correct
  • B. Databases can only store text, while file stores can store any format
  • C. File stores are always faster than databases for every workload
  • D. Databases cannot run in the cloud
Explanation

What makes a database a database is its management layer: query engines, indexing, concurrency control, and transactional integrity over the data it holds. A file store persists blobs/files without interpreting them. Option B is backwards-ish nonsense — databases store many types. Option C fails for any workload needing queries or transactions. Option D is obviously false (Azure SQL, Cosmos DB).

2. A company is hiring for three data roles. Which responsibility belongs to the DATA ENGINEER rather than the database administrator or data analyst?

  • A. Designing and building data pipelines that ingest, transform, and integrate data from many sources✓ Correct
  • B. Managing database backups, security, and day-to-day operational health
  • C. Building reports and visualizations that answer business questions
  • D. Approving the company's marketing budget
Explanation

Data engineers design and operate the pipelines and integration processes that move and transform data across the estate. Backups, availability, and security administration (B) belong to the database administrator; reports and visualizations (C) to the data analyst. Option D is not a data-platform role responsibility at all.

3. Match the need to the correct Azure data store: the team wants a managed relational engine with near-100% SQL Server compatibility for a legacy app that uses cross-database queries and SQL Agent jobs, with minimal administration.

  • A. Azure SQL Database (single database)
  • B. Azure SQL Managed Instance✓ Correct
  • C. Azure Table Storage
  • D. Azure Blob Storage
Explanation

SQL Managed Instance offers near-complete SQL Server surface compatibility — including cross-database queries and SQL Agent — as a managed PaaS service, exactly for legacy migrations. Single-database Azure SQL (A) lacks some instance-scoped features like SQL Agent. Table Storage (C) is a NoSQL key-value store and Blob (D) an object store — neither is relational.

4. Which file format stores data in a COLUMNAR layout, making it especially efficient for analytical queries that read a few columns from very wide tables?

  • A. CSV
  • B. JSON
  • C. Parquet✓ Correct
  • D. XML
Explanation

Parquet is a columnar format: values for each column are stored together, so an analytical query reading 3 of 200 columns touches only those columns' data — with excellent compression. CSV (A) and JSON (B) are row-oriented text formats; XML (D) is a verbose hierarchical text format. None of the other three offers columnar storage.

5. Which option lists the typical stages of a large-scale analytics architecture in the correct order?

  • A. Visualize → Store → Ingest → Process
  • B. Ingest → Process/transform → Store (lake/warehouse) → Model and visualize✓ Correct
  • C. Delete → Archive → Restore → Report
  • D. Model → Ingest → Visualize → Process
Explanation

Data flows from ingestion (capturing from sources), through processing/transformation, into analytical storage (data lake and/or warehouse), and finally into semantic models, reports, and visualizations. The other orders put consumption before the data exists or aren't analytics lifecycles at all.

15 more questions in this domain

Practice the full bank with instant grading, flashcards, and a timed mock exam.

Start practicing free