Microsoft Azure Data Fundamentals - DP-900 Exam Practice Test
Select the answer that correctly completes the sentence.
Correct Answer:
Explanation:
A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.
Reference:
https://docs.microsoft.co m/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-repo rting-services?view=sql-server-ver15
Which storage solution supports access control lists (ACLs) at the file and folder level?
Correct Answer: C
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You need to modify a view in a relational database by adding a new column.
Which statement should you use?
Which statement should you use?
Correct Answer: B
Vote an answer
To complete the sentence, select the appropriate option in the answer area.
Correct Answer:
Explanation:
Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question: What's happening?
Diagnostic, to answer the question: Why's happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happe ning-and-what-will-happen-with-iot-analytics/
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer:
Explanation:
Box 1: Azure Cosmos DB
In Azure Cosmos DB ' s SQL (Core) API, items are stored as JSON. The type system and expressions are restricted to deal only with JSON types.
Box 2: Azure Files
Azure Files offers native cloud file sharing services based on the SMB protocol.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json
https://cloud.netapp.com/b log/azure-smb-server-message-block-in-the-cloud-for-azure-files
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?
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Match the ACID terms to the Appropriate descriptions.
To answer, drag the appropriate 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 aft.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate 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 aft.
NOTE: Each correct match is worth one point.
Correct Answer:
You 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.
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.
Correct Answer: A,E
Vote an answer
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Correct Answer:
You have data saved in the following format.
\
Which format was used?
\
Which format was used?
Correct Answer: D
Vote an answer
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.
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.
Correct Answer:
