part 1 The following statement applies to snow flaked schemas: Large savings in
ID: 3908939 • Letter: P
Question
part 1
The following statement applies to snow flaked schemas:
Large savings in storage space
Normalized structures are more difficult to update and maintain
Schema is less intuitive and end-users are put off by complexity
Ability to browse through the contents is easier
Improved query performance because of additional joins
The following statement applies to aggregation:
Aggregates are pre-calculated summaries derived from the most granular table
Each aggregate table is created as a specific summarization of only one dimension.
Formation of aggregate fact tables is not effective in improving query performance.
The following statement applies to data warehouses:
Data warehouses are typically constrained to a single application.
Data warehouses are optimized for performing read-write operations of single point transactions.
Data warehouses integrate copies of transaction data from disparate source systems.
Data warehouses are linked to the front-end application.
The following statement is an example of subject-oriented:
a, Each sales representative's sales are tracked over time.
b. The data warehouse is designed to track sales.
c. Sales representatives' information is only stored once.
d. Revenue is calculated by sales, region, etc.
e. Revenue data is extracted from the data warehouse.
The following statement is an example of nonvolatile:
Each sales representative's sales are tracked over time.
The data warehouse is designed to track sales.
Sales representatives' information is only stored once.
Revenue is calculated by sales, region, etc.
Revenue data is extracted from the data warehouse.
The following statement is an example of historical:
Each sales representative's sales are tracked over time.
The data warehouse is designed to track sales.
Sales representatives' information is only stored once.
Revenue is calculated by sales, region, etc.
Revenue data is extracted from the data warehouse.
The following statement is an example of summarized:
Each sales representative's sales are tracked over time.
The data warehouse is designed to track sales.
Sales representatives' information is only stored once.
Revenue is calculated by sales, region, etc.
Revenue data is extracted from the data warehouse.
The following is an example of integrated:
a. Each sales representative's sales are tracked over time.
b. The data warehouse is designed to track sales.
c. Sales representatives' information is only stored once.
d. Revenue is calculated by sales, region, etc.
e. Revenue data is extracted from the data warehouse.
Which of the following is correct in related to Online transaction processing (OLTP) and online analytical processing (OLAP) systems:
Normalized schemas for OLTP systems.
Regular backups with full, incremental, and archives for OLTP systems.
Star schemas for OLAP systems.
Large data sets of historical information in OLAP systems.
All of the above.
Which of the following statements is true in multidimensional structures:
The fact table is referred to as a cube
The columns within the fact table are referred to as measures.
The cube has edges which are referred to as dimensions.
Cubes, measures and dimensions interact with each other for reporting
All of the above.
None of the above.
Explanation / Answer
Please Note: Your Post contains more than one MCQ Questions. As per Chegg Answering Guidelines, I have answered the first question. Please Post Separate for Separate Questions.
The following statement applies to snow flaked schemas:
Large savings in storage space
Normalized structures are more difficult to update and maintain
Schema is less intuitive and end-users are put off by complexity
Ability to browse through the contents is easier
Improved query performance because of additional joins
Answer)
Large savings in storage space
In the snowflake schema the redundancy is reduced, and it becomes easy to maintain and also save storage space.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.