Kelly designed a Key-Value Store database for storing Customer Information for a
ID: 3814285 • Letter: K
Question
Kelly designed a Key-Value Store database for storing Customer Information for a Banking application. She has created a Column Family called "Demographics." The initial design of the Demographics Column Family included the columns "First Name","Last Name", "Address","Telephone Number", and "Gender". The database is now operational. However, the users requested a change to store Customer's date of birth in the database too. Kelly intends to add a new column called "BIRTH_DATE" to Demographics column family. Can she do it without a schema change?
Yes
No
Kelly designed a Key-Value Store database for storing Customer Information for a Banking application. She has created a Column Family called "Demographics." The initial design of the Demographics Column Family included the columns "First Name","Last Name", "Address","Telephone Number","Birth Date," and "Gender". The database is now operational. However, the users requested a change to store Customer's annual income, and mothly mortgage amounts. Since the requested information is financial, Kelly intends to create a new Column Famaily called "Financials", and add columns for annual income and monthly mortgage to this new Column Famaily. Does this change require a schema change?
Yes
No
You are designing a web application. You have a requirement to provide a facility to the user to store his/her preferences on the look-and-feel of the web pages of your application. According to Fowler and Sadalage, which of the following database types is best suited for this requirement?
A Graph Database
A Key-Value type of Database
A Document Database
A Column Oriented Database
You are creating a database for a Social Network System. The database is expected to have millions of users and each user can have a "Friends with" relation with many other users. Which of the following database types is best suited for this application?
Document Database
Graph Database
Key Value Store
Relational Database
In a Master-Salve replication, which node is responsible for insuring the updates to the data are replicated across all the nodes.
A pre-designated Slave node
All the Slave nodes
Master Node
All the nodes
From the list below, Identify two technological advancements that can be described as big enablers for Cluster Processing.
JSON objects
Master-Slave Replication
Virtualization
Cloud Computing
You are using a Document Database for your Order Analytics System. The database is organized as Customer Number as the Key and rest of the information related to the orders of the customer as Document. Your Sales Manager requested you to provide the list of Customers who bought the product called "XYZ." You have realized that the attribute "PRODUCT" is in the Document section of the data. Identify the best possible action that you could take to address this requirement.
Redesign the data structure so that it becomes PRODUCT centric.
Create an Index on PRODUCT so that the search for the customers who bought a specific product runs faster
Create an Index on CUSTOMER NUMBER so that the search for the customers runs faster
Scan the complete database to identify the customers who bought the product.
A.A Graph Database
B.A Key-Value type of Database
C.A Document Database
D.A Column Oriented Database
Explanation / Answer
Multiple Questions : Answering one .
You are creating a database for a Social Network System. The database is expected to have millions of users and each user can have a "Friends with" relation with many other users. Which of the following database types is best suited for this application?
Graph Database
Friends with relation is easy to incorporate in a graph database.
B.Graph Database
Friends with relation is easy to incorporate in a graph database.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.