Designing a Database to Analyze Network Traffic Impact | Microsoft DP-900 Exam

Designing a Database to Analyze Network Traffic Impact

Question

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?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

A

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.

https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases

The type of data store that is most suitable for representing the relationships between different areas of a network and how they affect each other is a graph database.

A graph database is a type of NoSQL database that stores data in nodes and edges, allowing for complex relationships between data points to be easily represented and analyzed. In a graph database, nodes represent entities or objects, while edges represent the relationships between them.

In the case of a network traffic analysis, nodes could represent different areas of the network, such as routers or switches, while edges could represent the connections between them. By modeling the network as a graph database, it would be possible to easily query and analyze how changes in one area of the network affect traffic in other areas, as well as identify potential bottlenecks or areas for optimization.

Key/value stores, document databases, and columnar databases are not as well-suited for representing complex relationships between data points, and would likely not be the best choice for this use case. Key/value stores are best suited for simple, highly structured data with predictable access patterns, while document databases are optimized for storing and querying unstructured or semi-structured data. Columnar databases are designed for handling large volumes of structured data, but do not offer the same flexibility for representing complex relationships between data points as a graph database.