Mock 1 | Microsoft Certified: Azure Data Fundamentals [DP 900]
Welcome to Mock 1 | Microsoft Certified: Azure Data Fundamentals [DP 900] mock exam. We are bound to provide you the best quality exam mocks absolutely free.
Wishing you all the best!!!
1 / 50
You have an e-commerce application that reads and writes data to an Azure SQL database.Which type of processing does the application use?
2 / 50
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.You need to embed documents and query results into a SQL notebook.What should you use?
3 / 50
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.Which Azure service should you use?
4 / 50
You have an inventory management database that contains the following table.
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
5 / 50
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:
[Select From Dropdown] is responsible for identifying which business rules must be applies to the data of a company.
6 / 50
Which type of database contains nodes and edges?
7 / 50
You have a data store that has the structure shown in the following exhibit.
8 / 50
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
9 / 50
A JSON document is an example of [Select From Dropdown]
10 / 50
Varying fields for each entity in a JSON document is an example of [Select From Dropdown].
11 / 50
Select the answer that correctly completes the sentence.Hot Area:
In an Infrastructure as a service (IaaS) instance of Microsoft SQL Server on Azure, you manage the [Select From Dropdown] that hosts SQL Server
12 / 50
A key/value data store is optimized for [Select From Dropdown]
13 / 50
[Select From Dropdown] natively support the analysis of relationships between entities.
14 / 50
For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
15 / 50
Select the answer that correctly completes the sentence.
In a relational database, each row in a table has [Select From Dropdown].
16 / 50
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.
17 / 50
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.
In a SQL statement, [Select From Dropdown] are examples of aggregate functions.
18 / 50
What is a characteristic of batch processing?
19 / 50
A [Select From Dropdown] is a chart of colored rectangles. The size of the rectangles represents the relative value of each item. The chart can be hierarchical, displaying data as a set of rectangles nested within the main rectangle.
20 / 50
Which storage solution supports access control lists (ACLs) at the file and folder level?
21 / 50
Which type of database is Azure Database for PostgreSQL?
22 / 50
You have an application that runs on Windows and requires across to a mapped drive. Which Azure service should you use?
23 / 50
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.
A block of code that runs in a database is called [Select From Dropdown].
24 / 50
You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?
25 / 50
Relational data is stored in [Select From Dropdown]
26 / 50
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
27 / 50
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.What should you use in Microsoft Power BI?
28 / 50
29 / 50
You need to modify a view in a relational database by adding a new column. Which statement should you use?
30 / 50
The Azure Cosmos DB [Select From Dropdown] API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB.
31 / 50
You need to create an Azure resource to store data in Azure Table storage. Which command should you run?
32 / 50
Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
33 / 50
Creating closed caption text for audio files is an example of [Select From Dropdown] analytics.
34 / 50
Which statement is an example of Data Manipulation Language (DML)?
35 / 50
What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.
36 / 50
37 / 50
You 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?
38 / 50
39 / 50
You need to create an Azure Storage account.Data in the account must replica outside the Azure region automatically.Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one pint.
40 / 50
A visualization that illustrates a university's current student enrollment per department is an example of [Select From Dropdown] analytics.
41 / 50
42 / 50
A relational database must be used when [Select From Dropdown]
43 / 50
44 / 50
The massively parallel processing (MPP) engine of azure Synapse Analytics [Select From Dropdown].
45 / 50
Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit.
46 / 50
Transcribing audio files is an example of [Select From Dropdown] analytics.
47 / 50
To complete the sentence, select the appropriate option in the answer area.
In batch processing, [Select Dropdown]
48 / 50
An extract, transform and load (ETL) process requires [Select From Dropdown]
49 / 50
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
50 / 50
Descriptive analytics tells you [Select From Dropdown].
Your score is
The average score is 0%
Restart quiz
