Updated Oct-2021 Test Engine or PDF for the Microsoft DP-900 test to help you quickly prepare for the Microsoft exam!
Full DP-900 Practice Test and 143 unique questions with explanations waiting just for you, get it now!
NEW QUESTION 28
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 29
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 30
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/
NEW QUESTION 31
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
- A. supports a multi-master model
- B. provides resiliency if an Azure region fails
- C. provides a higher storage capacity
- D. supports partitioning
Answer: A
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation:
Multi-master support for Azure Cosmos DB is now available in all public regions.
Azure CosmosDB table API is a key-value storage hosted in the cloud. It's a part of Azure Cosmos DB, that is Microsoft's multi-model database.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/table-support
NEW QUESTION 32
You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?
- A. Cool
- B. Hot
- C. Archive
Answer: C
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation/Reference:
https://cloud.netapp.com/blog/azure-blob-storage-pricing-the-complete-guide-azure-cvo-blg#H1_4
NEW QUESTION 33
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?
- A. Azure HDInsight
- B. SQL Server on Azure virtual machines
- C. Azure SQL Database
- D. Azure Cosmos DB
Answer: C
Explanation:
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://azure.microsoft.com/en-us/services/sql-database/#features
NEW QUESTION 34
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 35
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
- A. streaming
- B. batch
- C. massively parallel processing (MPP)
- D. Online Transaction Processing (OLTP)
Answer: A
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-in/azure/azure-monitor/overview
NEW QUESTION 36
You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?
- A. stream processing
- B. batch processing
- C. Online Analytical Processing (OLAP)
- D. Online Transaction Processing (OLTP)
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation:
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.
Reference:
https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/
NEW QUESTION 37
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.
Answer:
Explanation:
Explanation
Box Ingest: Azure Data Factory
You can build a data ingestion pipeline with Azure Data Factory (ADF).
Box Preprocess & model: Azure Synapse Analytics
Use Azure Synapse Analytics to preprocess data and deploy machine learning models.
NEW QUESTION 38
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?
- A. Azure CLI
- B. Microsoft SQL Server Management Studio (SSMS)
- C. Azure PowerShell
- D. Azure Data Studio
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/
NEW QUESTION 39
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.
- A. light writes and heavy reads
- B. heavy writes and moderate reads
- C. schema on write
- D. denormalized data
- E. normalized data
- F. schema on read
Answer: B,C,F
NEW QUESTION 40
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Answer:
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation/Reference:
https://www.sqlshack.com/graph-database-implementation-with-azure-cosmos-db-using-the-api/
NEW QUESTION 41
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 42
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
- A. streaming
- B. batch
- C. massively parallel processing (MPP)
- D. Online Transaction Processing (OLTP)
Answer: A
Explanation:
Reference:
https://docs.microsoft.com/en-in/azure/azure-monitor/overview
NEW QUESTION 43
You have the following SQL query.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 44
You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.) NOTE: Each correct selection is worth one point.
- A. You must be assigned the Contributor role for the resource group that contains the database.
- B. You must have SELECT access to the Products table.
- C. You must be assigned the Reader role for the resource group that contains the database.
- D. Your IP address must be allowed to connect to the database.
- E. You must have a user in the database.
Answer: C,D,E
NEW QUESTION 45
At which level in Azure Cosmos DB can you configure multiple write regions and read regions?
- A. account
- B. partition
- C. database
- D. collection
Answer: D
NEW QUESTION 46
You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?
- A. PolyBase
- B. Microsoft SQL Server Integration Services (SSIS)
- C. Azure Data Factory
- D. Azure Functions
Answer: A
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html
NEW QUESTION 47
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio
NEW QUESTION 48
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 49
......
Get Latest DP-900 Dumps Exam Questions: https://drive.google.com/open?id=1Iu9djmZEdzU_lWvtKOH_XfF6d8X0jtE0
Full DP-900 Practice Test and 143 unique questions with explanations waiting just for you, get it now: https://www.examsreviews.com/DP-900-pass4sure-exam-review.html