Questions
BUSI_V 335 972 2025SS Module 9 Quiz - Database Design - Process
Single choice
In a federated database,
Options
A.tables are split by row or column, kept in separate databases.
B.segments of the whole data are kept in different locations.
C.one piece of software cannot manage all of the distributed data.
D.data for different parts of a database are kept in different databases.
View Explanation
Verified Answer
Please login to view
Step-by-Step Analysis
When approaching the concept of a federated database, it’s helpful to think about how data is distributed across multiple systems.
Option 1 suggests that tables are split by row or column and kept in separate databases. While fragmentation by rows or columns can exist in distributed setups, the hallmark of a federated database is not simply splitting table......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.
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.
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!