Whatever type of data mart you may have, its purpose is to:

Practice More Questions From: Final Quiz

Q:

What type of data warehouse structure meets an organization’s need for scalability, engagement of managed services, and flexible payment plans?

Q:

Which of the following is a total cost of ownership consideration when choosing a data warehouse?

Q:

Which of the following is a feature related to structure that an organization should consider when selecting a data warehouse?

Q:

Which of the following are the data sources for data marts?

Q:

There are three basic types of data marts: dependent, independent, and hybrid. What does a dependent data mart do?

Q:

Which of the following statements is true regarding dependent data marts?

Q:

Whatever type of data mart you may have, its purpose is to:

Q:

Which of the following statements is true regarding Snowflake?

Q:

Which of the following are data warehouse systems that offer pre-integrated bundles of hardware and software providing high performance for workloads and low maintenance overhead?

Q:

Who is a typical user of data lakes?

Q:

What are data lake benefits?

Q:

Which of the following statements is true regarding data lakes?

Q:

Accumulating snapshot fact tables are used to __________.

Q:

Which of the following is an example of a “fact” in the context of data warehousing?

Q:

What is a “dimension” in the context of data warehousing?

Q:

What is the final consideration in designing star schemas?

Q:

Which of the following is true regarding a star schema?

Q:

When is it most appropriate to denormalize a star schema?

Q:

What is the difference between a star schema and a snowflake schema?

Q:

What operations easily generate fact summaries that may be required by management?

Q:

In which situation is it most appropriate to materialize a view?

Q:

What are staging areas primarily used for?

Q:

Which statement is true in regard to staging areas?

Q:

Which of the following is one of the ways staging areas can be implemented?

Q:

Which of the following URLs would you use to sign up for a trial of Cognos Analytics?

Q:

Which of the following is true regarding Cognos Analytics?

Q:

Which of the following best describes Cognos?

Q:

In Cognos Analytics, which are the two main navigational areas of the interface?

Q:

Which statement best describes descriptive analytics?

Q:

Which statement best describes prescriptive analytics?

Q:

What are the three methods you can use to create visualizations in Cognos?

Q:

What happens first when you use the Cognos Assistant to help create a dashboard?

Q:

Which of the following is true with regards to Cognos dashboards?

Q:

When connecting Cognos to a data repository with IBMdb2, what must you remember to do before entering the JDBC URL into Cognos? (Select two correct answers.)

Q:

What are the two ways to create calculations in Cognos Analytics? (Select 2 correct answers)

Q:

Which of the following is the first step involved in accessing a data warehouse from Cognos?

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments