Microsoft (DP-900) Exam Questions And Answers page 7
What are three characteristics of an OLTP workload?
Multiple Choice
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
heavy writes and moderate reads
light writes and heavy reads
schema on write
schema on read
normalized data
Describe core data concepts in Azure
Describe how to work with relational data on Azure
Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network.
Which type of data store should you use?
Which type of data store should you use?
graph
key/value
document
columnar
Describe core data concepts in Azure
Core Data Concepts
Match the 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 all.
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 all.
NOTE: Each correct match is worth one point.
Core Data Concepts
Working with Data on Azure
Match Azure services to requirements?
DragAndDrop
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service from the column on the left to its requirement 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 requirement on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Working with Data on Azure
Security, Privacy, Compliance, and Trust
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
Introduction to Data Concepts
Core Data Concepts
You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?
When should you implement a read-only database replica?
You need to generate reports without affecting the transactional workload.
You need to audit the transactional application.
You need to implement high availability in the event of a regional outage.
You need to improve the recovery point objective (RPO).
Describe core data concepts in Azure
Describe how to work with relational data on Azure
To complete the sentence, select the appropriate option in the answer area.
Introduction to Data Concepts
Core Data Concepts
To complete the sentence, select the appropriate option in the answer area.
Introduction to Data Concepts
Core Data Concepts
You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Which two settings can you configure at the container level? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
the throughput
the read region
the partition key
the API
Describe core data concepts in Azure
Describe how to work with non-relational data on Azure
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. (Choose two.)
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
data modeling
report and dashboard creation
report sharing and distribution
data acquisition and preparation
Introduction to Data Concepts
Working with Data on Azure
Comments