Azure DP-900 Practice - 60 Free Data Fundamentals Questions

Q: How many questions are in this practice set?

This practice set contains 60 questions with detailed explanations.

Q: What topics does this practice cover?

It covers the key topics and question types for Microsoft Azure Data Fundamentals (DP-900), including vocabulary, grammar, reading, and practical test skills.

Q: Are there explanations for every question?

Yes, every question includes a clear explanation so you can understand the correct answer and learn from mistakes.

Q: Can I save my progress and mistakes?

Your wrong answers, favorites, scores, and study streak are saved in your browser, so you can review them on the same device.

Q: What practice modes are available?

You can practice randomly, take a timed mock exam, filter by difficulty, type, and topic, search questions, and review wrong answers.

Question 1

What is structured data?

Select an answer Data sent over a networkData organized in rows and columns with a fixed schemaData with a flexible schema such as JSONData stored as images and videos

Question 2

What is semi-structured data?

Select an answer Data with flexible structure such as JSON or XMLData with a fixed relational schemaData stored only in spreadsheetsData that cannot be queried

Question 3

What is unstructured data?

Select an answer Data represented as key-value pairsData with foreign keysData without a predefined structure such as images, video, and textData stored in relational tables

Question 4

What is a database?

Select an answer A network firewallA web serverA programming languageAn organized collection of data that can be stored and queried

Question 5

What is an OLTP workload?

Select an answer Complex analytical queries over historical dataStoring raw media filesBacking up virtual machinesHigh volumes of short transactions that keep systems current

Question 6

What is an OLAP workload?

Select an answer Complex queries and analysis over large historical datasetsShort online transactionsPrinting documentsSending email

Question 7

What is a data lake?

Select an answer A backup tapeA repository that stores raw data in its native format at scaleA relational database with strict schemasA spreadsheet workbook

Question 8

What is a data warehouse?

Select an answer A virtual networkA file share for documentsA centralized repository optimized for reporting and analyticsA queue for messages

Question 9

Which processing model processes data in defined chunks?

Select an answer Interactive queries onlyTransaction loggingBatch processingStream processing

Question 10

Which processing model handles events as they arrive?

Select an answer Stream processingBatch processingCold storageDatabase indexing

Question 11

What is a table in a relational database?

Select an answer A JSON documentA graph edgeA storage accountA collection of related data organized into rows and columns

Question 12

What is a primary key?

Select an answer A network addressA column or combination of columns that uniquely identifies each rowA column that stores large imagesA backup file

Question 13

What is a foreign key?

Select an answer A column that links a row to a primary key in another tableA column that stores passwordsA duplicate rowA database backup

Question 14

Which language is used to query and manage relational databases?

Select an answer CSSYAMLSQLHTML

Question 15

Which Azure service provides a fully managed relational database?

Select an answer Azure Front DoorAzure SQL DatabaseAzure Blob StorageAzure Queue Storage

Question 16

Which Azure services offer managed MySQL and PostgreSQL databases?

Select an answer Azure Cosmos DB and Table StorageAzure Files and Blob StorageAzure Functions and Logic AppsAzure Database for MySQL and Azure Database for PostgreSQL

Question 17

Which model gives you full control of SQL Server installed on virtual machines?

Select an answer PaaSSaaSFaaSIaaS

Question 18

What does ACID stand for in relational databases?

Select an answer Authentication, compression, integrity, deliveryAtomicity, consistency, isolation, durabilityAccess, control, identity, dataAggregation, clustering, indexing, distribution

Question 19

Which SQL statement retrieves data from a table?

Select an answer SELECTINSERTDELETECREATE

Question 20

Match each relational concept to its meaning.

Primary keyForeign keyTableSQL

Question 21

Which NoSQL data model stores flexible documents such as JSON?

Select an answer Fixed rowSQL viewDocumentRelational table

Question 22

Which NoSQL data model stores simple key-value pairs?

Select an answer DocumentGraphRelationalKey-value

Question 23

Which NoSQL data model stores nodes and relationships?

Select an answer GraphDocumentKey-valueColumnar

Question 24

Which NoSQL data model stores data in wide columns optimized for large scans?

Select an answer DocumentColumnarRelationalGraph

Question 25

Which Azure service is a multi-model NoSQL database?

Select an answer Azure Synapse AnalyticsAzure Cosmos DBAzure SQL DatabaseAzure Database for PostgreSQL

Question 26

Which Azure storage service stores unstructured objects such as images and documents?

Select an answer Azure Blob StorageAzure SQL DatabaseAzure FilesAzure Queue Storage

Question 27

Which Azure storage service stores messages for decoupling application components?

Select an answer Azure Table StorageAzure FilesAzure Cosmos DBAzure Queue Storage

Question 28

Which Azure storage service provides managed SMB file shares?

Select an answer Azure Queue StorageAzure Table StorageAzure FilesAzure Blob Storage

Question 29

Which Azure storage service provides a NoSQL key-value store with simple API access?

Select an answer Azure Table StorageAzure SQL DatabaseAzure SynapseAzure Data Factory

Question 30

Match each NoSQL data model to its primary structure.

DocumentKey-valueGraphColumnar

Question 31

Which Azure service combines data warehousing and big data analytics in one workspace?

Select an answer Azure App ServiceAzure DNSAzure BastionAzure Synapse Analytics

Question 32

Which Azure service orchestrates and schedules data movement pipelines?

Select an answer Azure Virtual MachinesAzure PolicyAzure Data FactoryAzure Blob Storage

Question 33

Which Azure service runs real-time analytics on streaming data?

Select an answer Azure DNSAzure Stream AnalyticsAzure BackupAzure Traffic Manager

Question 34

Which Azure service ingests large volumes of streaming events?

Select an answer Azure Event HubsAzure FilesAzure Table StorageAzure CDN

Question 35

Which Azure service provides a managed Apache Spark-based analytics platform?

Select an answer Azure Front DoorAzure MonitorAzure DatabricksAzure App Service

Question 36

What does ELT mean?

Select an answer Encrypt, log, and transmit dataEvaluate, link, and test dataExport, label, and truncate dataExtract, load, and then transform data

Question 37

What does ETL mean?

Select an answer Export, transform, and truncate dataExtract, transform, and then load dataEncrypt, transfer, and log dataEdit, test, and launch data

Question 38

Which Azure storage service is optimized for big data analytics and data lakes?

Select an answer Azure Data Lake StorageAzure Queue StorageAzure Table StorageAzure CDN

Question 39

What is a data lakehouse?

Select an answer A physical backup roomA relational view onlyA message queueAn architecture that combines data lake storage with warehouse-style analytics

Question 40

Match each Azure analytics service to its main purpose.

Azure Data FactoryAzure Stream AnalyticsAzure Synapse AnalyticsAzure Event Hubs

Question 41

Which Microsoft tool creates interactive reports and dashboards?

Select an answer Power BIAzure DevOpsVisual Studio CodeWindows Terminal

Question 42

Which tool is used to author Power BI reports on a desktop?

Select an answer Azure PortalSQL Server Management StudioPower BI DesktopPower BI Service

Question 43

Where are Power BI reports published and shared with others?

Select an answer Windows ExplorerAzure Blob StoragePower BI ServicePower BI Desktop only

Question 44

What is a Power BI dataset?

Select an answer A virtual machineA set of data connections and tables used to build visualsA network security ruleA web page template

Question 45

What is a Power BI dashboard?

Select an answer A SQL queryA data sourceA backup fileA single-page collection of visualizations

Question 46

What is a measure in Power BI?

Select an answer A DAX formula that calculates a value dynamicallyA fixed text labelA database tableA network port

Question 47

What is row-level security in Power BI?

Select an answer Hiding the toolbarRestricting which data rows a user can seeBlocking all report accessEncrypting report titles

Question 48

Which feature keeps Power BI data current by updating sources on a schedule?

Select an answer Print to PDFColor themesPublish to webScheduled refresh

Question 49

What are Power BI Service workspaces used for?

Select an answer DNS zonesStorage account keysContainers for collaborating on reports and dashboardsVirtual machine disks

Question 50

Match each Power BI component to its purpose.

Power BI DesktopPower BI ServiceMeasureDashboard

Question 51

Which Microsoft tool helps you catalog, classify, and govern data assets?

Select an answer Azure CDNMicrosoft PurviewAzure DevOpsWindows Defender

Question 52

What is data lineage?

Select an answer Deleting duplicate rowsEncrypting passwordsScheduling backupsTracking where data comes from and how it changes

Question 53

What is data classification?

Select an answer Labeling data according to sensitivity and business valueSorting rows alphabeticallyCompressing filesChanging data types

Question 54

Which Azure feature hides sensitive values from query results?

Select an answer Auto-scalingLoad balancingDynamic data maskingRow-level security

Question 55

Which encryption protects data stored on disk?

Select an answer DNSSECSMB signingEncryption at restTLS in transit

Question 56

Which encryption protects data while it travels over networks?

Select an answer Dynamic maskingTLSEncryption at restBitLocker

Question 57

Which access model grants permissions by assigning roles to users and groups?

Select an answer Network security groupsAzure Front DoorAzure MonitorAzure RBAC

Question 58

Which Azure identity service authenticates users and controls access to resources?

Select an answer Microsoft Entra IDAzure DNSAzure Blob StorageAzure Virtual Network

Question 59

What is data residency?

Select an answer Granting temporary accessKeeping data in specific geographic regions to meet requirementsDeleting old logsCompressing large files

Question 60

Match each governance concept to its purpose.

Microsoft PurviewData lineageDynamic data maskingAzure RBAC