1.Question 1What is the purpose of database replication in a distributed database architecture?1 pointHigh availabilityImproved performanceDisaster recoveryAll of the above2.Question 2Which of the following classes of database users are more likely to use Object Relational Mapping (ORM) in their workloads?1 pointData EngineersDatabase AdministratorsData ScientistsApplication Developers3.Question 3MySQL facilitates various storage engines. Among the options provided, which storage engines that MySQL supports employ table-level locking?1 pointInnoDBFalcon NDBMyISAM4.Question 4PostgreSQL is a database management system with an object-relational architecture. What significance does the "object" aspect hold within PostgreSQL?1 pointUses Postgres source codeSupports high availability and scalabilityDatabase managementSupports inheritance and overloading5.Question 5A relation consists of columns and rows, with columns representing attributes or fields. What is the term used to describe the individual entries in the rows of a table? 1 pointData valuesStructTuplesDegree

What is a downside of data replication in distributed databases?Question 9Select one:A.Decreased latencyB.Data availability during catastrophic eventsC.Increased complexity of write operationsD.Increased read performanceE.Robustness against node failures

1. What is MySQL, and what is its role in database management?

What is the primary disadvantage of NoSQL databases? Question 4Select one: Limited query capabilities Mature database tools and standards Strong consistency in distributed systems Ease of implementation

1.Question 1Which factor drives the data model in a NoSQL database?1 pointThe complexity of the joinsThe schemaThe queries you intend to makeRelationships among entities2.Question 2What is one way that a distributed NoSQL database usually shards data?1 pointBy grouping all records that have the same key on the same serverBy grouping all keys numericallyBy distributing all records that share the same key across multiple serversBy grouping all records that have the same data on the same server3.Question 3In the BASE model what does it mean for data to be in a “soft state”?1 pointThe data store is accessible at all times.The data store values availability over consistency.The availability of data is ensured by partitioning it.Different replicas do not need to be mutually consistent all the time.4.Question 4Which trait is the most common to all of the four types of NoSQL databases?1 pointThey are non-relational.They use Key-Value pairs for queries.They are indexed.They are partitioned.5.Question 5Which term refers to offloading of database administration and maintenance from the end user?1 pointSoftware as a ServiceAdministration as a ServiceNoSQL as a ServiceDatabase as a Service6.Question 6In MongoDB, which of the following common aggregation stages takes the outcome from the previous stage and stores it in a target collection?1 point$count$merge$sort$project7.Question 7Fill in the blank. MongoDB follows a ____________________approach.1 pointtest-first, code-latertest-first, design laterdesign-first, code-latercode-first, design-later8.Question 8In MongoDB, what is a group of similar stored documents called?1 pointAn indexA clusterAn aggregationA collection9.Question 9Which of the following is a distinguishing characteristic of a compound index in MongoDB?1 pointWhen a single index structure holds reference to more than one fieldWhen an index helps you to quickly locate data without looking for it everywhereWhen you create an index for the most frequent queriesWhen the index is stored in a particular order10.Question 10What is the primary purpose of replication?1 pointIt allows you to partition large data sets.If one server fails, you still have multiple copies of the data present.It prevents you from accidentally deleting data.It increases throughput by directing queries to relevant partitions.11.Question 11What would you most likely use blobs for in Cassandra Query Language (CQL)?1 pointStoring key-value pairsStoring multimedia objectsStoring a high range of integersRepresenting encoded strings12.Question 12Which of these four approaches is the slowest way to make data changes in Apache Cassandra?1 pointUse UPDATE data with Time-To-Live.Use UPDATE data with the full primary key specified.Use Lightweight Transactions.Use INSERT data with Time-To-Live.13.Question 13 Select three key features used by relational databases but not by Cassandra.1 pointDistributed, scalable, fault-tolerantJoin support, aggregation support, scalableJoin support, aggregation support, transaction supportConsistency, distributed, scalable14.Question 14What are the two primary functions of a “partition key”? Select two.1 pointIt optimizes the read performance of queries.It determines the location of the data in a cluster.It adds uniqueness to each entry in a table.It specifies the order in which the data is arranged inside the partition.15.Question 15What do you need to start data distribution in Cassandra?1 pointData setsQueriesA key value hashTokens

In a distributed database system, which approach is used to ensure that all copies of a data item are updated simultaneously?Immediate consistencyEventual consistencyQuorum consensusSerializability