Knowee
Questions
Features
Study Tools

Which of the following statements about Data Warehouses are correct?Group of answer choicesData warehouses are suited to answering low-level questions, such as "what is customer X's phone number?"A data warehouse star schema is in third normal formData is transferred from the operational database(s) to the data warehouse via recovery systemsData warehouses are subject-oriented, integrated, time-variant and non-volatile

Question

Which of the following statements about Data Warehouses are correct?Group of answer choicesData warehouses are suited to answering low-level questions, such as "what is customer X's phone number?"A data warehouse star schema is in third normal formData is transferred from the operational database(s) to the data warehouse via recovery systemsData warehouses are subject-oriented, integrated, time-variant and non-volatile

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution

The correct statements about Data Warehouses are:

  1. Data is transferred from the operational database(s) to the data warehouse via recovery systems: This statement is incorrect. Data is typically transferred from operational databases to a data warehouse through ETL (Extract, Transform, Load) processes, not recovery systems.

  2. A data warehouse star schema is in third normal form: This statement is incorrect. A star schema is a type of database schema that is optimized for data warehouse and OLAP (Online Analytical Processing) systems. It is not in third normal form, which is a type of database normalization designed to reduce redundancy in relational databases.

  3. Data warehouses are suited to answering low-level questions, such as "what is customer X's phone number?": This statement is incorrect. Data warehouses are designed for complex queries and data analysis rather than simple, low-level queries. Operational databases are more suited to answering these types of questions.

  4. Data warehouses are subject-oriented, integrated, time-variant and non-volatile: This statement is correct. These are the four main characteristics of a data warehouse according to Bill Inmon, who is considered the father of data warehousing.

So, the only correct statement about Data Warehouses from the given options is "Data warehouses are subject-oriented, integrated, time-variant and non-volatile".

This problem has been solved

Similar Questions

__________describes the data contained in the data warehouse.Question 15Answera.Relational datab.Metadata.c.Operational datad.Informational data.

The important aspect of the data warehouse environment is that data found within the data warehouse is___________.Question 14Answera.time-variantb.subject-oriented.c.integratedd.All of the above

Information stored in the data warehouse Blank______.Multiple choice question.gives customers' income dataincludes competitors' datais kept hidden from all personnel except top managementmay be accessed by analysts from various levels of the corporation

Which of the following statements correctly describe a database (more than one answer)?Group of answer choicesA database is a collection of dataA database manages and provides access to dataA database is structured and integrated

Identify characteristics of data warehouses. More than one answer is possible.1 pointPopulated from operational databases and external data sourcesOptimized for efficient and reliable processing of large volumes of daily transactions.Transformations and integrations performed to support decision makingOptimized for reporting that summarizes large amounts of data

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.