Free DP-900 Exam Braindumps (page: 33)

Page 33 of 72

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?

  1. graph
  2. key/value
  3. document
  4. columnar

Answer(s): 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



HOTSPOT (Drag and Drop is not supported)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: Yes
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache
Spark jobs.

Box 2: Yes
You can stream data into Azure Databricks using Event Hubs.

Box 3: Yes
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector. Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.


Reference:

https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs



DRAG DROP (Drag and Drop is not supported)
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Azure Cosmos DB
In Azure Cosmos DB's SQL (Core) API, items are stored as JSON. The type system and expressions are restricted to deal only with JSON types.

Box 2: Azure Files
Azure Files offers native cloud file sharing services based on the SMB protocol.


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json https://cloud.netapp.com/blog/azure-smb-server-message-block-in-the-cloud-for-azure-files



HOTSPOT (Drag and Drop is not supported)
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/create-cosmosdb-resources-portal



Page 33 of 72



Post your Comments and Discuss Microsoft DP-900 exam with other Community members:

z commented on December 21, 2024
Question 36 : PostgreSQL on Azure VMs option falls into the industry category of IaaS. https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview-postgres-choose-server-options
Anonymous
upvote

KAREEM ROFIAT BOLANLE commented on December 21, 2024
not yet written the exam
Anonymous
upvote

Traveller69 commented on November 28, 2024
I sat for this exam today. The questions are - I would say around 85% to 90% the same. I got 87% with just 2 weeks of studying from the PDF full version of this exam.
Canada
upvote

Rizwan commented on September 29, 2024
It's very useful information in the reveal solutions.
Anonymous
upvote

Rizwan commented on September 29, 2024
I am trying to learn question and answer to attempt Exam tomorrow morning.
Anonymous
upvote

Khoshy commented on September 21, 2024
Passed this exam today. The questions in this exam dumps PDF is valid.
Anonymous
upvote

Noor commented on September 12, 2024
I just bought the full version. Has anyone passed this exam here. Can you share you experience of the exam? I am very scared as I was told this exam is not easy at all.
Anonymous
upvote

Julia commented on September 09, 2024
Answer to 43 should be Azure Files (mapped drive)
Anonymous
upvote

Julia commented on September 09, 2024
In answer to question 23 mistake: it should be a,b because it is related to stream data, so it is processed as create with low latency is expected. Data processing periodically mostly related to batch
Anonymous
upvote

Mark commented on August 20, 2024
It is Very helpfull for the preparation to exam dp 900
UNITED STATES
upvote

Rajo commented on August 17, 2024
I found this exam dumps questions and answers very helpful despite some questions do not have the complete answers. Overall it helped me pass.
Singapore
upvote