Microsoft (DP-900) Exam Questions And Answers page 14
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.
heavy writes and moderate reads
light writes and heavy reads
schema defined in a database
schema defined when reading unstructured data from a database
normalized data
Core Data Concepts
Working with Data on Azure
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?
You need to embed documents and query results into a SQL notebook.
What should you use?
Microsoft SQL Server Management Studio (SSMS)
Azure Data Studio
Azure CLI
Azure PowerShell
Describe core data concepts in Azure
Describe how to work with relational data on Azure
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location 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 location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Describe core data concepts in Azure
Working with Data on Azure
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload 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 workload type from the column on the left to its scenario on the right. Each workload 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
Your company is designing a data store that will contain student data. The data has the following format.
Which type of data store should you use?
Which type of data store should you use?
graph
key/value
object
columnar
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
To complete the sentence, select the appropriate option in the answer area.
Introduction to Data Concepts
Core Data Concepts
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown in the fourth quarter?
You have the chart shown in the following exhibit.
Which type of analysis is shown in the fourth quarter?
predictive
prescriptive
descriptive
diagnostic
Core Data Concepts
Security, Privacy, Compliance, and Trust
To complete the sentence, select the appropriate option in the answer area.
Core Data Concepts
Working with Data on Azure
To complete the sentence, select the appropriate option in the answer area.
Introduction to Data Concepts
Core Data Concepts
Comments