← Interview & exam prep
Microsoft certification practice
DP-900 practice questions
12 exam-style questions for DP-900 — Azure Data Fundamentals, each with the correct answer and why. Then take a timed practice test that also draws on the related skill banks.
12 questionsBeginner 6 · Intermediate 6Answers + explanations
Beginner 6 questions
1Structured data is best described as…
- Audio files
- Free-form text only
- Data in a fixed schema of rows and columns (e.g., a relational table)
- Application logs
- Images and video
Show answerHide answer
C · Data in a fixed schema of rows and columns (e.g., a relational table) Structured data fits a predefined schema of rows/columns.
2A relational database organizes data into…
- A single flat file
- Folders of files
- Key-value pairs only
- Tables with rows, columns and defined relationships
- Graphs only
Show answerHide answer
D · Tables with rows, columns and defined relationships Relational databases use related tables with keys.
3OLTP systems are optimized for…
- Heavy analytical queries
- File archiving
- Streaming video
- Report caching
- Many small transactional reads and writes
Show answerHide answer
E · Many small transactional reads and writes OLTP handles high volumes of short transactions (inserts/updates).
4OLAP systems are optimized for…
- Object storage
- Complex analytical queries over large volumes of data
- Transaction processing
- Message queuing
- App hosting
Show answerHide answer
B · Complex analytical queries over large volumes of data OLAP serves aggregations and analysis over large datasets.
5Non-relational (NoSQL) data stores include…
- Only Excel sheets
- Key-value, document, column-family and graph stores
- Only images
- Only CSV files
- Only relational tables
Show answerHide answer
B · Key-value, document, column-family and graph stores NoSQL covers several models beyond the relational table.
6A data warehouse is primarily used for…
- Real-time chat
- Running a website
- Email delivery
- Storing app code
- Centralized analytical reporting over integrated data
Show answerHide answer
E · Centralized analytical reporting over integrated data Warehouses consolidate data for analytics and BI.
Intermediate 6 questions
7Azure SQL Database is…
- A dashboard tool
- A NoSQL graph store
- A file share
- A message bus
- A managed relational (PaaS) database service
Show answerHide answer
E · A managed relational (PaaS) database service It's a fully-managed relational database in Azure.
8Azure Blob Storage is best suited for…
- Real-time streaming only
- Storing large amounts of unstructured object data
- Hosting semantic models
- Running T-SQL joins
- Relational transactions
Show answerHide answer
B · Storing large amounts of unstructured object data Blob storage holds unstructured objects (files, images, backups) at scale.
9In analytics, ETL/ELT pipelines are used to…
- Move and transform data into an analytical store
- Send notifications
- Manage user logins
- Compress images
- Render visuals
Show answerHide answer
A · Move and transform data into an analytical store Pipelines ingest and shape data for the analytics layer.
10Azure Synapse and Microsoft Fabric provide…
- Email hosting
- Only spreadsheets
- VM management only
- A CRM
- Integrated analytics platforms (warehousing plus big data)
Show answerHide answer
E · Integrated analytics platforms (warehousing plus big data) They unify data warehousing and big-data analytics.
11A key benefit of a managed (PaaS) database is that…
- It can't scale
- The provider handles patching, backups and high availability
- You manage the hardware
- It only runs on-prem
- There is no security
Show answerHide answer
B · The provider handles patching, backups and high availability PaaS offloads infrastructure and maintenance to the cloud provider.
12Stream processing (vs batch) handles…
- Only relational tables
- Continuous, low-latency event data
- Only files
- Only historical data
- Large periodic chunks
Show answerHide answer
B · Continuous, low-latency event data Streaming processes events continuously with low latency.
What changed lately? Latest Microsoft Fabric news, releases & questions →
More microsoft certification practice