Exam (elaborations)
NOSQL PART 2 WITH COMPLETE SOLUTIONS 100% CORRECT
- Course
- Institution
NOSQL PART 2 WITH COMPLETE SOLUTIONS 100% CORRECT...
[Show more]
Content preview
NOSQL PART 2 WITH COMPLETE SOLUTIONS 100% CORRECTQuestion 2: Why is it important to understand general concepts before handling NoSql
databases - ANSWER Answer: General concepts provide a foundation for the proper
use and understanding of NoSql databases
Question 3: Name any reasons discussed in favor of exploring alternatives to relational
databases - ANSWER Answer: Performance and high-availability issues, limitations with
handling big data
Question 4: What is ACID in the context of databases - ANSWER Answer: ACID stands
for Atomic, Consistent, Isolated, and Durable, which are the properties that ensue the
reliability of a database and its transactions.
Question 5: Mention some of the advantages of relational databases - ANSWER Answer:
Wide range of tools and know-how available, support for the ACID principle, powerful
SQL language, and availability of drivers and frameworks for accessing databases
Question 6: What are some disadvantages of using relational databases - ANSWER
Answer: Mappings from relational databases to object-oriented structures tend to be
painful, schema change is a complex and difficult operation to perform, scalability and
high availability were limited, and the licensing model was relatively expensive.
Question 7: Name four major players in the relational database market.
Answer: Oracle, MySql, Microsoft SQL Server, and Postgres - ANSWER
Question 8: What is the ranking of MongoDB about the popularity of databases currently
- ANSWER Answer: MongoDB presently ranks 5th in popularity among databases
Question 9: Why is NoSql database gaining momentum - ANSWER Answer: NoSql
databases have relative advantages in processing massive volumes of data,
, non-relational data, and specialized needs like document storage, search, and real-time
analytics
Question 10: Limitations of relational databases when dealing with diverse data sources
- ANSWER Answer: Relational databases have a problem when there is an unstructured
or non-relational source of data, for example, data from search engines, data streams,
etc.
Question 11: Some general concepts that needs to be understood before handling
NoSql databases - ANSWER Answer: ACID, performance, high-availability, and the
limitations of relational databases
Questions 12: Why are classic relational databases not a good fit for handling big data -
ANSWER Answer: Relational databases have limited scalability and performance to
scale large volumes of data.
Question 13: What are the four main characteristics of the ACID principle - ANSWER
Answer: Atomic, Consistent, Isolated, and Durable
Question 14: What are some challenges in mapping between relational databases and
object-oriented structures - ANSWER Answer: Handling primary keys, foreign keys,
n-to-n relationships, and inheritance
Question 15: What is the purpose of denormalization in tables used in OLAP - ANSWER
Answer: Denormalization in OLAP tables allows posting performance by reintroducing
redundancy in the data
Question 16: What are some common disadvantages of schema changes in relational
databases - ANSWER Answer: Schema changes can be elaborate, involving conversion
scripts and possible effects on existing data
Question 17: What is the primary benefit that NoSql databases have when dealing with
varied data sources - ANSWER Answer: The advantages of NoSql databases are that
they handle unstructured or non-relational data sources better than relational
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Easton. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75057 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now