Tag Archives: Exam C2090-616 Q&A

C2090-625 IBM Cognos 10 BI Data Warehouse Developer

Test information:
Number of questions: 84
Time allowed in minutes: 90
Required passing score: 78%
Languages: English

Related certifications:
IBM Certified Developer – Cognos 10 BI Data Warehouses
IBM Certified Advanced Developer – Risk Information Governance for BI
IBM Certified Solution Expert – Cognos BI

The IBM Cognos 10 BI Data Warehouse Developer exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.

Data Manager and Data Warehousing (4%)
Identify how Data Manager can be used
Distinguish between OLTP systems and data warehouses

Catalogs and Data Source Connections (12%)
Describe the process of creating a catalog
Identify how to use SQLTerm
Describe how to configure text files using SQLTXT Designer
Describe how to package catalog components
Describe how to navigate through catalog components
Describe how to export catalog metadata to Cognos 8

Dimensions and Basic Hierarchies (7%)
Determine appropriate situations for using a hierarchy
Describe the use of the Reference Explorer tool
Describe the use of the Date Hierarchy wizard

Basic Dimension Builds and Fact Builds (12%)
Describe the types of builds
Describe the use of the Dimension Build wizard
Describe the process of creating a fact build
Describe the modification of build settings

Derivations and Derived Dimensions (6%)
Identify the benefits of creating a derivation
Determine the appropriate location to create a derivation
Identify when it would be useful to create a derived dimension

Conformed Dimensions (10%)
Describe the advantages of conformed dimensions
Describe surrogate keys
Describe how to deliver conformed dimensions
Describe how to check data integrity

Hierarchies and Lookups (8%)
Describe ways to modify hierarchies and lookups
Describe how to manipulate data using hierarchies and lookups
Dimensional History and Late Arriving Data (10%)
Describe the use of slowly changing dimensions (SCDs)
Describe the handling of late arriving fact and dimension data

Data Delivery and Data Processing (22%)
Describe delivering fact and dimension data
Describe how to merge and aggregate fact data
Describe how to restrict fact data delivery
Describe how to implement job control
Describe how to pivot fact data

User-Defined Functions (UDFs) and Variables (5%)
Describe how to create UDFs
Describe the use of variables

Troubleshooting and Tuning (4%)
Describe options to address memory and performance issues
Describe how to interpret the log files

QUESTION 1
Where can a developer define variables in Data Manager?

A. Metadata dimensions
B. Connections
C. JobStreams
D. Metadata collections

Answer: C


QUESTION 2
When delivering fact data to a text file, what can be specified?

A. Line and field delimiters
B. Whether the file is in ASCII or EBCDIC format
C. Maximum number of rows to be stored in the file
D. Default text editor to use with the file

Answer: A


QUESTION 3
What can be done to minimize memory consumption?

A. Disable dimension breaking on the fact build.
B. Disable fact build logging.
C. Enable dimension breaking on the fact build.
D. Enable auditing on the fact build.

Answer: C


QUESTION 4
Which of the following is true of the Navigator?

A. When searching for components, wildcards are not supported.
B. When a component is selected, dependent components are shown.
C. Library components (such as hierarchies) cannot be navigated.
D. Components from different catalogs can be compared.

Answer: B

Click here to view complete Q&A of C2090-625 exam
Certkingdom Review
, Certkingdom C2090-625 PDF

MCTS Training, MCITP Trainnig

Best IBM C2090-625 Certification, IBM C2090-625 Training at certkingdom.com

C2090-622 IBM Cognos 10 BI Administrator

Test information:
Number of questions: 47
Time allowed in minutes: 60
Required passing score: 78%
Languages: English, Japanese

The Cognos 10 BI Administrator exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.

Manage Administrative Content (11%)
Define the steps of creating a data source
Define the steps and options to deploy content from one Cognos 10 environment to another

Manage Report Content (21%)
Identify techniques to organize report content in the portal
Describe techniques to manage report content
Describe the technique to allow users to navigate from one report to another

Manage the Server Environment (51%)
Identify Cognos 10 architecture and components
Describe how Cognos 10 processes requests
Identify installation options and configurations
Identify load balancing options
Describe tasks to implement baseline configuration and performance tuning in Cognos 10
Describe tasks used to manage dispatchers and services
Describe how to implement logging
Identify troubleshooting techniques and resources in the server environment

Manage the Security Environment (17%)
Define how authentication is implemented in Cognos 10
Define how authorization is achieved and implemented in Cognos 10


QUESTION 1
After the installation of IBM Cognos BI, what must be done to ensure that only select users have unrestricted access to Public Folders in IBM Cognos Connection?

A. Add the Anonymous user to the Directory Administrators role.
B. Remove the Everyone group from the Server Administrators role.
C. Remove the Everyone group from the System Administrators role.
D. Remove the All Authenticated Users group from the Directory Administrators role.

Answer: C


QUESTION 2
To administer the contents of namespaces, the administrator must be a member of which predefined role?

A. Report Administrators
B. Server Administrators
C. Directory Administrators
D. System Administrators

Answer: C


QUESTION 3
What permission is needed to view and change the permissions of a IBM Cognos BI object?

A. Read
B. Set Policy
C. Traverse
D. Execute

Answer: B

 

Click here to view complete Q&A of C2090-622 exam
Certkingdom Review
, Certkingdom C2090-622 PDF

MCTS Training, MCITP Trainnig

Best IBM C2090-622 Certification, IBM C2090-622 Training at certkingdom.com

C2090-616 DB2 11.1 Fundamentals for LUW

Test information:
Number of questions: 63
Time allowed in minutes: 90
Required passing score: 69%
Languages: English, Japanese

This Database Associate certification is an entry level exam for a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 11.1 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 11.1, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Section 1 – Planning (21%)
Identify and describe the DB2 products available
Identify and decribe the DB2 Cloud offerings available
Describe the characteristics of OLTP and Data Warehouse workloads
Describe the benefits of DB2 pureScale
Demonstrate the ability to use DB2 BLU Acceleration
Explain Federation support
Identify and describe Oracle and Netezza Compatibility Features

Section 2 – Security (17%)
Describe methods used to restrict data access
Identify and describe the authorities and privileges available
Identify and describe the DCL statements available
Describe Roles and Trusted Contexts

Section 3 – Working with Databases and Database Objects (16%)
Create and connect to DB2 servers and databases
Identify DB2 objects
Identify and describe the DDL statements available
Describe the different types of tables available

Section 4 – Working with DB2 Data using SQL (19%)
Demonstrate the ability to use SQL to SELECT data from tables
Demonstrate the ability to use SQL to UPDATE, DELETE, or INSERT data
Demonstrate the ability to manage transactions
Demonstrate the ability to create and call an SQL stored procedure or a user defined function
Identify and describe SQL compatibility enhancements
Identify the OLAP function used to meet a specific business requirement

Section 5 – Working with DB2 Tables, Views, and Indexes (13%)
Identify and describe the DB2 data types available
Identify the characteristics of a table, view or index
Demonstrate the ability to create and use temporary tables
Demonstrate the ability to create and use triggers

Section 6 – Data Concurrency (14%)
Identify factors that influence locking
List objects on which locks can be obtained
Identify characteristics of DB2 locks
Given a situation, identify the isolation level that should be used

Click here to view complete Q&A of C2090-616 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2090-616 Certification, IBM C2090-616 Training at certkingdom.com