Multiple Choice Questions PDF

## Multiple Choice Questions 1. 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 data processing instead of analysis....

## Multiple Choice Questions 1. 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 data processing instead of analysis. - Online Analytical Processing (OLAP) tools are optimized for analysis in addition to processing and can analyze data from multiple databases. 2. Business intelligence professionals use design patterns to apply relevant measures and facts to what process? - Creating a data model 3. Fill in the blank: A foreign key is a field within a database table that is a ___ in another table. - reference 4. A dimensional model is a type of relational model that has been optimized in order to achieve what goal? - Quickly retrieve data from a warehouse 5. Fill in the blank: In a dimensional model, a foreign key is used to connect a dimension table to the appropriate ___ table. - fact 6. What are the key benefits of star and snowflake schemas? Select all that apply. - High-scale information delivery - More efficient output - Efficient data analysis 7. Members of a business intelligence team are transitioning their current database schemas to a new, desired state. They add columns, remove elements, and make other improvements. What does this situation describe? - Database migration 8. Which of the following statements accurately describe row-based and columnar databases? Select all that apply. - Columnar databases are often used in data warehouses. - In row-based databases, each row in the table is an instance or an entry in the database. - Row-based databases are organized by rows; columnar databases are organized by columns. 9. A business intelligence team is working with a database system that stores and analyzes data in the same place. What type of database system are they using? - Combined database system 10. Fill in the blank: A database schema must describe ___ because this is necessary when users want to understand how the data is shaped and the relationships within the database. - data partitions 11. In the ETL loading stage, what are typical target destinations to which the data might be delivered? Select all that apply. - Data lake - Analytics platform - Data warehouse 12. What type of programming language uses another program to read and execute coded instructions? - Interpreted