Exam 350-901 topic 1 question 296 discussion

Actual exam question from Cisco's 350-901

Question #: 296
Topic #: 1

Refer to the exhibit. An application is being developed as an information repository. The application will be used to store details about television shows, including the scenario, year, and category. Which database type must be used for high performance for the data structure?

A. time series
B. columnar
C. document-based
D. graph

Show Suggested Answer

Suggested Answer: C 🗳️

by [deleted] at Feb. 8, 2023, 8:47 a.m.

Comments

Submit Cancel

luckymuki

6 months, 2 weeks ago

Selected Answer: B

Gemini: The most suitable database type for this application's data structure is: B. Columnar Here's why a columnar database is a good fit: Data Structure: The application stores information about television shows, with well-defined attributes like scenario, year, and category. This structured data aligns well with columnar databases. High Performance: Columnar databases excel at querying specific columns, which is ideal for this scenario. When retrieving information about shows, users will likely be interested in specific fields like year or category. Columnar databases store data in columns, allowing for faster retrieval of these specific data points compared to row-oriented databases.

upvoted 4 times

luckymuki

6 months, 2 weeks ago

Let's explore why the other options are not the best choices: A. Time Series: Time series databases are optimized for storing and analyzing time-based data. While some shows might have release dates, the overall structure doesn't heavily rely on time-based elements. C. Document-based: Document databases are flexible for storing various data formats, but they might not offer the same level of performance as columnar databases for querying specific fields in a structured dataset. D. Graph: Graph databases are powerful for representing relationships between entities. While there could be connections between shows (e.g., sequels), the primary focus here seems to be storing individual show information, making a columnar database a more suitable choice.

upvoted 2 times

...

kirrim

1 year, 1 month ago

Selected Answer: C

The exhibit shows a JSON file, and needs a document-store database to store it.

upvoted 2 times

...

manuedu

1 year, 9 months ago

Selected Answer: C

devcor guide: Document-based databases are a subclass of key-value databases and are in a way the next step from key-value model in the database evolution

upvoted 2 times

...

[Removed]

1 year, 10 months ago

Selected Answer: C

C is correct.

upvoted 2 times

...