题目
题目

BUSI_V 335 972 2025SS Module 9 Quiz - Database Design - Process

单项选择题

In a federated database,

选项
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.
查看解析

查看解析

标准答案
Please login to view
思路分析
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 explanation

登录即可查看完整答案

我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。

类似问题

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. 

更多留学生实用工具

加入我们,立即解锁 海量真题独家解析,让复习快人一步!