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

Leave a Reply