P2090-027 Exam Questions

Which of the following tools can be used by a DBA to edit data for a DB2 table?

Which InfoSphere Warehouse capability allows access to analytical information with no data extraction?

When a DB2 database is created, which of following tablespaces is not created by default?

Which InfoSphere Warehouse feature does not help you to reduce storage costs?

Which answer best describes the IBM Smart Analytics System?

Which of the following tables consists of measurement or metric data of a business process in a multi-dimensional schema model?

Which is the last phase in the life cycle of an InfoSphere Warehouse application where a value of a variable can be changed?

A physical database model was reverse engineered from an existing DB2 database. Several changes were then made to the physical model. Which Design Studio feature would be used to s...

Using InfoSphere Warehouse Design Studio, how do you propagate the changes that you made in your project?

In a control flow, the Start operator has an on-failure port. When are any operators linked to that port executed?

You work for an insurance company and have been asked to help find a way to detect which health care providers may be submitting fraudulent claims. Which mining method would you em...

Which section of the InfoSphere Warehouse Admin Console menu would be used to deploy and manage a data mining application?

Which of the following data warehouse schemas cannot be modeled into a Cube Model object?

How do you monitor the status of a running control flow?

Which of the following is not a valid InfoSphere Warehouse Data Mining technique/algorithm?

After creating a cube model, what step(s) is(are) required to create a cube based on a cube model?

In a control flow, which of the following can be used to control looping through an iteration process?

What are the steps required before a Calculated Measure can be used in an OLAP cube?

Which utility is best suited for moving large amounts of data into DB2 with minimum logging?

What steps are required to create a parallel set of table load operations from already created data flows?

Which InfoSphere Warehouse deployment architecture is best suited for large data warehouse environments with many data warehouse and BI developers?

When InfoSphere Warehouse is implemented in a three node configuration, which two servers can contain Cubing Services components? (Choose two.)

In a three node configuration, which two servers can contain InfoSphere Warehouse Intelligent Miner components? (Choose two.)

What operating system is included with IBM Smart Analytics System 5710?

Which statement about table partitioning is false?

Which tool can be used to display the access plan for a particular SQL query?

Which of the following can improve the performance of InfoSphere Warehouse?

Which of the following questions could be answered with the use of InfoSphere Warehouse Packs?

Which type of backup is used to capture all database changes since the most recent, successful, full backup operation?

Which of the following is not an InfoSphere Warehouse Model pack?

Assume your storage unit has a strip size of 128KB and a stripe size of 512KB. What is the optimal extent size for a page size of 16KB?

Which of the following is not a valid method of starting a cube server?

What sizing metric is used to identify the IBM Smart Analytics System and InfoSphere Warehouse data and growth capacity?

Which mining operator is used to preserve a mining model rules in relational tables?Which mining operator is used to preserve a mining model? rules in relational tables?

What is an advantage of using an IBM Smart Analytics System over a traditional data warehousing solution?

An analytic workload might exhibit one of the following characteristics:

Which statement about control flows is true?

Which of the following is an appropriate distribution key?

Which of the following data flow operators does not have the capability of creating a persistent DB2 table?

What type of join is the most efficient?

What is the procedure for changing the temperature of a table space configured using the multi- temperature storage feature?

A cube has been designed in Design Studio. What step(s) is(are) required to make it available to an existing cube server?

Which methodology of the following can be used to analyze multidimensional data structures?

Which InfoSphere Warehouse tool will the OLAP developers use to create OLAP cube models?

In dimensional modeling, which of the following schema models is capable of combining multiple business processes?

Customers who are looking for a customizable data warehouse solution with the ability to choose their software and hardware should consider:

The Unstructured Analysis component of InfoSphere Warehouse provides the ability to:

What is the output of the Cubing Services Optimization Advisor?

Which statement about data flows is true?

For text analytics, the technique that uses a dictionary to do searching is known as which type of information extraction?