21. Which of the following statements accurately describe the loading stage of the ETL process? Select all that apply.

  • Data is returned to its source.
  • Once the data has been delivered, it can exist in multiple formats.
  • Data is delivered to its target destination.
  • Once the data has been delivered, it can exist within multiple locations.

22. Object-oriented programming languages _____ data objects with code, enabling them to be used again later.

  • encode and translate
  • compile and group
  • label and define
  • interpret and analyze

23. Which type of tool can analyze data from multiple databases and is optimized for both analysis and processing?

  • Data mart
  • Online Transaction Processing (OLTP)
  • Data lake
  • Online Analytical Processing (OLAP)

24. In a dimensional model, what might facts represent? Select all that apply.

  • Metrics
  • Events
  • Supporting details
  • Attributes

25. FIll in the blank: In a dimensional model, a foreign key is used to connect a dimension table to the appropriate _____ table.

  • fact
  • primary
  • measurement
  • relationship

26. A business intelligence team wants to improve the state of their database schemas. While working toward this goal, they move data from one source platform to another target database. What process does this situation describe?

  • Database iteration
  • Data partitioning
  • Data throughput
  • Database migration

27. In row-based databases, each row in a table is an instance or an entry in the database. How are details about that instance recorded and organized?

  • By column
  • By table
  • By field
  • By row

28. In the ETL loading stage, what are typical target destinations to which the data might be delivered? Select all that apply.

  • Analytics platform
  • Data lake
  • Data warehouse
  • Website application

Shuffle Q/A 3

29. What type of programming language uses another program to read and execute coded instructions?

  • Object-oriented
  • Interpreted
  • Functional
  • Compiled

30. Fill in the blank: In order to create an effective data model, business intelligence professionals will often apply a _____, which uses relevant measures and facts to create a model that supports business needs.

  • target table
  • query plan
  • business rule
  • design pattern

Leave a Reply