Quiz
DP-900 - 3
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (116)
1.... enables multiple Azure SQL databases to share resources such as memory, data storage space, and procesing power.
- AAn elastic pool
- B.
2What is required to provision Azure Data Lake Storage in an Azure Storage account?
- AVersioning must be enabled.
- BHierarchical namespace must be enabled.
- CHierarchical namespace must be disabled.
- DVersioning must be disabled.
3You have data saved in the following format:
- AYAML
- BHTML
- CXML
- DJSON
4In a graph database, edges specify relationships beetween...
- Atables
- B.
5In a data warehousing workload, data...
- Afrom multiple souces is combined in a single location.
- B.
6In batch processing, ...
- Adelay in delivering data procesing results is acceptable.
- B.
7A key/value data store is optimized for...
- Asimple lookups.
- B.
8An Azure Storage account must have ... enabled to support Azure Data Lake Storage.
- AHierarchical namespace
- B.
9You plan to deploy an app. The app requires a nonrelational data service that will provide latency
guarantees of less than 10-ms for reads and writes. What should you include in the solution?- AAzure Cosmos
- BAzure Table storage
- CAzure Files
- DAzure Blob storage
10You can query a graph database in Azure Cosmos DB ...
- Aas nodes and edges by using the Gremlin language.
- B.
11A non-relational database...
- A.
- Bstores data without a fixed schema.
12A relational database must be used when...
- Astrong consistency guarantees are required.
- B.
13Relational data is stored in ...
- A.
- Ba tabular form of rows and columns.
14What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct
answer presents a complete solution NOTE: Each correct selection is worth one point.- Anormalized data
- Bschema defined in a database
- Cschema defined when reading unstructured data from a database
- Dnormalized data 2
- Elight writes and heavy reads
- Fheavy writes and moderate reads
15In a relational database, each row in a table has ...
- A.
- Ba key-value pair.
16... is an object associated with a table that sorts and stores data rows based on their key values.
- A.
- BA clustered index
17An Azure Storage account must have ... enabled to support Azure Data Lake Storage.
- ABlob soft delete
- BHierarchical namespace
- CLarge file shares
- DVersioning
18A bank has a system that manages financial transactions. When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer. Of which ACID semantic is this an example?
- Aatomicity
- Bisolation
- Cdurability
- Dconsistency
19Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates, backups, and maintenance tasks?
- AAzure SQL Managed Instance
- BSQL Server on Azure Virtual Machines
- CAzure SQL Edge
- DAzure SQL Database
20A data engineer is responsible for which task?
- ADesign and build analytical models.
- BDesign and implement data stores for analytical workloads.
- CExplore data to identify trends.
- DImplement policies, tools. and processes for backup and recovery plans.
21... privides a full range of Power BI data modeling and report editing features.
- AMicrosoft Power BI Desktop
- BThe Microsoft Power BI service
- CThe Microsoft Power BI phone app
22HOTSPOT
- ANormalizing a database increases the throughput of writing transactions. Yes.
- BNormalizing a database increases the throughput of writing transactions. No.
- CAnalytics systems are more normalized than transactional systems. Yes.
- DAnalytics systems are more normalized than transactional systems. No.
- ENormalizing a database results in queries that require more joins. Yes.
- FNormalizing a database results in queries that require more joins. No.
23An extract, transform, and load (ETL) process requires ...
- Aa matching schema in the data source and the data target.
- Ba target data store powerful enough to transform data.
- Cdata that is fully processed before being loaded to the target data store.
- Dthat the data target be a relational database.
24In Microsoft Power BI, a .... is a collection of visualizations that appear together on one or more pages.
- Adashboard
- Bdataset
- Creport
- Dtile
25... is a platform as a service (PaaS) relational data service that uses massively parallel processing (MPP).
- AAzure SQL Database
- BAzure Synapse Analytics
- CAzure Database for MariaDB
- DSQL Server on Azure virtual machines
26... physically sorts the data in a table based on the values in a specified column.
- AA view
- BA clustered index
- CA stored procedure
- DA nonclustered index
27HOTSPOT
- AYou must apply operating system udates to Azure SQL databases regularly. Yes.
- BYou need a Microsoft 365 subscription to create an Azure SQL database. Yes.
- CYou can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases. Yes.
- DYou must apply operating system udates to Azure SQL databases regularly. No.
- EYou need a Microsoft 365 subscription to create an Azure SQL database. No.
- FYou can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases. No.
28In a relational database, the ... uniquely identifies each row in a table.
- Aforeign key
- Bprimary key
- CWHERE clause
- Dnonclustered index
29... presents content defined by a query.
- AA heap
- BA stored procedure
- CA view
- DAn index
30... natively support the analysis of relationships between entities.
- AColumn family databases
- BDocument databases
- CGraph databases
- DKey-value stores
31What is a characteristic of non-relational data?
- Aa well-defined schema
- Bno indexes
- Cself.describing entities
- Dno unique key values
32A key/value data store is optimized for...
- Aenforcing constraints
- Bsimple lookups
- Ctable joins
33Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
- AWHERE
- BSELECT
- CJOIN
34Online analytical processing (OLAP) systems are particularly suitable for analytical workloads because data is ...
- Alimited in size.
- Boptimized for transactions.
- Cpre-aggregated.
- Dread-only.
35... provides a full range of Power BI data modeling and report editing features.
- AMicrosoft Power BI Desktop
- BThe Microsoft Power BI service
- CThe Microsoft Power BI phone app
36Which type of database contains nodes and edges?
- Agraph
- Bcolumnar
- Ckey/value
- Dtime series
37... is reponsible for creating visuals and charts that help a company make informed decisions.
- AA data analyst
- BA data engineer
- CA data scientist
- DA database administrator
38Backing up and restoring data are the responsabilities of a ...
- Adata analyst
- Bdata engineer
- Cdata scientist
- Ddatabase administrator
39DRAG DROP
- AKQL --> Azure Data Explorer
- BSQL --> Azure Stream Analytics
- CPython --> Azure Synapse Analytics
40Relational data is stored in ...
- Aa file system as unstructured data
- Ba hierarchical folder structure
- Ca tabular form of rows and columns
- Dcomma-separated value (CSV) files
41A relational database must be used when ...
- Aa dynamic schema is required
- Bdata will be sotred as key/value pairs
- Cstoring large images and videos
- Dstrong consistency guarantees are required
42DRAG DROP
- APyhton --> Azure Synapse Analytics
- BSQL --> Azure Stream Analytics
- CKQL --> Azure Data Explorer
43HOTSPOT
- AYou create Azure File Storage ins a storage account. Yes.
- BYou create Azure File Storage ins a storage account. No.
- CThe Premium tier of Azure File Storage uses HDD-based hardware in a datacenter. Yes.
- DThe Premium tier of Azure File Storage uses HDD-based hardware in a datacenter. No.
- EThe Standard tier of Azure File Storage uses SSDs. Yes.
- FThe Standard tier of Azure File Storage uses SSDs. No.
44... provides a full range of Power BI data modeling and report editing features.
- AMicrosoft Power BI Desktop
- BThe Microsoft Power BI service
- CThe Microsoft Power BI phone app
45You have the following two tables of customer data. Which type of data do the tables contain?
- Anon-relational
- Bstructured
- Csemi-structured
- Dunstructured
46... can be used as part of lift-and-shirt solution for migrating an on-premises application to the cloud with minimal changes.
- AAn Azure SQL Database elastic pool
- BAn instance of SQL Server on Azure Virtual Machines
- CA single database in Azure SQL Database
47... is responsible for identifying which business rules must be applied to the data of a company.
- AA data analyst
- BA data engineer
- CA data scientist
48Which file format has defined names and data types for each column and uses compressed columnar storage?
- AJSON
- BCSV
- CApache Parquet
- DHTML
49You have structured data in tabular format. What represents an individual instance of a data entity?
- Aa column
- Ba cell
- Ca row
- Da table
50In Azure Table storage, each row in a table must be uniquely identified by which two components?
Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.- Aa timestamp
- Ba range
- Ca row key
- Da partition key
51What is a difference between structured data and semi-structured data?
- AStructured data has a fixed schema and semi-structured data has a flexible schema.
- BOnly Structured data supports entities.
- CStructured data has a flexible schema and semi-structured data has a fixed schema.
- DOnly Structured data supports attributes.
52The ... format is used to store delimited data, separates data fields by using commas, and terminates rows by using a carriage return.
- ACSV
- BJSON
- CTSV
- DXML
53The ... file format uses a hierarchical document schema to define data entities that have multiple attributes.
- ACSV
- BJSON
- CORC
- DTSV
54Which language is used to define queries in Azure Synapse Data Explorer?
- ABash
- BPowerShell
- CKQL
- DSQL
55Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL
Server 2019 Enterprise edition?- Aan Azure SQL Database elastic pool
- BAzure SQL Managed Instance
- CAzure Database for MySQL
- DAzure SQL Database
56HOTSPOT
- ADatabase adminsitrators apply data cleasing routines and turn data into useful information. Yes.
- BDatabase adminsitrators apply data cleasing routines and turn data into useful information. No.
- CData engineers manage databases, store backup copies of data, and restore data in the event of a failure. Yes.
- DData engineers manage databases, store backup copies of data, and restore data in the event of a failure. No.
- EData analysts create data visuals and enable companies to make data-driven decisions. Yes.
- FData analysts create data visuals and enable companies to make data-driven decisions. No.
57DRAG DROP
- AExtract, transform, and load (ETL) processing --> Data is retrieved and processed before saved to a target system.
- BData ingestion --> Data is saved to a target system, and then processed.
- CExtract, load, and transform (ELT) processing --> Data is extracted from a source system, and then saved to a target system.
58... is responsible for managing the security of the data in a database.
- AA database administrator
- BA data analyst
- CA data engineer
- DA data scientist
59What can be used with native notebook support to query and visualize data by using a web-based
interface?- AAzure Databricks
- BpgAdmin
- CMicrosoft Power BI
60You have a data store that has the structure shown in the following exhibit. Which type of data store is this?
- Aobject data
- Bgraph
- Ckey/value
- Dtime series
61... is an example of a Data Manipulation Language (DML) statement.
- AUPDATE
- BCREATE
- CDROP
- DRENAME
62... are responsible for the availability, performance, and optimization of databases.
- AData analysts
- BData engineers
- CData scientists
- DDatabase administrators
63In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?
- Abridge
- Bdimension
- Cfact
64DRAG DROP
- AData warehouses --> A solution that copies data from files and online transaction processing (OLTP) databases into an analytical processing system.
- BFact tables --> Contains numeric values that can be analyzed.
- COLAP --> A solution that stores data in a relational schema is optimized for read operations.
65HOTSPOT
- AIn a transactional database that guarantees atomicity, all statements in a transactional must complete succesfully or the transactional must roll back. Yes.
- BIn a transactional database that guarantees atomicity, all statements in a transactional must complete succesfully or the transactional must roll back. No.
- CIn a transactional database that guarantees consistency, all data changes will be logged and accounted for. Yes.
- DIn a transactional database that guarantees consistency, all data changes will be logged and accounted for. No.
- EIn a transactional database that guarantees isolation, processes can see only data in a consistent state. Yes.
- FIn a transactional database that guarantees isolation, processes can see only data in a consistent state. No.
66DRAG DROP
- ADatabase administrator --> Database backup and recovery.
- BData analyst --> Enabling advanced capabilities through reports.
- CData engineer --> Monitoring data pipelines.
67HOTSPOT
- AIn a relational database, the schema is defined before data is written to the table. Yes.
- BIn a relational database, the schema is defined before data is written to the table. No.
- CKey/value data stores are highly optimized for complex queries that contain multiple joins. Yes.
- DKey/value data stores are highly optimized for complex queries that contain multiple joins. No.
- EA relational database is commonly used to store and query structured data. Yes.
- FA relational database is commonly used to store and query structured data. No.
68In a graph database, edges specify relationships between...
- Acolumn families
- Bfacts
- Cvertexes
- Dtables
69The pipeline engine used in Azure Data Factory is also available in ...
- AAzure Databricks
- BAzure HDInsight
- CAzure SQL Database
- DAzure Synapse Analytics
70The Azure Cosmos DB ... enables the use of SELECT statements to retrieve documents from Azure Cosmos DB.
- Afor NoSQL
- Bfor Apache Gremlin
- Cfor MongoDB
- Dfor Table
71Which Azure Cosmos DB API should you use for a graph database?
- AAzure Cosmos DB for Apache Gremlin
- BAzure Cosmos DB for NoSQL
- CAzure Cosmos DB for Apache Cassandra
- DAzure Cosmos DB for Table
72A Microsoft Power BI ... enables users to create highly formatted, fixed-layout documents optimized for printing and archiving.
- Adashboard
- Binteractive report
- Cpaginated report
- Dsubscription
73Batch workloads ...
- Aalways process data in memory, row-by-row.
- Bcollect and process data at most once a day.
- Cprocess data as new data is received in near real-time.
- Dcollect data and then process the data when a condition is met.
74An extract, load, and transform (ELT) process requires ...
- Aa data pipeline that includes a transformation engine.
- Ba separate transformation engine.
- Ca target data store powerful enough to transform data.
- Ddata that is fully processed before being loaded to the target data store.
75Relational data uses ... to enforce relationships between different tables.
- Acollections
- Brows
- Ckeys
- Dpartitions
76Varying fields for each entity in a JSON document is an example of ...
- Arelational data
- Bsemi-structured data
- Cstructured data
- Dunstructured data
77A JSON document that contaons customer entities with a variable number of prpertires is an example of ... data
- Arelational
- Bsemi-structured
- Cstructured
- Dunstructured
78In an aalytical model, any point where the dimensions intersect represents ...
- Aa cube
- Ban aggregated dimension
- Can aggregated measure
79... is responsible for finding hidden patterns in data and creating graphical reports that deliver information in a useful and appealing format.
- AA data analyst
- BA data engineer
- CA database administrator
80In a fully denormalized database, how is data read and written for a single entity?
- AData is read from a single table and written to a single table.
- BData is read from multiple tables and written to a single table.
- CData is read from a single table and written to multiple tables.
- DData is read from multiple tables and written to multiple tables.
81HOTSPOT
- AIn non-relational databases, data is always stored in tables. Yes
- BIn non-relationa databases, data is always by using a fixed shema. Yes
- CIn non-relational databases, two entities in the same collection can have different sets of fields. Yes
- DIn non-relational databases, data is always stored in tables. No
- EIn non-relationa databases, data is always by using a fixed shema. No
- FIn non-relational databases, two entities in the sema collection can have different sets of fields. No
82You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create?
- Aa scalar function
- Ba table
- Can index
- Da view
83Azure Data Explorer uses ... to explore, filter, and aggregate data quickly.
- AKQL
- BPyhton
- CScala
- DSQL
84SELECT, INSERT, and UPDATE are examples of which type of SQL statement?
- AData Definition Language (DDL)
- BData Control Language (DCL)
- CData Manipulation Language (DML)
85You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?
- Aextract transform, and load (ETL)
- Ba data warehouse
- Conline analytical processing (OLAP)
- Donline transaction processing (OLTP)
86The .... service is optimized for IoT solutions.
- AAzure SQL Database
- BAzure SQL Edge
- CAzure SQL Managed Instance
- DSQL Server on Azure Virtual Machines
87... combines a scalable, high-performance Microsoft SQL Server-based relational data warehouse with the flexibility of a data lake and open-source Apache Spark.
- AAzure Databricks
- BAzure HDInsight
- CAzure Stream Analytics
- DAzure Synapse Analytics
88Azure Bloc Storage page blobs are optimized for ...
- Aappend operations
- Brandom read and write operations
- Cstoring key/value data
- Dstoring large binary objects that change infrequently
89DRAG DROP
- AIsolation --> Concurrent transactions cannot interfere with one another and must result in a consistent database state.
- BAtomicity --> Each transaction is treated as a single unit that succeeds completely or fails completely.
- CConsistency --> Transactions can onlu take the data in a database from one valid state to another.
- DDurability --> When a transaction is committed, it will remain committed.
90DRAG DROP
- AData engineer --> Create a pipeline to transrer data from a database to a data warehouse.
- BData architect --> Create a transactional database.
- CData analyst --> Create a chart that shows sales transactions by week.
91DRAG DROP
- AAttributes --> Get separated into individual columns.
- BEntities --> Get separated into individual tables.
- CForeing keys --> Link two related entities.
92Which Azure Storage service implements the key/value model?
- AAzure Files
- BAzure Table
- CAzure Blob
- DAzure Queue
93How is raw data stored in a data lakehoose?
- Aas tables
- Bas queues
- Cas files
- Das disks
94Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?
- AArchive to Cool
- BHot to Cool
- CCool to Archive
- DHot to Archive
95What is the typical latency for read operations against media files stored in the Cool access tier of
Azure Blob Storage?- Aa few milliseconds
- Ba few seconds
- Ca few minutes
- Da few hours
96Which three services support Apache Spark? Each correct answer presents a complete solution
NOTE: Each correct selection is worth one point.- AAzure Data Explorer
- BAzure Synapse Analytics
- CAzure Databricks
- DAzure Stream Analytics
- EAzure HDInsight
97... physically sorts the data in a table based on the values in a specified column.
- AA view
- BA clustered index
- CA stored procedure
- DA nonclustered index
98You have data in a tabular format as shown in the following table. Of which type of data is this an example?
- Aunstructured data
- Bsemi-structured data
- Cdocument
- Dstructured data
99DRAG DROP
Match The Types of data stores to The appropriate scenarios.
To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point- AKey/value --> A list of application user names and, for each, the default language.
- BObject --> A collection of medical images and their associated metadata.
- CGraph --> Employee data that show the relationships between employees.
100What can you use to create data ingestion pipelines?
- AAzure HDInsight
- BAzure SQL Database
- CAzure Data Factory
- DAzure Cosmos DB
101Which service is optimized for loT scenarios that involve streaming time series data?
- ASQL Server on Azure Virtual Machines
- BAzure SQL Managed Instance
- CAzure SQL Database
- DAzure SQL Edge
102Apache Spark Structured Streaming is built on a ... that is used to encapsulate a single table of data.
- Adataframe
- Bdelta lake
- Cdata lake
- Ddata warehouse
103HOTSPOT
- AEach Azure SQL managed instance supports multiple databases that can be accessed by using cross-database queries. Yes.
- BEach Azure SQL managed instance supports multiple databases that can be accessed by using cross-database queries. No.
- CElastic pools are used to share resources across multiple instances of SQL Server on Azure Virtual Machines. Yes.
- DElastic pools are used to share resources across multiple instances of SQL Server on Azure Virtual Machines. No.
- EAzure SQL Database is fully compatible with both on-premises physical instances and virtualized instances of Microsoft SQL Server. Yes.
- FAzure SQL Database is fully compatible with both on-premises physical instances and virtualized instances of Microsoft SQL Server. No.
104HOTSPOT
- AStream processing can process all the data in a dataset at once. Yes.
- BStream processing can process all the data in a dataset at once. No.
- CBatch processing occurs immediately, with latency in the order of seconds of milliseconds. Yes.
- DBatch processing occurs immediately, with latency in the order of seconds of milliseconds. No.
- EStream processing is used for simple response functions, aggregates, or calculations, such as rolling averages. Yes.
- FStream processing is used for simple response functions, aggregates, or calculations, such as rolling averages. No.
105What is the responsibility of a database administrator?
- Aapplying data cleaning routines
- Bcreating data visualizations
- Cmanaging data integration processes
- Dstoring backup copies of data
106What is the responsibility of a database administrator? Which format was used?
- AHTML
- BCSV
- CJSON
- DYAML
107Which service can be used to build extract, transform, and load (ETL) pipelines?
- AAzure SQL Database
- BAzure Pipelines
- CAzure Databricks
- DAzure Cosmos DB
- EAzure Data Factory
108DRAG DROP
- ABatch --> Data for a product catalog wil be loaded every 12 hours to a data warehouse.
- BStreaming --> Thousands of data sets per second for online purchases will be loaded into a data warehouse in real time.
- CBatch --> Updates to inventory data will be loaded to a data warehouse every 1 million transactions.
109Which type of Microsoft Power Bl visual can you use to examine trends over time for one or more
series of values?- Afunnel chart
- Bpie chart
- Ctable
- Dine chart
110You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.
Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point- AJOIN
- BORDER BY
- CINDEX
- DSELECT
- EEXISTS
111You have a database that stores data in the format shown in the following table. Of which type of database is this an example?
- Adocument
- Bcolumn family
- Ckey-value
- Drelational
112DRAG DROP
Match the job roles to the appropriate tasks.
To answer, drag the appropriate job role from the column on the left to its task on the right Each role may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.- ADatabase administrator --> Assign permissions to users.
- BData analyst --> Derive meaning from data by creating visualizations and charts.
- CData engineer --> Implement which pipelines to transfer and transform data between systems.
113Which Azure Cosmos DB API stores data in the BSON format and uses MQL to query the data?
- AMongoDB
- BPostgreSQL
- CApache Gremlin
- DTable
114You need to analyze data by using Azure Databricks.
Which are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE:
Each correct selection is worth one point.- ACreate a Microsoft Power Bl report.
- BCreate an Azure Data Factory pipeline.
- CUse an Apache Spark job to process data stored in an Azure Cosmos DB database.
- DCreate a data flow in Azure Data Factory.
- ECreate an Apache Spark job that will run in a Spark cluster.
115DRAG DROP
Match the data terms to the appropriate descriptions.
To answer, drag the term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.- AAnalytical processing --> Data storage optimized for read operations.
- BTransactional processing --> Data storage optimized for both read and write operations.
- CXML files --> Purpose-built systems for storing vast volumes of historial data.
116Which statement accurately describes data processing?
- ABatch processing requires that data be processed immediately upon arrival.
- BStream processing is typically used for time-critical operations that require an instant response.
- CStream processing is typically used for analyzing larger datasets in less time.
- DBatch processing is typically used for scenarios that require continuous, real-time insights from rapidly arriving data.
Information
- Description
- Quiz on DP-900 - 3, created by Iván Mompó Arnáez on 08/04/2026.
- Author
- Iván Mompó Arnáez
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz