WorksheetsPART 2: DP-900: Microsoft Azure Data Fundamentals
Total questions: 100
Worksheet time: 50mins
Name
Class
Date
1.
128- You manage an application that stores data in a shared folder on a Windows server.
a)
A. queue
b)
B. blob
c)
C. file
d)
D. table
2.
129- Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?
a)
A. key/value
b)
B. graph
c)
C. columnar
d)
D. document
3.
130- You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?
a)
A. Azure Files
b)
B. Azure Blob storage
c)
C. Azure Cosmos DB
d)
D. Azure Table storage
4.
132- Your company is designing an application that will write a high volume of JSON data and will have an applicationdefined schema.
Which type of data store should you use?
a)
A. columnar
b)
B. key/value
c)
C. document
d)
D. graph
5.
133- You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?
a)
A. key/value
b)
B. columnar
c)
C. object
d)
D. document
6.
134- Your company is designing a data store for internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?
a)
A. relational
b)
B. time series
c)
C. graph
d)
D. columnar
7.
136- When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a……
a)
A. graph.
b)
B. table.
c)
C. partition key.
d)
D. document.
8.
137- At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer
presents a complete solution.
NOTE: Each correct selection is worth one point.
a)
A. database
b)
B. item
c)
C. container
d)
D. partition
9.
139- What is a characteristic of non-relational data?
a)
A. no indexes
b)
B. self-describing entities
c)
C. a well-defined schema
d)
D. no unique key values
10.
140- ……..is an Azure Synapse Analytics feature that retrieves data from Azure Blob storage by using Transact-SQL queries.
a)
A. A hierarchical namespace
b)
B. Azure Synapse Link
c)
C. PolyBase
d)
D. The Data Movement Service (DMS)
11.
141- You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
a)
A. Online Transaction Processing (OLTP)
b)
B. batch
c)
C. massively parallel processing (MPP)
d)
D. streaming
12.
142- You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must nsure that the data remains intact. What should you do on the dedicated SQL pool?
a)
A. Scale down the data warehouse units (DWUs).
b)
B. Pause the pool.
c)
C. Create a user-defined restore point.
d)
D. Delete the pool
13.
143- Which Azure Data Factory component initiates the execution of a pipeline?
a)
A. a control flow
b)
B. a trigger
c)
C. a parameter
d)
D. an activity
14.
144- Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?
a)
A. stream processing
b)
B. batch processing
c)
C. Online Analytical Processing (OLAP)
d)
D. Online Transaction Processing (OLTP)
15.
147- Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution.
a)
A. report and dashboard creation
b)
B. report sharing and distribution
c)
C. data modeling
d)
D. data acquisition and preparation
16.
148- In Azure Data Factory, you can use ........... to orchestrate pipeline
a)
a control flow
b)
a dataset
c)
a linked service
d)
an integration runtime
17.
149- You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
a)
A. a view
b)
B. a report
c)
C. a dataflow
d)
D. Microsoft Power Apps
18.
150- Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a
complete solution. NOTE: Each correct selection is worth one point.
a)
A. Azure Time Series Insights
b)
B. Azure HDInsight
c)
C. Azure Databricks
d)
D. Azure Log Analytics
19.
151- You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?
a)
A. Online Transaction Processing (OLTP)
b)
B. batch processing
c)
C. Online Analytical Processing (OLAP)
d)
D. stream processing
20.
152- Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
a)
A. a report page
b)
B. a Microsoft PowerPoint slide
c)
C. a visualization from a report
d)
D. a dataflow
e)
E. a text box
21.
154- Which Azure Data Factory component provides the compute environment for activities?
a)
A. SSIS packages
b)
B. an integration runtime
c)
C. a control flow
d)
D. a pipeline
22.
155- A Microsoft Power BI ..... enables users to create highly formatted
a)
dashboad
b)
interactive report
c)
paginated report
d)
subscription
23.
156- What are two uses of data visualization? Each correct answer presents a complete solution.
a)
A. Represent trends and patterns over time
b)
B. Implement machine learning to predict future values
c)
C. Communicate the significance of data
d)
D. Enforce business logic across reports
24.
157- You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse. What should you use to query the files?
a)
A. Azure Functions
b)
B. Microsoft SQL Server Integration Services (SSIS)
c)
C. PolyBase
d)
D. Azure Data Factory
25.
159- What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point
a)
A. Normalized data
b)
B. heavy writes and moderate reads
c)
C. light writes and heavy reads
d)
D. schema defined in a database
e)
E. schema defined when reading unstructured data from a database
26.
160- What is the primary purpose of a data warehouse?
a)
A. to provide answers to complex queries that rely on data from multiple sources
b)
B. to provide transformation services between source and target data stores
c)
C. to provide read-only storage of relational and non-relational historical data
d)
D. to provide storage for transactional line-of-business (LOB) applications
27.
163- In a data warehousing workload, data .......
a)
from a single source is dis tributed to multiple loactions
b)
from multiple source is combined in a single locations
c)
is added to a queue for multiple systems to process
d)
is used to train machine learning models
28.
167- What should you use to build a Microsoft Power BI paginated report?
a)
A. Charticulator
b)
B. Power BI Desktop
c)
C. the Power BI service
d)
D. Power BI Report Builder
29.
170- Which scenario is an example of a streaming workload?
a)
A. sending transactions that are older than a month to an archive
b)
B. sending transactions daily from point of sale (POS) devices
c)
C. sending telemetry data from edge devices
d)
D. sending cloud infrastructure metadata every 30 minutes
30.
171- Batch workloads
a)
Process data in memory row-by-row
b)
collect and process data at most once a day
c)
process data as new data is received in near real time
d)
collect data and then process the data when a condition is met
31.
173- A bar chart showing year-to-date sales by region is an example of which type of analytics?
a)
A. predictive
b)
B. prescriptive
c)
C. descriptive
d)
D. diagnostic
32.
175- You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics. What should you use?
a)
A. Synapse pipelines
b)
B. a Synapse SQL pool
c)
C. Synapse Link
d)
D. Synapse Studio
33.
176- What should you create in Power BI Desktop?
a)
A a waterfall chart
b)
B a ribbon chart
c)
C a bar chart
d)
D a decomposition tree
34.
177- When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a …....
a)
A graph
b)
B table
c)
C partiton key
d)
D document
35.
178- Which type of data do the tables contain?
a)
A structured
b)
B non-relational
c)
C semi-structured
d)
D unstructured
36.
179- You can query a graph database in Azure Cosmos DB
a)
A as nodes and edges by using the Gremlin Language
b)
B as partitioned row store by using Cassandra Query Language (CQL)
c)
C as partitioned row store by using Language - Integrated Query (LINQ)
37.
180- Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache?
a)
A. the Hot access tier
b)
B. change feed
c)
C. snapshots
d)
D. versioning
38.
181- You have an on-premises Microsoft SQL Server database. You need to migrate the database to the cloud. The solution must meet the following requirements:
- Minimize maintenance effort.
- Support the Database Mail and Service Broker features.
- What should you include in the solution?
a)
A. Azure SQL Database single database
b)
B. an Azure SQL Database elastic pool
c)
C. Azure SQL Managed instance
d)
D. SQL Server on Azure virtual machines
39.
182- An extract, transform, and load (ETL) process requires
a)
A. a matching schema in the data source and the data target
b)
B. a target data store powerful enough to transform data
c)
C. data that is fully processed before being loaded to the target data store
d)
D. that the data target be a relational database
40.
183- Batch workloads
a)
A. always process data in memory, row-by-row
b)
B. collect and process data at most once a day
c)
C. process data as new data is received in near real-time
d)
D. collect data and then process the data when a condition is met
41.
185- Descriptive analytics tells you
a)
A. what is most likely to occur in the future
b)
B. what occurred in the past
c)
C. which actions you can perform to affect outcomes
d)
D. why something occurrect in the past
42.
186- What is a function of a modern data warehouse?
a)
A. supports batch processing only
b)
B. supports real-time and batch processing
c)
C. provides built-in or native online analytical processing
d)
D. stores raw data only
43.
187- An Azure Storage account must have……….....enabled to support Azure Data Lake Storage
a)
A. Blob soft delete
b)
B. Hierarchical namespace
c)
C. Large file shares
d)
D. Versioning
44.
188- What can be used with native notebook support to query and visualize data by using a web-based interface?
a)
A. Azure Databricks
b)
B. pgAdmin
c)
C. Microsoft Power BI
45.
189- You have data saved in the following format.
{
"firstname": "John",
"lastName": "Doe",
"age": "23",
"hobbies":[
{ "type": "Sports",value: "Golf" ),
{ "type": "Leisure", "value": "Reading" },
{ "type": "Leisure", "value": "Guitar" }
]
}
Which format was used?
a)
A. XML
b)
B. HTML
c)
C. YAML
d)
D. JSON
46.
190- You have data saved in the following format.
John
Smith
Golf
Reading
Guitar
Which format was used?
a)
A. JSON
b)
B. YAML
c)
C. HTML
d)
D. XML
47.
191- Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
a)
A. consistency
b)
B. atomicity
c)
C. durability
d)
D. isolation
48.
192- A relation database must be used when….....
a)
A. a dynamic schema is required
b)
B. data will be stored as key/value pairs
c)
C. storing large images and videos
d)
D. strong consistency guarantees are required
49.
193- Relational data is stored in…........
a)
A. a file system as unstructured data
b)
B. a hierarchal folder structure
c)
C. a tabular form of rows and columns
d)
D. comma-separated value (CSV) files
50.
194- Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?
a)
A. atomicity
b)
B. durability
c)
C. isolation
d)
D. consistency
51.
195- …........is an object associated with a table that sorts on their key values
a)
A. A clustered index
b)
B. A File Table
c)
C. A foreign key
d)
D. A stored procedure
52.
196- Which Azure Storage service implements the key/value model?
a)
A. Azure Queue
b)
B. Azure Files
c)
C. Azure Table
d)
D. Azure Blob
53.
197- Social media users and follower in a graph database is an example of….....
a)
A. semi-structured data
b)
B. structured data
c)
C. unstructured data
54.
198- In a data warehousing workload, data…......
a)
A. from a single source is distributed to multiple locations
b)
B. from multiple source is combined in a single location
c)
C. is added to a queue for multiple systems to process
d)
D. is used to train machine learning models
55.
199- In batch processing, …......
a)
A. data is always inserted one row at a time
b)
B. data is processed in real-time
c)
C. delay in delivering data processing results is acceptable
d)
D. processing can only execute serially
56.
200- You 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?
a)
A. Azure Blob storage
b)
B. Azure Files
c)
C. Azure Table storage
d)
D. Azure Cosmos DB
57.
201- A non-relational database …....
a)
A. imposes a fixed schema on data
b)
B. store entities without a unique key value
c)
C. stores data in relational tables
d)
D. stores data without a fixed schema
58.
203- You have data saved in the following format. Which format was used?
FirstName, LastName, Age, LeisureHobby, SportsHobby
John, Smith, 23, Reading, Backetball
Ben, Smith, 21, Guitar Curling
Which format was used?
a)
A. YAML
b)
B. CSV
c)
C. JSON
d)
D. HTML
59.
204- ………..is responsible for managing the security of the data in a database
a)
A. A data analyst
b)
B. A data engineer
c)
C. A data scientist
d)
D. A database administrator
60.
205- Backing up and restoring data are the responsibilities of a………
a)
A. data analyst
b)
B. data engineer
c)
C. data scientist
d)
D. database administrator
61.
206- What is required to provision Azure Data Lake Storage in an Azure Storage account?
a)
A. Versioning must be disabled.
b)
B. Hierarchical namespace must be disabled.
c)
C. Versioning must be enabled.
d)
D. Hierarchical namespace must be enabled.
62.
207- Microsoft SQL Server database tables store……
a)
A. non-relational data
b)
B. relational data
c)
C semi-structured data
63.
208- …… can be used as part of a lift-and-shift solution for migrating an on-premises application to the cloud with minimal changes.
a)
A. An Azure SQL Database elastic pool
b)
B. An instance of SQL Server on Azure Virtual Machines
c)
C. A single database in Azure SQL Database
64.
209- In Microsoft Power BI, a……is a collection of visualizations that appear together on one or more pages
a)
A. dashboard
b)
B. datasset
c)
C. report
d)
D. tile
65.
211- What is used to define a query in a stream processing jobs in Azure Stream Analytics?
a)
A. YAML
b)
B. KQL
c)
C. SQL
d)
D. XML
66.
212- .... Enables multiple Azure SQL databases to share resources such as memory, data storage space, and processing power.
a)
An Azure SQL server
b)
An elastic pool
c)
The Data Migration Assistant (DMA)
d)
A virtual network
67.
213- XML-formatted files are examples of
a)
relational data.
b)
semi-structured data.
c)
unstructured data.
68.
214- In a fully normalized database, how is data read and written for a single entity?
a)
A. Data is read from multiple tables and written to multiple tables.
b)
B. Data is read from a single table and written to a single table.
c)
C. Data is read from a single table and written to multiple tables.
d)
D. Data is read from multiple tables and written to a single table.
69.
215- What is a primary characteristic of a relational database?
a)
A. a flexible data structure
b)
B. data is queried and manipulated by using a variant of the SQL language
c)
C. a lack of dependencies between tables
d)
D. a large amount of duplicate data
70.
216- The ...... clause can be used in Data Manipulation Language (DML) statements to specify the criteria that rows must match.
a)
ALTER
b)
JOIN
c)
SET
d)
WHERE
71.
217- Which statement is an example of Data Manipulation Language (DML)?
a)
A. GRANT
b)
B. INSERT
c)
C. REVOKE
d)
D. DROP
72.
218- What is a characteristic of a non-relational database?
a)
A. full support for Transact-SQL
b)
B. a fixed schema
c)
C. self-describing entities
73.
219- What should you use to automatically delete blobs from Azure Blob Storage?
a)
A. archive storage
b)
B. the change feed
c)
C. soft delete
d)
D. a lifecycle management policy
74.
220- In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents part of the solution.
a)
A. a partition key
b)
B. a range
c)
C. a row key
d)
D. a timestamp
75.
221- .... is responsible for creating visuals and charts that help a company make informed decisions.
a)
A data analyst
b)
A data engineer
c)
A data scientist
d)
A database administrator
76.
222- You need to store event log data that is semi-structured and received as the logs occur. What should you use?
a)
A. Azure Table storage
b)
B. Azure Queue storage
c)
C. Azure Files
77.
223- Which Azure Cosmos DB API should you use for a graph database?
a)
A. Table
b)
B. Cassandra
c)
C. Core (SQL)
d)
D. Gremlin
78.
225- ..... enables multiple Azure SQL databases to share resources such as memory, data storage space, and processing power.
a)
An Azure SQL server
b)
An elastic pool
c)
The Data Migration Assistant (DMA)
d)
A virtual network
79.
226- A 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?
a)
A. atomicity
b)
B. durability
c)
C. consistency
d)
D. isolation
80.
228- Select the answer that correctly completes the sentence. When provisioning an Azure Cosmos DB, you need to specify which type of API you will use.
a)
account
b)
container
c)
database
d)
item
81.
229- A data engineer is responsible for which task?
a)
A. Explore data to identify trends.
b)
B. Implement policies, tools, and processes for backup and recovery plans.
c)
C. Design and build analytical models.
d)
D. Design and implement data stores for analytical workloads.
82.
230- The massively parallel processing (MPP) engine of Azure Synapse Analytics .........
a)
distributes processing across compute nodes.
b)
distributes processing across control nodes.
c)
redirects client connections across compute nodes.
d)
redirects client connections across control nodes.
83.
231- Data in a data warehouse can be aggregated and loaded into an online analytical processing (OLAP) model, which is also known as a .....
a)
cube.
b)
data lake
c)
dimension
d)
measure
84.
232- ..... are used to compare two numeric measures and identify a relationship or correlation between them.
a)
Bar charts
b)
Pie charts
c)
Scatter charts
d)
Tables
85.
233- A block of code that runs in a database is called .....
a)
a stored procedure.
b)
a table.
c)
a view.
d)
an index.
86.
234- Which file format has defined names and data types for each column and uses compressed columnar storage?
a)
A. HTML
b)
B. CSV
c)
C. Apache Parquet
d)
D. JSON
87.
235- A relational database is appropriate for scenarios that involve a high volume of ......
a)
changes to relationships between entities.
b)
geographically distributed writes.
c)
transactional writes.
d)
writes that have varying data structures.
88.
238- In a graph database, edges specify relationships between ....
a)
column families
b)
facts
c)
vertexes
d)
tables
89.
239- Relational databases are commonly used to store and query ....
a)
blobs.
b)
semi-structured data.
c)
structured data.
d)
unstructured data.
90.
240- Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server
instances, while providing automated updates. backups, and maintenance tasks?
a)
A. Azure SQL Managed Instance
b)
B. SQL Server on Azure Virtual Machines
c)
C. Azure SQL Database
d)
D. Azure SQL Edge
91.
241- Relational data uses ..... to enforce relationships between different tables.
a)
collections
b)
rows
c)
keys
d)
partitions
92.
242- An extract load, and transform (ELT) process requires ......
a)
a data pipeline that includes a transformation engine.
b)
a separate transformation engine.
c)
a target data store powerful enough to transform data.
d)
data that is fully processed before being loaded to the target data store
93.
243- In an analytical model designed as a star schema, the entities by which you aggregate or slice measures are called .....
a)
cubes.
b)
dimensions.
c)
facts.
d)
schemas.
94.
246- The Azure Cosmos DB …........ API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB
a)
for NoSQL
b)
for Apache Gremlin
c)
for MongoDB
d)
for Table
95.
248- …........... Provides a full range of Power BI data modeling and report editing features
a)
Microsoft Power BI Desktop
b)
The Microsoft Power BI service
c)
The Microsoft Power BI phone app
96.
249- After you create Microsoft Power BI data models and reports, you can publish them to …......
a)
Power BI Desktop
b)
Powe Query
c)
The Power BI phone app
d)
The Power BI service
97.
250- Which type of Azure resource supports the serverless configuration of an Azure SQL database?
a)
A. SQL Server on Azure Virtual Machines
b)
B. an Azure SQL Database elastic pool
c)
C. a single database in Azure SQL Database
d)
D. Azure SQL Managed Instance
98.
251- Online analytical processing (OAP) systems are particularly suitable for analytical workloads because data is …...........
a)
limited in size
b)
optimized for transactions
c)
pre-aggregated
d)
read-only
99.
253- Which Azure Cosmos DB API should you use for a graph database?
a)
A. Table
b)
B. Cassandra
c)
C. NoSQL
d)
D. Gremlin
100.
254- A Microsoft Power BI …............. Enables users to create highly formatted, fixed-layout documents optimized for printing and archiving
a)
dashboard
b)
interactive report
c)
paginated report
d)
subscription
100 %
