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.	A Graph Database
	B.	A Key-Value type of Database
	C.	A Document Database
	D.	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?

A.

Document Database

B.

Graph Database

C.

Key Value Store

D.

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.

A pre-designated Slave node

B.

All the Slave nodes

C.

Master Node

D.

All the nodes

From the list below, Identify two technological advancements that can be described as big enablers for Cluster Processing.

A.

JSON objects

B.

Master-Slave Replication

C.

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.