adplus-dvertising
frame-decoration

Question

What are the two methods for maintaining a data warehouse and keeping it up to date after the initial load?

a.

Extraction and transformation

b.

Update and delete

c.

Update and refresh

d.

Full load and incremental load

Answer: (c).Update and refresh Explanation:The two methods for maintaining a data warehouse and keeping it up to date after the initial load are "update" and "refresh."

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What are the two methods for maintaining a data warehouse and keeping it up to date after the initial load?

Similar Questions

Discover Related MCQs

Q. When might a full refresh be a better option than an update for keeping a data warehouse up to date?

Q. What is the primary reason for converting production system keys to system-generated keys in the data warehouse?

Q. What is the key of the fact table in a data warehouse based on?

Q. What is the primary function of ETL (Extraction, Transformation, and Loading) in a data warehouse?

Q. Why is data extraction for a data warehouse an ongoing function carried out at very frequent intervals?

Q. What is the key difference between data loading in a data warehouse and data loading for a new operational system?

Q. What role do vendor tools play in the ETL process for data warehousing?

Q. What are the three main components of the ETL process?

Q. Why is data transformation in a data warehouse more complex than conversion functions for operational systems?

Q. When might a full refresh be used for data loading in a data warehouse?

Q. Why is ongoing data extraction required in a data warehouse?

Q. What is the primary role of data transformation in a data warehouse?

Q. What is the ETL process, and why is it critical for data warehousing?

Q. Which of the following ETL tool categories offers maximum flexibility for data transformations, full loads, and incremental loads?

Q. What is the primary source of data captured through replication in ETL tools?

Q. What is the primary role of code generators in ETL?

Q. Which ETL tool option is offered by several DBMS vendors at little or no extra cost, making it attractive to many organizations?

Q. What are some of the common features or capabilities provided by ETL tools?

Q. Which ETL tool category generates program code for data extraction and transformation and allows users to add custom code for special conditions?

Q. What do ETL tools primarily use to perform data capture through replication?