Table of Contents
Introduction to NoSQL Databases Week 01 Quiz Answers
Graded Quiz 01: Basics of NoSQL
Q1. What common trait does the NoSQL family of databases share?
- Non-relational
- Technology
- Exclusion of SQL
- Tabular style
Q2. What may be the most common reason to use a NoSQL database?
- Availability
- Consistency
- Scalability
- Security
Q3. What makes Key-Value NoSQL databases powerful for basic CRUD operations?
- They are represented as a hashmap.
- The value blob is opaque.
- They are atomic for key operations.
- They shard easily across nodes.
Q4. Which use case would be a poor choice for a document type NoSQL database?
- Online blogging
- Event logging for a process
- Operational data sets for a web app
- Aggregate-oriented design
Q5. What is a characteristic of column-based NoSQL databases?
- Rows in column families can share all, a subset, or none of the columns.
- Rows in column families are required to share the same columns.
- Columns are grouped together in families because they are often accessed individually.
- Rows in column families share a common key or identifier.
Graded Quiz 02: Working with Distributed Data
Q1. Which industry will almost exclusively use ACID databases?
- Financial institutions
- Ecommerce
- Online social networks
- Marketing consultants
Q2. What is data sharding?
- Replicating data across multiple nodes
- Retrieving data from a failed node
- Fragmenting data into smaller pieces
- Deleting all data and schema
Q3. How many of the desired characteristics of the CAP Theorem can a distributed system guarantee?
- Three
- Two
- One
- None
Q4. What drives your data model in NoSQL?
- How the data is denormalized
- How the data is stored in one or more tables
- The choice between availability and consistency
- Your queries and the way the app accesses the data
Introduction to NoSQL Databases Week 02 Quiz Answers
Graded Quiz 01: Basics of MongoDB
Q1. ___________ provided by MongoDB means as your data needs grow, you can introduce bigger, faster, and better hardware, and partition your data.
- Scalability
- Flexibility
- Self-management
- High availability
Q2. MongoDB is schemaless. What does that mean?
- That you can only store structured data in MongoDB.
- With MongoDB, you don’t need to alter your tables to store additional fields.
- MongoDB does not require that you create the schema and the table structures before writing the data.
- The schema is already created, so all you need to do is to create the table structures that will hold your data.
Q3. True or False: MongoDB follows a code-first approach, which means you can start writing your data as soon as you connect to the database.
- TRUE
- FALSE
Q4. Typical MongoDB setups are a three-node replica set. The ________________ process keeps a copy of your data on the primary node on the other data bearing nodes in the cluster.
- Aggregation
- Redundancy
- Replication
- Clustering
Q5. The “Many Sources One View” use case of MongoDB suggests that __________
- MongoDB can store data that is of different types and formats.
- MongoDB can ingest different types of data from different sources and consolidate it into one view for all data.
- MongoDB can store data collected from multiple sources as long as they are the same format.
- MongoDB can collect vast amounts of data.
Graded Quiz 02: Getting Started with MongoDB
Q1. True or False: Mongo shell is a tool provided by MongoDB to interact with your databases.
- TRUE
- FALSE
Q2. MongoDB uses compound indexing. What is special about a compound index?
- MongoDB compound indexes are used for your most frequent queries by default.
- MongoDB compound indexes are special data structures storing both the fields you are indexing and the location of the document.
- MongoDB compound indexes index more than one field.
- MongoDB compound indexes help quickly locate data without looking for it everywhere.
Q3. Aggregation pipeline is a series of operations that you apply on your data to get a desired result. What does the following operation do?
> db.courseResults.aggregate([
{ $match: { “year”: 2020 } },
{ $group: { “_id”: “$courseId”, “avgScore”: { $avg: “$score”} } }
])
- Filter 2020 documents, group these documents by course, then calculate the average student score per course in that year.
- Filter 2020 documents, group these documents by course, and display the resultant list as an outcome.
- Filter 2020 documents, group these documents by course, then display the student id, course id, and average score of all 2020 documents in a tabular format.
- Filter 2020 documents, group these documents by average score, and display this list in ascending order of average scores.
Q4. A MongoDB Replica Set is a collection of data bearing nodes _________________
- With each node being either a primary node or a secondary node, and each maintaining a copy of the same data through replication.
- With each node being a secondary node maintaining a copy of the same data through replication, so that if you accidentally delete your database you can recover the database from one of the secondary nodes.
- With each node maintaining a copy of the same data through replication, and serving as a backup in case of server hardware fails.
- With each node being a primary node maintaining a copy of the same data through replication.
Q5. What does the following operation in Python do?
customers.count_documents({“lastName”: “Smith”})
- It returns the first document in natural order (the order in which the database refers to documents on disk), which has lastname as “Smith”.
- It allows you to insert the column ‘customers_list’ in the database.
- It counts the number of customers with lastname “Smith” and returns the number of records found as an outcome.
- It updates the customer list with customer information in the ‘customers_list’ field.
Introduction to NoSQL Databases Week 03 Quiz Answers
Graded Quiz 01: Cassandra Basics
Q1. Cassandra is a best fit for use cases that have which characteristic?
- Always available
- Focused on search
- Read with indexes
- Very specific
Q2. What does data distribution start with?
- A token
- A key value hash
- A query
- A data set
Q3. What is a consequence of Cassandra’s availability?
- Possible inconsistency of the changed data
- Strong consistency
- Irresolvable data conflicts
- Little to zero consistency
Q4. What are two logical entities in the Cassandra data model?
- Tables and keyspaces
- Keyspaces and schemas
- Keyspaces and primary keys
- Tables and definitions
Q5. Which guideline should you follow for modeling data?
- Build a primary key that allows you to minimize the number of partitions read in order to answer a certain query
- All of the above
- Build a clustering key that helps you reduce the amount of data that needs to be read by ordering your clustering key columns according to your query
- Choose a partition key that starts answering your query but that also spreads the data uniformly around the cluster
Graded Quiz 02: Working with Cassandra
Q1. Which CQL data type is typically used to store an image or audio?
- Sets
- Bigint
- Maps
- Blobs
Q2. Which command would you use to add new columns to a table schema?
- DROP TABLE
- ALTER TABLE
- TRUNCATE TABLE
- CREATE TABLE
Q3. What does introducing IF in INSERT and UPDATE statements make possible?
- Attaches a Timestamp to a specific write operation
- Instructs Cassandra to look for the data, read it, and only then perform a given operation
- Creates a new file called SSTable
- Inserts/updates data with a specific Time-To-Live
Q4. What is a difference between CQL and SQL?
- Intuitive and simple syntax
- Support of JOIN statements
- Syntax that allows the creation of tables and keyspaces
- Syntax that allows the creation of inserts, deletes, and select queries
Q5. What does DROP KEYSPACE remove?
- All data and schema
- All keyspace table data
- All data and primary keys
- All keyspace tables and their data
Introduction to NoSQL Databases Week 04 Quiz Answers
Graded Quiz 01: Cloudant Basics
Q1. Which IBM Cloudant capability helps you most to develop custom apps?
- Language-specific libraries
- Data replication
- Offline First
- Geospatial GeoJSON
Q2. How are IBM Cloudant users routed to data centers?
- Ping timing
- Geographic load balancing
- MapReduce
- Replication protocol
Q3. What are the two primary reasons that documents are organized into databases in IBM Cloudant?
- For querying and clustering
- For scaling and security
- For security and querying
- For querying and schema flexibility
Q4. With which IBM Cloudant deployment option plan is there a maximum limit of 1MB for a single JSON document?
- Lite Plan
- Standard Plan
- All of the above
- Dedicated Hardware Plan
Q5. Which IBM Cloudant technology would work best for applications involving oil, gas, or transportation?
- Full-text Search
- Geospatial
- Operational datastore
- MapReduce
Graded Quiz 02: Working with Cloudant
Q1. Which option will most likely increase the cost to an organization running multi-tenant instances of IBM Cloudant?
- Continuous replication
- One-time replication
- Compaction
- Indexing
Q2. When you use the name of a variable in a curl command, which character must precede the name of the variable?
- #
- v
- $
- @
Q3. What should you use to help you to get the best long-term performance out of your IBM Cloudant databases?
- Indexing
- Continuous replication
- Partitioned databases
- Non-partitioned databases
Q4. Which HTTP method is the default for curl?
- GET
- POST
- -X PUT
- PUT
Q5. What is the maximum size for a Cloudant document JSON object?
- 5 megabytes
- 1 megabyte
- 100 megabytes
- 10 megabytes
Get all Course Quiz Answers of IBM Data Engineering Professional Certificate
Introduction to Data Engineering Coursera Quiz Answers
Python for Data Science, AI & Development Coursera Quiz Answers
Introduction to Relational Databases (RDBMS) Quiz Answers
Databases and SQL for Data Science with Python Quiz Answers