Table of Contents
Enroll Here: NoSQL and DBaaS 101 Cognitive Class Exam Quiz Answers
Introduction to NoSQL and DBaaS 101
NoSQL Databases
NoSQL databases diverge from traditional relational databases (SQL databases like MySQL, PostgreSQL) in several key ways:
- Flexible Data Models: NoSQL databases can handle a variety of data types and structures, making them more flexible than traditional relational databases which require a predefined schema.
- Scalability: NoSQL databases are designed to scale horizontally, meaning they can efficiently distribute data across multiple servers. This scalability makes them suitable for handling large volumes of data and high throughput.
- High Availability: Many NoSQL databases are designed with built-in replication and distribution mechanisms, ensuring high availability and fault tolerance.
- Performance: Due to their architecture and data distribution methods, NoSQL databases often provide high performance for certain types of operations, such as read and write-intensive applications.
- Types of NoSQL Databases:
- Document Stores: Store data in flexible, JSON-like documents (e.g., MongoDB).
- Key-Value Stores: Simplest NoSQL model where data is stored in key-value pairs (e.g., Redis, DynamoDB).
- Column-family Stores: Organize data into columns instead of rows (e.g., Cassandra).
- Graph Databases: Optimize for relationships between data elements (e.g., Neo4j).
Database as a Service (DBaaS)
DBaaS takes the management and maintenance of databases to the cloud, offering several advantages:
- Managed Service: The cloud provider handles all aspects of database management, including setup, configuration, scaling, and backups.
- Scalability: DBaaS platforms allow easy scaling of database resources up or down based on demand, often with just a few clicks or API calls.
- Cost Efficiency: Pay-as-you-go pricing models mean organizations only pay for the resources they use, avoiding upfront infrastructure costs.
- High Availability: Most DBaaS providers offer built-in redundancy and replication across multiple data centers, ensuring high availability and disaster recovery.
- Security: DBaaS providers implement security best practices, such as encryption, access control, and compliance certifications, to protect data.
Integration and Usage
- Application Development: NoSQL databases are often favored for agile development environments where schema flexibility and scalability are critical.
- Big Data and IoT: NoSQL databases excel in handling unstructured and semi-structured data typical in big data and IoT applications.
- Cloud-Native Applications: DBaaS is particularly suited for cloud-native applications where rapid deployment and scalability are paramount.
In summary, NoSQL databases and DBaaS represent modern approaches to managing data that cater to the flexibility, scalability, and efficiency requirements of today’s applications and infrastructure landscapes.
NoSQL and DBaaS 101 Cognitive Class Certification Answers
Modules 1 – Introducing NoSQL Quiz Answers
Question 1: Scalability is a reason for employing a NoSQL database. True or false?
- True
- False
Question 2: Which of the following is a category of a NoSQL database?
- KeyValue
- Document
- Graph
- BigTable
- All of the above
Question 3: A NoSQL database is slightly more costly than a standard RDBMS. True or false?
- True
- False
Modules 2 – Defining NoSQL Database Types, Options, and Use Quiz Answers
Question 1: Which type of NoSQL database is the simplest?
- Graph
- BigTable/Column-Family
- Key-Value
- Document
Question 2: In a document database, documents have a flexible schema where more than one document can share the same information. True or false?
- True
- False
Question 3: Column-Family databases are worse than Graph databases when dealing with large amounts of sparse data. True or false?
- True
- False
Modules 3 – Choosing a Data Layer for Your Application Quiz Answers
Question 1: Since NoSQL databases offer horizontal scalability, they generally work well within a cloud architecture. True or false?
- True
- False
Question 2: Since many NoSQL databases primarily operate within a cluster, they cannot meet high availability requirements. True or false?
- True
- False
Question 3: Due to the flexibility and ease of integration of many NoSQL databases, it is often unnecessary to assess the skill sets of those who are developing applications. True or false?
- True
- False
Modules 4 – Introducing Cloudant – A NoSQLDBaaS Quiz Answers
Question 1: Cloudant scales very well to large amounts of
- Data and Concurrent Users
- Concurrent Users
- Data
- None of the above
Question 2: What file format does Cloudant use to store documents?
- TXT
- ASCII
- JSON
- XML
Question 3: Data can be replicated within clusters to keep them synchronized without administration intervention. True or false?
- True
- False
Modules 5 – Getting Started with IBM Cloudant: A Hands-On Introduction Quiz Answers
Question 1: Database names should contain lowercase alphanumeric characters, and they are allowed to contain spaces. True or false?
- True
- False
Question 2: For each database, Cloudant creates a primary index and stores it in a T-Tree. True or false?
- True
- False
Question 3: Which of the following is a component of the Cloudant HTTP API hierarchy?
- Attachment
- Database
- Document
- Account
- All of the above
NoSQL and DBaaS 101 Final Exam Answers
Question 1: The term NoSQL refers to a family of databases that vary widely in style and technology. True or false?
- True
- False
Question 2: Which of the following is a characteristic of NoSQL databases?
- Fixed schemas are supported
- Datastores are non-relational
- The data model is always a set of tables
- All of the above
Question 3: What prompted the need for NoSQL databases?
- Companies could no longer afford to develop and host databases
- The dotcom boom in the late 90’s and early 2000’s
- Relational databases became obsolete
- All of the above
Question 4: Which of the following database solutions is NOT a NoSQL database?
- Oracle
- Mongo
- Apache CouchDB
- Riak
Question 5: In which of the following situations should you consider using a Key-Value NoSQL database?
- The database only needs to perform basic CREATE-READ-UPDATE-DELETE operations. The data to be housed is not highly related.
- The database will be housing sparse data sets or Big Data sets. There will be a need for compression or versioning control.
- The data is highly interconnected and business use-cases need to be able to trace relationships between data points.
- The database schema for insertions is not well-defined. The schema is likely to change over time and your solution needs to remain flexible.
Question 6: In which of the following situations should you consider using a Column-family NoSQL database?
- The database only needs to perform basic CREATE-READ-UPDATE-DELETE operations. The data to be housed is not highly related.
- The database will be housing sparse data sets or Big Data sets. There will be a need for compression or versioning control.
- The data is highly interconnected and business use-cases need to be able to trace relationships between data points.
- The database schema for insertions is not well defined. The schema is likely to change over time and your solution needs to remain flexible.
Question 7: In which of the following situations should you consider using a Document NoSQL database?
- The database only needs to perform basic CREATE-READ-UPDATE-DELETE operations. The data to be housed is not highly related.
- The database will be housing sparse data sets or Big Data sets. There will be a need for compression or versioning control.
- The data is highly interconnected and business use-cases need to be able to trace relationships between data points.
- The database schema for insertions is not well defined. The schema is likely to change over time and your solution needs to remain flexible.
Question 8: In which of the following situations should you consider using a Graph NoSQL database?
- The database only needs to perform basic CREATE-READ-UPDATE-DELETE operations. The data to be housed is not highly related.
- The database will be housing sparse data sets or Big Data sets. There will be a need for compression or versioning control.
- The data is highly interconnected and business use-cases need to be able to trace relationships between data points.
- The database schema for insertions is not well defined. The schema is likely to change over time and your solution needs to remain flexible.
Question 9: When using database-as-a-service, which aspect of development is left to the database team?
- Database Design
- Server Administration
- Server Software
- Hardware Maintenance
Question 10: If you require strong consistency and transactional rollback capabilities, which type of datastore will you most likely choose?
- Search Engine
- Document Database
- Relational Database
- Graph Database
Question 11: When using a hosted database solution, the provider is responsible for the underlying infrastructure, and your database administrators maintain the software and databases running on top of the infrastructure. True or false?
- True
- False
Question 12: Cloudant is based on which open-source NoSQL database technology?
- Riak
- Apache CouchDB
- DB2
- Apache HBase
Question 13: Cloudant stores all of your data on a single database server node. True or false?
- True
- False
Question 14: Cloudant’s replication can be effectively applied to which of the following customer use cases?
- Avoidance of vendor lock-in (e.g. replication to a local CouchDB instance)
- Client offline access for mobile devices or web browsers
- Hot backups for continuous replication to another cluster
- A data delivery network requiring continuous replication to geographically dispersed clusters
- All of the above
Question 15: Where can Cloudant Database-as-a-Service be deployed?
- Cloud environments based on virtual machines, such as Amazon Web Services
- Non-IBM bare metal cloud environments, such as Rackspace or Windows Azure
- IBM infrastructure, such as IBM SoftLayer
- All of the above
Question 16: What file format does Cloudant use to store data?
- Objects
- JSON documents
- Tables
- Columnar storage format
Question 17: Cloudant writes each document on three separate nodes. True or false?
- True
- False
Question 18: Which field can be used to look up a document in a Cloudant database by using the primary index?
- _rev
- _id
- primary
- key
Question 19: Which value types are supported by a Cloudant document?
- nested objects
- booleans
- arrays
- strings
- All of the above
Question 20: Which type of Cloudant index leverages Apache Lucene libraries?
- Geospatial Index
- Secondary Index with Map Reduce
- Search Index
- Primary Index
Question 21: Which type of deployment does Cloudant offer?
- Hybrid Cloud
- Private – Locally hosted
- Public – Database-as-a-service
- All of the above
Question 22: Which tools can you use to work with the HTTP API?
- POSTMan
- RESTClient
- cURL
- All of the above
