000-719 - InfoSphere Warehouse V9.5
Go back to IBM
If you roll-in daily and roll-out monthly, which approach reduces the number of table partitions and eases the DBA administrative tasks?
Specify a MDC on day and a table partition key for month.
What is the reason for creating a subprocess?
to allow thesubprocess to be re-used as needed in other control flows and ubprocesses
A new data mart or star schema has been physically designed in a data modeling tool by someone in the team, and the SQW developer wants to use that model to design some data flows. Which data modeling tool is supported by the Data Model Import Wizard of Design Studio?
A cube model has been created but one of the dimensions does not have a hierarchy defined. After right-clicking on the dimension and selecting "Add Hierarchy", which two steps are required to complete the definition of the new hierarchy? (Choose two.)
On the General Properties page, specify a hierarchy name.
On the Levels Property page, specify the levels to include in the hierarchy.
When InfoSphere Warehouse is implemented in a three node configuration, which two servers can contain Cubing Services components? (Choose two.)
You manage a store and want to increase the sales of some high profit items. One way to do this is by placing these items close to other products that are often purchased with the high profit items. You have a year's history of all sales, including all the items that were purchased in each sale. To determine optimal product placement for the high profit items, which mining method should be used to analyze your data?
As a system administrator, you have defined a cube server, specifying that all cubes are to start automatically, and added a cube to that server. You created a script to start the cube server from the command line. Wanting to make sure that your users have good performance, you want the members of your cube to be cached prior to the first user's access of the cube. What will allow you to accomplish this?
Just execute the cube server startup script.
Which type of information extraction for text analytics is defined using Java regular expressions?
An XML file that contains cube model and cube metadata is imported into the Design Studio which is connected to the cubing services repository. Which statement is true regarding adding the cube to a cube server?
Donothing, the cube was defined in the repository when the XML file was imported into theDesign Studio.
Which statement is true about Rational Data Architect (RDA) integration with the Design Studio for data modeling?
Design Studio includes the physical data modeling component to help you implement your physical model.
When connecting an Output Port of a Table Source to the Names Port of a Sequences Operator, what are two valid methods of mapping columns? (Choose two.)
In a three node configuration, which two servers can contain InfoSphere Warehouse Intelligent Miner components? (Choose two.)
A high-quality physical database design is one that meets which two goals? (Choose two.)
Improves the efficiency of database management.
You are implementing a DB2 Workload Manager (WLM) schema to limit the number of load utilities that can execute concurrently. Which WLM object would be used to accomplish this?
work class with an associated work action and an appropriate threshold
Relational database and a database model that is often a star or snowflake schema are characteristics of which engine storage structure?
Using InfoSphere Warehouse a physical data model provides the metadata for database objects that are useful for which task?
when designing data flows
An administrator has created a database connection to the Production transactional relational database. A data mart is desired that extracts data from that database. Taking time and ease into account, how should the database physical model for the input tables be created?
The physical database objects can be reverse engineered in Design Studio.
During which installation and configuration process can user groups be mapped to each role?
the execution of theInfoSphere Warehouse Configuration Tool
Which two statements are true about a hierarchies, levels, and dimensions? (Choose two.)
A hierarchy object is an ordered list of level objects.
Each dimension can have multiple hierarchies.
When debugging a data flow, how do you set a break point in the execution plan graph (EPG)?
Select Toggle Breakpoint on a node.
OLAP metadata for a star schema has been defined in the Design Studio and exported as an XML document. Which step(s) are required to deploy the cube to a cube server?
Import the cube to the cubing services repository, associate the cube with a data source, and add it to a cube server.
Which two InfoSphere Warehouse components are included in the logical group for the Application Server? (Choose two.)
IBM Data Server Client
WebSphere Application Server
The Design Studio is connected to the cubing services repository. Which steps must be completed to deploy a cube and allow it to be accessed by cubing services?
Use the Design Studio to export the cube metadata and then import the cube metadata into cubing services.
Several operators are defined and linked together in DataFlow1. Another set of operators make up DataFlow2. A control flow is defined and both DataFlow1 and DataFlow2 are used. You require that DataFlow1 dynamically change the variable values used in DataFlow2. How can you fulfill this requirement?
Using the File Export operator, DataFlow1 writes a file, containing updated variable values. A variable assignment operator is then used to assign the values in the file to the appropriate variables. DataFlow2 then has access to the updated variable values.
A bank wants to create a target marketing campaign for a particular type of loan by building the demographic profile for customers with this loan type and then selectively targeting the customers with similar profiles that currently do not have this type of loan. Which data mining method should be used to achieve this objective?
A customer wants to evaluate deep data compression in an AIX development environment. Which edition of InfoSphere Warehouse should they buy?
InfoSphere Warehouse Developer
You can use the Admin Console to add, remove, start, stop, or restart cubes. For which other purpose can the Admin Console be used?
to rebuild a cube member cache
In a control flow, the Start operator has an on-failure port. When are any operators linked to that port executed?
At the end of a control flow, if there were any on-failure actions processed by any control flow operators.
What does a Data Design Project within Design Studio contain?
physical data model
In which two modes can you create mining flows? (Choose two.)
You can work in online mode only if the Design Studio is connected to a database.
You can work in offline mode only if the Design Studio is connected to a data model.
When using the Design Studio to define hierarchies for a cube model, you specify the hierarchy type and deployment method. If you were to specify a hierarchy type of "balanced" and a deployment of "standard", what would that imply?
The levels in the hierarchy have associated meaning, branches have consistent depth and the parent of any member is found in the level above. The data used to define the members of ALL of the levels for a specific branch of the hierarchy is found in a single row in the dimension table.
What is a benefit of using warehouse based analytics?
It provides a common pool of analytic methods to produce consistent answers across all users.
A cube has been deployed to cubing services. Due to an increase in the workload accessing the cube, response time has increased. What would allow you to apply additional resources (memory, CPU) to decrease the response time?
Add the cube to two different cube servers that are each connected to the same repository.
Which tool should be used to design a mining flow?
Use the mining editor to analyze existing data for the mining specific tasks in a production database.
Certain operators cannot be placed directly into a parallel container. Some of these operators are iterators, variable comparisons, and parallel containers. Which technique could you use to overcome this restriction?
Place them first in asubprocess and then place the subprocess in the parallel container.
Which two functions can the SQW tool perform for a data flow? (Choose two.)
range partitioning for staging tables
filtering and sorting for operator properties such as table columns
When using InfoSphere Warehouse, in which two occasions is it appropriate to run the InfoSphere Warehouse configuration tool? (Choose two.)
any time after installation to modify your configuration
immediately after installation
For recovery purposes, it is desired to keep the output of several data flow operators after the execution has ended. This can be done in two different ways. Which two types of operators and properties would you use to keep the output? (Choose two.)
A Data Station operator with a type of file and a file name.
A Data Station operator with a type of persistent table and a table name.
Customer Relationship Management (CRM) requires business insights that enable firms to offer specific, personalized services, and products to their customers. Which mining method is used for customer segmentation CRM applications?
What is the Design Studio used for as part of Cubing Services?
to create OLAP metadata
You work for an automobile manufacturing company and have been asked to use data mining to determine which part is most likely to fail after a certain amount of time on a particular vehicle model. You have gathered repair history. Which mining method should be used?
A logical data model was created in a design tool. It is needed as a reference for a data warehouse project. How can the logical model be used within Design Studio to create a database model?
Use the design tool to create a DDL file then use Design Studio to reverse engineer the model from the DDL file.
You want an employee to be able to create, deploy, and schedule applications in the InfoSphere Warehouse. At a minimum, which roles should be assigned to the employee?
Administrator and Manager
Using InfoSphere Warehouse Design Studio, what are two ways to create a physical data model? (Choose two.)
You can reverse-engineer if you have access to the DDL scripts that were used to create the data sources.
You can create it automatically by selecting the "online mode" when you create your data flows.
Every night, an InfoSphere Warehouse application updates data in a star schema in the data warehouse. The update process is taking longer than expected and so management decides to begin the update process at an earlier time each day. Which function of the Admin Console will accomplish this task?
Use Manage Processes Schedules Update.
Process profiles must be used under which situation in SQL Warehouse run-time environment?
when scheduled processes contain instance variables with a phase of EXECUTION_INSTANCE
A customer is having performance issues with a query against a cube they built using Cube Services. Examination of EXPLAIN output determines that the query did not use the MQTs (summary tables). Which situation would cause the Optimizer to bypass the MQTs?
The query accesses data that is below the cube slice in the summary table.
Which two tools should an InfoSphere Warehouse developer use to perform SQL Warehousing design tasks? (Choose two.)
InfoSphere Warehouse Design Studio
SQL Warehousing Tool
A warehouse application contains a process that in turn contains an activity that references a variable with a final phase of EXECUTION_INSTANCE. When going through the schedule wizard, which object is actually scheduled?
a process profile
Using InfoSphere Warehouse Design Studio, which two are required before you can work on a physical data model? (Choose two.)
You need to create a data design project.
You need to identify either the source or the target databases.