Microsoft (DP-900) Exam Questions And Answers page 10
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.
NOTE: Each correct selection is worth one point.
denormalized data
heavy writes and moderate reads
light writes and heavy reads
schema on read
normalized data
Describe core data concepts in Azure
Describe an analytics workload on Azure
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 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. (Choose two.)
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. (Choose two.)
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
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.
Core Data Concepts
Working with Data on Azure
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
document
columnar
graph
time series
Describe how to work with non-relational data on Azure
Core Data Concepts
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
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 an Azure SQL database that you access directly from the Internet.
You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?
You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?
role-based access control (RBAC)
Dynamic Host Configuration Protocol (DHCP)
Domain Name Service (DNS)
a database-level firewall
Describe core data concepts in Azure
Describe how to work with relational data on Azure
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Core Data Concepts
Azure Data Services and Analytics Solutions
Which Azure Data Factory component provides the compute environment for activities?
SSIS packages
an integration runtime
a control flow
a pipeline
Describe core data concepts in Azure
Working with Data on Azure
Comments