Exam DP-900 topic 1 question 110 discussion

https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview#column-family-databases

Am I the only one, who is confused by the first three students having the same number? :-D

In this case I would say B. Student number as a Key, and Student information as a JSON.

option D

Columnar as you can handle Student Info as a column family.

C. object The data seems to fit the structure of an object or document-oriented database, where each student's information can be stored as a document with various attributes and their corresponding values. This type of data store allows for flexible schema and can accommodate varying attributes for different documents.

Answer is D. Here's a userful link to help visualize columnar database.

C. object Based on the given format of student data, an object data store would be the most suitable choice. In an object data store, data is stored as objects, where each object is a self-contained unit consisting of both data and associated metadata. The data within an object can be structured or unstructured, and it can contain various attributes and properties. In the given scenario, each student's data is presented as an object with attributes such as "First Name," "Last Name," "Email Address," "MCP ID," and "Phone Number." The data is self-contained within each object, making it an ideal fit for an object data store. The object data store is designed for scenarios where you need to store complex, heterogeneous data with varying attributes and metadata.

Correct Answer

Correct Answer

https://learn.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview#column-family-databases

key value is a possible answer since the second column is agreggating like in a JSON with varying subschema.

The 2 given student numbers in the table are the same but different name? the question is wrong.

A, B, C are out of question; so, it must be D. However Columnar database is not same as Column-family data store, which this exhibit IS. So, who named it Columnar: Microsoft on the exam or those who retrieved the question from their memory?

A, B, C are out of question; so, it must be D. However, Columnar database is not same as Column-family data store, which this exhibit IS. So, who named it Columnar: Microsoft on the exam or those who retrieved the question from their memory?

The answer is correct.

Columnar