QuiztudyPREMIUM
🌍 All Study Guides📊 Dashboard📰 Blog💡 About
Google Business Intelligence Professional Certificate • STUDY MODE

DATABASE PERFORMANCE

QUESTION 1 OF 3

Fill in the blank: A data mart is a _____ database that can be a subset of a larger data warehouse. This means it is a convenient way to access the data pertaining to specific areas or departments of a business.

A
Specialized
B
Categorical
C
Subject-orientedCorrect Answer
D
Departmental
Explanation:

A data mart is a subject-oriented database that can be a subset of a larger data warehouse. This means it is a convenient way to access the data pertaining to specific areas or departments of a business.

QUESTION 2 OF 3

A business intelligence team manager wants to support their team’s ability to perform at a high level. They investigate the overall capability of their company’s database hardware and software tools to enable the team to process stakeholder requests. In this situation, which of the factors of database performance do they consider?

A
Workload
B
Resources
C
ThroughputCorrect Answer
D
Optimization
Explanation:

They consider throughput. Throughput describes the overall capability of the database’s hardware and software to process requests.

QUESTION 3 OF 3

What term is used to describe data that is broken up into many pieces that are not stored together?

A
Split data
B
Modified data
C
Archived data
D
Fragmented dataCorrect Answer
Explanation:

Fragmentation most often occurs when the data is used frequently, when new data files are created, or when existing data files are modified or deleted.

Ready to test your recall?

Fill in the blank: A data mart is a _____ database that can be a subset of a larger data warehouse. This means it is a convenient way to access the data pertaining to specific areas or departments of a business.

A
Specialized
B
Categorical
C
Subject-oriented
D
Departmental

How confident are you in this answer?