Practice Free DP-900 Exam Online Questions
Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.
Which type of data store should you use?
- A . graph
- B . key/value
- C . document
- D . columnar
A
Explanation:
Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.
A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB’s Gremlin API supports the property graph model.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases
DRAG DROP
Match the data terms to the appropriate descriptions.
To answer, drag the 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.
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown for the fourth quarter?
- A . predictive
- B . prescription
- C . descriptive
- D . diagnostic
A
Explanation:
Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?
- A . Azure Cosmos DB
- B . Azure Synapse Analytics
- C . Azure HDInsight
- D . Azure SQL Database
D
Explanation:
Azure SQL Database is relational database and a managed service.
Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?
- A . extract transform, and load (ETL)
- B . a data warehouse
- C . online analytical processing (OLAP)
- D . online transaction processing (OLTP)