NoSQL_quiz

Review Test Submission: NoSQL databases CS 6350.002 - Big Data Management and Analytics - F21 Course Homepage CS 6350.002 - Big Data Management and Analytics - F21 H Course Homepage Announcements Discussion Board Calendar My Grades Blackboard Collaborate Microsoft Teams Microsoft Stream Review Test Submission: NoSQL databases Sunday, December 5, 2021 7:19:18 PM CST User Course CS 6350.002 - Big Data Management and Analytics - F21 Test NoSQL databases Started 12/5/21 7:14 PM Submitted 12/5/21 7:19 PM Due Date 12/5/21 11:59 PM Status Completed Attempt Score 97.5 out of 100 points Time Elapsed 5 minutes Results Displayed All Answers, Submitted Answers, Correct Answers Question 1 Selected Answers: Answers: Which of the following are reasons that the NoSQL movement has become popular? We can tune NoSQL databases to provide very high degree of availability Horizontal scalability provided by NoSQL databases ACID properties contain unnecessary complexities, such as normalization and ACID properties, which may not be needed for raw data produced by Big Data producers. We can tune NoSQL databases to provide very high degree of availability Horizontal scalability provided by NoSQL databases Higher throughput - NoSQL databases can output data at a much faster rate than traditional RDBMS. ACID properties contain unnecessary complexities, such as normalization and ACID properties, which may not be needed for raw data produced by Big Data producers. Vertical scalability - allows stopping current cluster, and adding more resources Ability to use traditional SQL Question 2 Selected Answer: Answers: Which of the following is the statement of CAP theorem? For a distributed system, it is impossible to achieve all three of CAP properties at the same time. For a distributed system, it is impossible to achieve all three of CAP properties at the same time. Modern Big Data intensive web applications, such as Facebook, prefer C over A For a distributed system, P is not possible For a traditional database, we can guarantee 100% availability no matter what. Question 3 Answers Selected Answer 1. 1. 2. 2. 3. 3. 4. 4. For NoSQL databases, arrange the following in order of preference: Hint: Think of BASE: Basically Available Soft state Eventual consistency Normalization of NoSQL databases is almost never done. Availability Availability Eventual Consistency Eventual Consistency Cost of hardware Cost of hardware Normalized data Normalized data Question 4 Selected Answers: Answers: Apache HBase has the following properties: Consistency Column Oriented Database Partitionability Consistency Column Oriented Database Availability Partitionability Question 5 Selected Answers: Answers: Which of the following is true about NoSQL databases? It refers to a family of databases It stands for Not Only SQL It refers to a family of databases It stands for No need for SQL It is a single database It stands for Not Only SQL Question 6 Selected Answer: Answers: Why can a master/slave architecture not achieve very high consistency? Master node is a single point of failure The system has to be taken down to scale up One of the slaves may fail The system has to be taken down to scale out Master node is a single point of failure Question 7 Selected Answers: Answers: Which of the following are categories of NoSQL databases? Column Oriented Databases Key Value Store Graph Databases Column Oriented Databases Key Value Store HTML databases Graph Databases Question 8 Selected Answers: Answers: If I have an instance of SQL Server running on a single server, which of the following properties can I achieve? Normalized data Availability Consistency Normalized data Store multiple timestamped copies of data in a single cell Availability Consistency Question 9 Selected Answer: Answers: Which of the following NoSQL databases can guarantee very high availability? Cassandra MongoDB Cassandra SQLite HBase Question 10 Selected Answer: Answers: Which of the following is an example of graph database? neo4j neo4j HBase MongoDB Spark ← OK My eLearning 7.5 out of 10 points 10 out of 10 points 10 out of 10 points 10 out of 10 points 10 out of 10 points 10 out of 10 points 10 out of 10 points 10 out of 10 points 10 out of 10 points 10 out of 10 points