Scenario: A distributed system requires high availability and must remain responsive even during network partitions. Which CAP theorem property would be prioritized, and what are the potential trade-offs?

Availability; potential for stale data during partitions.

Consistency; potential data loss during partitions.

Partition tolerance; potential for increased latency.

All three properties can be guaranteed simultaneously in this scenario.

Application: A social media platform needs to store user profiles, relationships, and posts. Which NoSQL data model would be most suitable, and why?

Document; for flexible storage of user profiles and posts.

Key-value; for simple data storage and retrieval.

Columnar; for efficient analytical queries on user activity.

Graph; for representing and querying complex relationships between users and posts.

Design Decision: You are designing a product catalog for an e-commerce website. Which MongoDB data modeling approach would be more efficient for storing product variations (e.g., sizes, colors), and why?

Using embedded documents; to minimize the number of queries and improve performance.

Using references; to normalize data and reduce redundancy.

Using separate collections for each variation; to enforce strict schema.

Using a graph database within MongoDB; to represent relationships between variations.

Query Optimization: A MongoDB collection contains millions of documents with frequent queries based on a specific field. What is the most effective way to improve query performance, and how does it work?

Creating an index on the frequently queried field; to allow for faster data retrieval.

Using the find() method without any query criteria; to retrieve all documents quickly.

Using the aggregation framework with the $sort stage; to organize data before retrieval.

Using transactions for all read operations; to ensure data consistency.

Data Integrity: In a financial application using MongoDB, transactions are crucial for ensuring data consistency during multi-document operations. Which scenario would most benefit from using transactions, and why?

Processing fund transfers between accounts; to guarantee atomicity and isolation.

Storing user login sessions; as data consistency is not critical.

Caching frequently accessed product data; to improve read performance.

Storing log entries; as data consistency is not a primary concern.

Security Implementation: A MongoDB database stores sensitive user information. Which of the following security measures would provide the most comprehensive protection, and why?

Implementing authentication and authorization; to control user access to specific data.

Relying solely on network firewalls; as they prevent unauthorized access from external networks.

Encrypting data only during transmission; as data at rest is inherently secure.

Using default MongoDB configurations; to ensure compatibility.

Aggregation Use Case: You need to generate a report showing the total number of orders per customer in a MongoDB collection. Which MongoDB aggregation stage would be most effective for grouping orders by customer, and why?

$group; to aggregate orders by customer and calculate the total count.

$match; to filter orders based on specific criteria.

$project; to reshape the order documents.

$sort; to order the results by customer name.

NoSQL vs. Relational: A company is migrating from a relational database to a NoSQL database. Which scenario would justify the use of a NoSQL database over a relational database, and why?

The data is rapidly evolving and requires flexible schemas.

The data has a fixed schema and requires complex joins.

The data is highly structured and requires strict ACID compliance.

The data is small and requires simple read/write operations.

Array Queries: A MongoDB collection stores documents with an array field representing tags associated with each document. How would you efficiently query for documents that contain all of a specific set of tags, and what MongoDB operator would you use?

Using the $all operator; to find documents with all the specified tags.

Using the $in operator; to find documents with any of the specified tags.

Using the $size operator; to find documents with a specific number of tags.

Using the $exists operator; to find documents with the tag field present.

Document Design Impact: A MongoDB collection stores user profiles. You are considering embedding address information directly into the user document versus storing it in a separate linked document. What are the potential performance implications of each approach, and when would one be preferred over the other?

Embedding can improve read performance but may slow down updates; preferred when reads are frequent and updates are rare.

Embedding is always faster due to reduced joins; preferred for all scenarios.

Linked documents are always faster due to smaller document sizes; preferred for all scenarios.

Linked documents improve update performance but slow down reads; preferred when updates are frequent and reads are rare.

Scenario: You have a MongoDB collection of order documents, and you need to calculate the total sales for each product category. Which MongoDB feature would be most suitable for this aggregation task?

Basic queries (find(), updateOne())

Database2

Authored by Benru Benru

Computers

Professional Development

Used 5+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

56 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is NOT a property described by the CAP theorem?

Consistency

Availability

Partition Tolerance

Durability

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which NoSQL data model stores data in JSON-like documents?

Key-value

Columnar

Document

Graph

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which NoSQL data model is best suited for storing relationships between entities?

Key-value

Columnar

Document

Graph

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which NoSQL database is often used for caching and session management?

MongoDB

Cassandra

Redis

Neo4j

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In MongoDB, what is the equivalent of a table in a relational database?

Document

Collection

Field

Index

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which command is used to retrieve all documents from a collection in MongoDB?

insert()

update()

find()

delete()

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which MongoDB operator is used to specify 'greater than'?

$eq

$ne

$gt

$lt

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

60 questions

สอบปลายภาควิชาโปรแกรมสำเร็จรูปทางสถิติ

Quiz

•

Professional Development

60 questions

KFIN_Tech_Screening_Test_Python_103_Jan'24

Quiz

•

Professional Development

52 questions

Desainer Grafis Muda

Quiz

•

Professional Development

57 questions

A+ 1101 Study Quiz 2

Quiz

•

Professional Development

59 questions

Mulesoft Practice Test

Quiz

•

Professional Development

59 questions

Kiến thức về thiết bị máy tính

Quiz

•

Professional Development

56 questions

Quiz Operatore del Benessere

Quiz

•

Professional Development

60 questions

pseudocode

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

10 questions

How to Email your Teacher

Quiz

•

Professional Development

6 questions

3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET

Quiz

•

Professional Development

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

22 questions

Multiplying Exponents with the Same Base

Quiz

•

9th Grade - Professio...

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

Database2

Which of the following is NOT a property described by the CAP theorem?

Which NoSQL data model stores data in JSON-like documents?

Which NoSQL data model is best suited for storing relationships between entities?

Which NoSQL database is often used for caching and session management?

In MongoDB, what is the equivalent of a table in a relational database?

Which command is used to retrieve all documents from a collection in MongoDB?

Which MongoDB operator is used to specify 'greater than'?

Which MongoDB operator is used to combine multiple query conditions with a logical AND?

What is the purpose of the $project stage in the MongoDB aggregation framework?

Which of the following is NOT a type of index in MongoDB?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers