31. In a dimensional model, what might dimensions represent? Select all that apply.
- Attributes
- Events
- Metrics
- Supporting details
32. In a snowflake schema, what is used to break down the schema into even more specific tables? Select all that apply.
- Query plans
- Dimensions
- Fact tables
- Subdimensions
33. Fill in the blank: A database schema must use _____ for each entry within the database in order to build connections between tables and enable users to combine relevant data.
- unique keys
- system commands
- business rules
- data partitions
34. In which stage of the ETL process is data delivered to a target system?
- Transformation
- Loading
- All three stages
- Extraction
35. Which of the following statements correctly describe Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) tools? Select all that apply.
- Online Transaction Processing (OLTP) tools are optimized for analysis in addition to processing and can analyze data from multiple databases.
- Online Analytical Processing (OLAP) tools are optimized for analysis in addition to processing and can analyze data from multiple databases.
- Online Analytical Processing (OLAP) tools are optimized for data processing instead of analysis.
- Online Transaction Processing (OLTP) tools are optimized for data processing instead of analysis.
36. Fill in the blank: A primary key references a _____ to uniquely identify records in the table.
- row or group of rows
- query
- schema
- column or group of columns
37. What are the key benefits of star and snowflake schemas? Select all that apply.
- High-scale information delivery
- More efficient output
- Effective data monitoring
- Efficient data analysis