Questions
INFO20003_2025_SM2 MINI Practice Exam
Matching
Distributed Databases Determine whether the following statements are true or false: 1: Non-distributed databases can always provide both availability and consistency 2: Distributed databases can provide both availability and consistency, as long as no network partition exists 3: Distributing a database is only necessary/useful when we can no longer scale the database vertically (i.e. we cannot buy a better local server) 4: Transactions are necessary in distributed databases but not in centralized databases 5: If vertical or horizontal partitioning is used in a distributed database, that partitioned data cannot be replicated if the database needs to remain consistent.
Options
A.False
B.True
View Explanation
Verified Answer
Please login to view
Step-by-Step Analysis
The question asks you to classify each of the five statements as True or False. We'll examine each statement individually and explain why the stated truth value is correct or incorrect, drawing on core concepts of distributed databases and CAP-like considerations.
Statement 1: 'Non-distributed databases can always provide both availability and consistency.'
- Why this is considered False: In a real system, even a single (non-distributed) database faces potential failures. The claim uses the absolute word 'always,' which makes it unreliable. Depending on the failure mode (hardware, ......Login to view full explanationLog in for full answers
We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!
Similar Questions
Distributed Databases Scenario: you are hired as a consultant, specialising in distributed databases! For each of the following scenarios, explain which distribution strategy is best to overcome the problem. 1: For a Sharepoint site, you have users located in both Melbourne and Singapore. Both need full access to all of the data at maximum speed. The data, however, gets updated very rarely (say once every 3 months). 2: For the Salesforce Customer Relationship Management system, you have users located in both Asia and Europe. However, generally, SOME rows in the tables are used more regularly in Asia (e.g., salespeople in China look up more records for customers in China), and some are used more regularly in Europe (likewise for France). Not many analytical queries involving data from other regions are required, and in general, updates are happening to tables very rapidly. 3: For the Australian Football League information website, its users are based primarily in the Australian region (nearby the DB in Sydney), and in general the performance of the DB is currently acceptable and data is being backed up already offsite safely. If the service goes down for hours to days, it’s not ideal but not mission critical to the business. 4: For the National Gallery of Victoria (NGV) database, its users are mainly people who love art in the Australian region. Therefore, speed is essential for these users, to access basic information about NGV's art collection and a preview image of less than 1MB. However, the NGV also stores very high-resolution image data (up to 1GB) in Silicon Valley (USA) due to cheaper cost of storage there; these large image files are accessed mostly by arts scholars, at most twice a month.
In a federated database,
Which of the following best distinguishes read repair from anti-entropy repair in Cassandra?
Cassandra adopts the peer-to-peer replication model.
More Practical Tools for Students Powered by AI Study Helper
Making Your Study Simpler
Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!