21. What is a measure of the workload that can be processed by a database, as well as the associated costs?
- Scalability
- Database performance
- Distribution
- Maturity
22. Fill in the blank: A query plan describes the _____ involved with executing a query by a relational database.
- business strategy
- steps
- spreadsheets
- reasoning
23. Which of the following statements accurately describe indexes versus data partitions? Select all that apply.
- Data partitioning is typically used in cloud-based systems handling big data.
- Indexes are organizational tags used to locate data.
- Indexes can only locate one section of a table at a time.
- Data partitioning is the process of dividing a database into distinct, logical parts.
24. Fill in the blank: Fragmented data occurs when data is broken up into many pieces that are not_____, often as a result of using the data frequently.
- stored together
- sorted and filtered
- structured
- labeled
25. When evaluating the workload of a database system, what does a business intelligence professional consider? Select all that apply.
- Context
- Transactions
- System commands
- Queries and analyses
26. A business intelligence team is optimizing the performance of their database. What does this involve? Select all that apply.
- Comparing workload to cost
- Identifying better data sources and structures
- Evaluating the effectiveness of the team’s spreadsheets
- Examining resource use
27. Fill in the blank: A business intelligence team uses _____ to divide their cloud database system into logical parts. This helps improve query processing and manageability.
- data partitioning
- the SPLIT function
- database migration
- metadata
28. A business intelligence team can cause _____ when two or more data analysts attempt to use a single data resource in a conflicting way.
- repetition
- annotation
- contention
- verification