Number of questions: 50
Number of questions to pass: 34
Time allowed: 90 mins
This multiple-choice test contains questions requiring single and multiple
answers. For multiple-answer questions, you need to choose all required options
to get the answer correct. You will be advised how many options make up the
correct answer.
This test is designed to provide diagnostic feedback on the Examination Score
Report, correlating back to the test objectives, informing the test taker how he
or she did on each section of the test. As a result, to maintain the integrity
of each test, questions and answers are not distributed.
The test contains three sections totalling 50 multiple-choice questions. The
percentages after each section title reflect the approximate distribution of the
total question set across the sections.
Section 1 - Business Infrastructure 20%
Identify the components in Cúram SPM
Describe the roles of rules and evidence in Cúram SPM
Identify the main components of the Cúram SPM user interface
Describe the main components of Cúram Workflow
Section 2 - IBM Cúram Social Program Management (SPM) Platform 50%
Describe some key features of system administration in Cúram
Discuss how cases are used in Cúram and identify Cúram case types
Explain Cúram Participant Management and Cúram participant role types
Outline the functionality of the Cúram evidence framework
Describe the financial management functionalities, including key financial
building blocks in Cúram
Section 3 - Enterprise Modules 30%
Summarize how the Cúram Evidence Broker Enterprise Module addresses the
evidence sharing requirements of SPM agencies
List and describe the main functions of the Cúram Outcome Management Enterprise
Module
Explain the purpose of the Cúram Provider Management (CPM) Enterprise Module and
identify key CPM positions
Describe the main components of the Cúram Universal Access Enterprise Module
List and describe the hierarchy of elements within the Cúram Verification
Enterprise Module
Overview
PartnerWorld Code: 58000204
Replaces PW Code: 58000203
Status: Live
This entry level certification is intended for business analysts,
consultants, testers, and any personnel who would like to acquire foundational
IBM Cúram skills required to work on IBM Cúram implementation projects.
The following skills are essential for successful performance on this test:
Working knowledge of health and human services programs
The following skills are suggested for successful performance on this test:
Exposure and experience in typical business analysis activities related to
system implementations
Exposure to Enterprise applications and Custom Off-The-Shelf (COTS) products
In preparing for this certification, the following IBM course is highly
recommended:
9D47G: Fundamentals of the IBM Cúram SPM Platform for Business Analysts 6.0.5
You may also consider accessing this expert arena to practice using IBM Cúram
features and improve your general experience with the product:
9D56G: IBM Cúram SPM Platform Runtime Environment 6.0.5 - Expert Arena (SPVC)
Thursday, October 19, 2017
C7010-013 IBM Cúram V6.0.5 Business Analysis and Design
Tuesday, June 20, 2017
C2090-545 DB2 9.7 SQL Procedure Developer
Test information:
Number of questions: 60
Time allowed in minutes: 90
Required passing score: 60%
Languages: English
An IBM Certified Solution Developer - DB2 9.7 SQL Procedure Developer has significant experience with intermediate or advanced level skills in developing DB2 stored procedures, user defined functions and triggers.
An IBM Certified Solution Developer - DB2 9.7 SQL Procedure Developer has significant experience with intermediate or advanced level skills in developing DB2 stored procedures, user defined functions and triggers.
Section 1 - SQL Procedural Language (30%)
Describe how to define variables and cursors
Demonstrate the ability to code assignment statements
Demonstrate knowledge of SQL Control statements
Demonstrate knowledge of error handling
Section 2 - DB2 SQL Procedures (23%)
Demonstrate knowledge how to identify proper usage of SQL procedures
Demonstrate the ability to use the CREATE PROCEDURE statement
Demonstrate knowledge of the proper structure of an SQL procedure body
Demonstrate knowledge of how to return values and result sets from SQL procedures
Demonstrate knowledge of nested procedures
Demonstrate how to test and deploy SQL procedure
Section 3 - Functions (12%)
Demonstrate knowledge how to identify proper usage of functions
Demonstrate the ability to use the CREATE FUNCTION statement
Demonstrate knowledge of the proper structure of a function body
Demonstrate knowledge of how to return values and a table using functions
Describe how to invoke functions
Demonstrate how to test and deploy functions
Section 4 - Triggers (8%)
Demonstrate knowledge how to identify proper usage of triggers
Demonstrate the ability to use the CREATE TRIGGER statement
Demonstrate the ability to identify the actions of a trigger
Demonstrate knowledge of advanced usage of triggers
Demonstrate how to test and deploy triggers
Section 5 - Advanced Features (16%)
Demonstrate knowledge of Declared Global Temporary Tables
Describe how to use system features (ADMIN_CMD)
Describe how to use Arrays and Associated Arrays
Describe how to use Global Variables
Describe how to use Modules
Describe how to enable a database to support PL/SQL procedures
Section 6 - Related Tools (10%)
Demonstrate knowledge of application development tools
Demonstrate knowledge of Debugging with tools
Demonstrate knowledge of using Explain with tools
IBM Certified Solution Developer - DB2 9.7 SQL Procedure
Job Role Description / Target Audience
An IBM Certified Solution Developer - DB2 9.7 SQL Procedure has significant experience with intermediate or advanced level skills in developing DB2 stored procedures, user defined functions and triggers.
Recommended Prerequisite Skills
This individual has strong skills in DB2 SQL, DB2 SQL Procedural Language and in related tools, such as IBM Data Studio.
Requirements
This certification requires 2 test(s).
Test(s) required:
Click on the link(s) below to see test details, test objectives, suggested training and sample tests.
Any 1 of the following tests:
Test C2090-700 - DB2 V8.1 Family Fundamentals
Test C2090-730 - DB2 9 Family Fundamentals
Test C2090-610 - DB2 10.1 Fundamentals
Test C2090-320 - DB2 11 Fundamentals for z/OS
Test C2090-545 - DB2 9.7 SQL Procedure Developer
QUESTION 4
Which three optional clauses can be used when creating an external function? (Choose three.)
A. SCRATCHPAD
B. NOTEPAD
C. LANGUAGE
D. EXTERNAL NAME
E. DATABASEINFO
Answer: A,C,D
Explanation:
QUESTION 4
Which statement is permitted within a scalar user-defined function body?
A. COMMIT
B. INSERT
C. SIGNAL
D. LOOP
Answer: C
Explanation:
Number of questions: 60
Time allowed in minutes: 90
Required passing score: 60%
Languages: English
An IBM Certified Solution Developer - DB2 9.7 SQL Procedure Developer has significant experience with intermediate or advanced level skills in developing DB2 stored procedures, user defined functions and triggers.
An IBM Certified Solution Developer - DB2 9.7 SQL Procedure Developer has significant experience with intermediate or advanced level skills in developing DB2 stored procedures, user defined functions and triggers.
Section 1 - SQL Procedural Language (30%)
Describe how to define variables and cursors
Demonstrate the ability to code assignment statements
Demonstrate knowledge of SQL Control statements
Demonstrate knowledge of error handling
Section 2 - DB2 SQL Procedures (23%)
Demonstrate knowledge how to identify proper usage of SQL procedures
Demonstrate the ability to use the CREATE PROCEDURE statement
Demonstrate knowledge of the proper structure of an SQL procedure body
Demonstrate knowledge of how to return values and result sets from SQL procedures
Demonstrate knowledge of nested procedures
Demonstrate how to test and deploy SQL procedure
Section 3 - Functions (12%)
Demonstrate knowledge how to identify proper usage of functions
Demonstrate the ability to use the CREATE FUNCTION statement
Demonstrate knowledge of the proper structure of a function body
Demonstrate knowledge of how to return values and a table using functions
Describe how to invoke functions
Demonstrate how to test and deploy functions
Section 4 - Triggers (8%)
Demonstrate knowledge how to identify proper usage of triggers
Demonstrate the ability to use the CREATE TRIGGER statement
Demonstrate the ability to identify the actions of a trigger
Demonstrate knowledge of advanced usage of triggers
Demonstrate how to test and deploy triggers
Section 5 - Advanced Features (16%)
Demonstrate knowledge of Declared Global Temporary Tables
Describe how to use system features (ADMIN_CMD)
Describe how to use Arrays and Associated Arrays
Describe how to use Global Variables
Describe how to use Modules
Describe how to enable a database to support PL/SQL procedures
Section 6 - Related Tools (10%)
Demonstrate knowledge of application development tools
Demonstrate knowledge of Debugging with tools
Demonstrate knowledge of using Explain with tools
IBM Certified Solution Developer - DB2 9.7 SQL Procedure
Job Role Description / Target Audience
An IBM Certified Solution Developer - DB2 9.7 SQL Procedure has significant experience with intermediate or advanced level skills in developing DB2 stored procedures, user defined functions and triggers.
Recommended Prerequisite Skills
This individual has strong skills in DB2 SQL, DB2 SQL Procedural Language and in related tools, such as IBM Data Studio.
Requirements
This certification requires 2 test(s).
Test(s) required:
Click on the link(s) below to see test details, test objectives, suggested training and sample tests.
Any 1 of the following tests:
Test C2090-700 - DB2 V8.1 Family Fundamentals
Test C2090-730 - DB2 9 Family Fundamentals
Test C2090-610 - DB2 10.1 Fundamentals
Test C2090-320 - DB2 11 Fundamentals for z/OS
Test C2090-545 - DB2 9.7 SQL Procedure Developer
QUESTION 1
A developer needs to create a user-defined function that will return a list of employees who work in
a particular department. Which statement will successfully create a function that meets this
objective?
A. CREATE FUNCTION dept_employees (deptno CHAR(3))
RETURNS TABLE
LANGUAGE SQL
READS SQL DATA
RETURN
SELECT empno, lastname AS l_name, firstnme AS f_name
FROM employee
WHERE employee.workdept = dept_employees.deptno
B. CREATE FUNCTION dept_employees (deptno CHAR(3))
RETURNS TABLE
DYNAMIC RESULT SETS 1
LANGUAGE SQL
READS SQL DATA
DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name
FROM employee
WHERE employee.workdept = dept_employees.deptno
OPEN emp_info;
RETURN
C. CREATE FUNCTION dept_employees (deptno CHAR(3))
RETURNS TABLE (empno CHAR(6),
l_name VARCHAR(15),
f_name VARCHAR(12))
LANGUAGE SQL
READS SQL DATA
RETURN
SELECT empno, lastname AS l_name, firstnme AS f_name
FROM employee
WHERE employee.workdept = dept_employees.deptno
D. CREATE FUNCTION dept_employees (deptno CHAR(3))
RETURNS TABLE (empno CHAR(6),
l_name VARCHAR(15),
f_name VARCHAR(12))
DYNAMIC RESULT SETS 1
LANGUAGE SQL
READS SQL DATA
DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name
FROM employee
WHERE employee.workdept = dept_employees.deptno
OPEN emp_info;
RETURN
Answer: C
Explanation:
A developer needs to create a user-defined function that will return a list of employees who work in
a particular department. Which statement will successfully create a function that meets this
objective?
A. CREATE FUNCTION dept_employees (deptno CHAR(3))
RETURNS TABLE
LANGUAGE SQL
READS SQL DATA
RETURN
SELECT empno, lastname AS l_name, firstnme AS f_name
FROM employee
WHERE employee.workdept = dept_employees.deptno
B. CREATE FUNCTION dept_employees (deptno CHAR(3))
RETURNS TABLE
DYNAMIC RESULT SETS 1
LANGUAGE SQL
READS SQL DATA
DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name
FROM employee
WHERE employee.workdept = dept_employees.deptno
OPEN emp_info;
RETURN
C. CREATE FUNCTION dept_employees (deptno CHAR(3))
RETURNS TABLE (empno CHAR(6),
l_name VARCHAR(15),
f_name VARCHAR(12))
LANGUAGE SQL
READS SQL DATA
RETURN
SELECT empno, lastname AS l_name, firstnme AS f_name
FROM employee
WHERE employee.workdept = dept_employees.deptno
D. CREATE FUNCTION dept_employees (deptno CHAR(3))
RETURNS TABLE (empno CHAR(6),
l_name VARCHAR(15),
f_name VARCHAR(12))
DYNAMIC RESULT SETS 1
LANGUAGE SQL
READS SQL DATA
DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name
FROM employee
WHERE employee.workdept = dept_employees.deptno
OPEN emp_info;
RETURN
Answer: C
Explanation:
QUESTION 2
In the function shown below:

Which statement can be used to invoke the function above?
A. SELECT * FROM TABLE(fcn1('B01'))
B. SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
C. SELECT * FROM fcn1('B01')
D. SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1
Answer: A
Explanation:
In the function shown below:

Which statement can be used to invoke the function above?
A. SELECT * FROM TABLE(fcn1('B01'))
B. SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
C. SELECT * FROM fcn1('B01')
D. SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1
Answer: A
Explanation:
QUESTION 3
Which statement correctly describes characteristics of external functions?
A. External functions cannot return tables.
B. All cursors opened within an external function should stay open until the database is quiesced.
C. Scratchpads can be used to allocate dynamic memory required for multiple function
invocations.
D. Transactions can be terminated within external functions.
Answer: C
Explanation:
Which statement correctly describes characteristics of external functions?
A. External functions cannot return tables.
B. All cursors opened within an external function should stay open until the database is quiesced.
C. Scratchpads can be used to allocate dynamic memory required for multiple function
invocations.
D. Transactions can be terminated within external functions.
Answer: C
Explanation:
QUESTION 4
Which three optional clauses can be used when creating an external function? (Choose three.)
A. SCRATCHPAD
B. NOTEPAD
C. LANGUAGE
D. EXTERNAL NAME
E. DATABASEINFO
Answer: A,C,D
Explanation:
QUESTION 4
Which statement is permitted within a scalar user-defined function body?
A. COMMIT
B. INSERT
C. SIGNAL
D. LOOP
Answer: C
Explanation:
Thursday, June 15, 2017
C2090-430 IBM InfoSphere Master Data Management v11.3 (Physical)
Test information:
Number of questions: 70
Time allowed in minutes: 105
Required passing score: 63%
Languages: English
The IBM Certified Specialist - InfoSphere Master Data Management (MDM) v11.3 (Physical) will certify that the successful candidate has important knowledge and skills necessary to install, configure and deploy MDM on a development workstation along with extending the MDM capabilities using the MDM Workbench. The successful candidate will also understand the architecture components and solution building blocks of Physical MDM.
Design and Architecture (7%)
Describe a Virtual vs Physical vs Hybrid MDM implementation
Describe the Physical MDM technical architecture
Describe the Physical MDM solution building blocks
Data Model (8%)
Describe the Physical MDM business entities and their relationships
Describe common domain entities
Describe administration tables
Install and Configure Physical MDM (4%)
Identify environment setup and configuration
Extending the Physical MDM Capabilities (20%)
Demonstrate knowledge of the Request Response Framework
Demonstrate knowledge of data additions
Demonstrate knowledge of data extensions
Identify how to create code tables
Demonstrate knowledge of behavior extensions
Identify the steps to create a new service
Demonstrate knowledge of composite services
Identify how Physical MDM invokes custom code
External Rules and Validation (5%)
Describe External Rule Framework
Describe external validation and when to use it
Identify how to create and modify an external rule
Data Management (17%)
Describe Suspect Duplicate Processing work flow
Describe Deterministic Matching
Demonstrate knowledge of Probabilistic Matching
Identify components of a Probabilistic Matching Engine algorithm
Describe Physical MDM Standardization
Demonstrate knowledge of search capabilities in Physical MDM
Describe Data Governance
Features and Functionality (10%)
Describe knowledge of management of historical data
Demonstrate knowledge of configurable inquiry levels
Describe Batch Job Processing
Describe the IBM Stewardship Center
Describe Event Manager
Describe language and locale
Describe knowledge of Transaction Audit Information Log
Security (5%)
Describe Physical MDM Authentication and Authorization
Describe Physical MDM security entitlements
Integration (12%)
Describe how to invoke a Physical MDM service
Describe the Adaptive Service Interface
Describe the Notification Framework
Describe the Broadcast Framework
Describe the bulk import and extraction of data
Troubleshooting (12%)
Demonstrate knowledge of configuring and analyzing Physical MDM log files
Demonstrate knowledge of error handling
Describe troubleshooting an installation
Describe Workbench debugging
Describe the Physical MDM support tools
Job Role Description / Target Audience
The IBM Certified Specialist - InfoSphere Master Data Management (MDM) v11.3 (Physical) will certify that the successful candidate has important knowledge and skills necessary to install, configure and deploy MDM on a development workstation along with extending the MDM capabilities using the MDM Workbench. The successful candidate will also understand the architecture components and solution building blocks of Physical MDM.
Recommended Prerequisite Skills
Java EE Architectural design - intermediate
OSGI Framework knowledge - intermediate
WebSphere Application Server - intermediate
Rational Application Developer - intermediate
Database Skills - intermediate
JAVA programming - intermediate
General knowledge of XML - intermediate
General knowledge of JMS, RMI and Webservices - basic
General knowledge of MQ - basic
Number of questions: 70
Time allowed in minutes: 105
Required passing score: 63%
Languages: English
The IBM Certified Specialist - InfoSphere Master Data Management (MDM) v11.3 (Physical) will certify that the successful candidate has important knowledge and skills necessary to install, configure and deploy MDM on a development workstation along with extending the MDM capabilities using the MDM Workbench. The successful candidate will also understand the architecture components and solution building blocks of Physical MDM.
Design and Architecture (7%)
Describe a Virtual vs Physical vs Hybrid MDM implementation
Describe the Physical MDM technical architecture
Describe the Physical MDM solution building blocks
Data Model (8%)
Describe the Physical MDM business entities and their relationships
Describe common domain entities
Describe administration tables
Install and Configure Physical MDM (4%)
Identify environment setup and configuration
Extending the Physical MDM Capabilities (20%)
Demonstrate knowledge of the Request Response Framework
Demonstrate knowledge of data additions
Demonstrate knowledge of data extensions
Identify how to create code tables
Demonstrate knowledge of behavior extensions
Identify the steps to create a new service
Demonstrate knowledge of composite services
Identify how Physical MDM invokes custom code
External Rules and Validation (5%)
Describe External Rule Framework
Describe external validation and when to use it
Identify how to create and modify an external rule
Data Management (17%)
Describe Suspect Duplicate Processing work flow
Describe Deterministic Matching
Demonstrate knowledge of Probabilistic Matching
Identify components of a Probabilistic Matching Engine algorithm
Describe Physical MDM Standardization
Demonstrate knowledge of search capabilities in Physical MDM
Describe Data Governance
Features and Functionality (10%)
Describe knowledge of management of historical data
Demonstrate knowledge of configurable inquiry levels
Describe Batch Job Processing
Describe the IBM Stewardship Center
Describe Event Manager
Describe language and locale
Describe knowledge of Transaction Audit Information Log
Security (5%)
Describe Physical MDM Authentication and Authorization
Describe Physical MDM security entitlements
Integration (12%)
Describe how to invoke a Physical MDM service
Describe the Adaptive Service Interface
Describe the Notification Framework
Describe the Broadcast Framework
Describe the bulk import and extraction of data
Troubleshooting (12%)
Demonstrate knowledge of configuring and analyzing Physical MDM log files
Demonstrate knowledge of error handling
Describe troubleshooting an installation
Describe Workbench debugging
Describe the Physical MDM support tools
Job Role Description / Target Audience
The IBM Certified Specialist - InfoSphere Master Data Management (MDM) v11.3 (Physical) will certify that the successful candidate has important knowledge and skills necessary to install, configure and deploy MDM on a development workstation along with extending the MDM capabilities using the MDM Workbench. The successful candidate will also understand the architecture components and solution building blocks of Physical MDM.
Recommended Prerequisite Skills
Java EE Architectural design - intermediate
OSGI Framework knowledge - intermediate
WebSphere Application Server - intermediate
Rational Application Developer - intermediate
Database Skills - intermediate
JAVA programming - intermediate
General knowledge of XML - intermediate
General knowledge of JMS, RMI and Webservices - basic
General knowledge of MQ - basic
Tuesday, June 13, 2017
C2090-420 IBM InfoSphere MDM Server v9.0
C2090-420: IBM InfoSphere MDM Server v9.0
Test information:
Number of questions: 63
Time allowed in minutes: 90
Required passing score: 67%
Languages: English
Section 1 - Configure and Deploy InfoSphere MDM Server in a Development Workstation (9%)
Given a scenario, describe workstation RAD/RSA development environment setup
Demonstrate knowledge of deploying Custom Code
Demonstrate knowledge of configuring MDM Server features
Section 2 - MDM Server Architecture and Domain Model (12%)
Describe basic MDM Server architecture
Describe MDM Server business entities and their relationships
Section 3 - Extensions and Additions (through Workbench) (12%)
Given a scenario, demonstrate knowledge of differences between a data extension and an addition
Given a scenario, demonstrate knowledge of creating code tables
Demonstrate knowledge of how to create a behavior extension
Section 4 - Composite Transactions (8%)
Describe how to create composite transactions using Business Proxy
Describe the difference between composite XML transactions and Java business proxy composites
Section 5 - External Rules and Validation (9%)
Describe External Business Rules Framework
Describe how to create a new external rule
Describe external validation and when to use it
Section 6 - Search Strategy (5%)
Describe search strategy (high level)
Describe different implementations of seach strategy
Section 7 - Suspect Duplicate Processing (14%)
Describe party SDP work flow
Demonstrate knowledge of implementing customized SDP logic
Deomonstrate knowledge of 'evergreening'
Section 8 - Features and Functionality (16%)
Describe simple/compound history
Describe the MDM Server components
Demonstrate knowledge of configurable inquiry levels
Section 9 - Security (6%)
Describe MDM Server data visibility and accessibility control
Demonstrate knowledge of Authentication versus Authorization
Section 10 - Troubleshooting (9%)
Given a scenario, demonstrate knowledge of configuring and analyzing MDM Server log files
Given a scenario, demonstrate knowledge of Error handling
The IBM Certified Developer - InfoSphere MDM Server v9.0 will certify that the successful candidate has important knowledge and skills necessary to configure and deploy InfoSphere MDM Server v9.0 in a development workstation along with being able to customize the data model and develop custom services through the use of the Infosphere MDM Server v9.0 workbench.
Recommended Prerequisite Skills
Major topics covered by the test include:
Configure and Deploy InfoSphere MDM Server in a Development Workstation
MDM Server Architecture and Domain Model
Extensions and Additions (through Workbench)
Composite Transactions
External Rules and Validation
Search Strategy
Suspect Duplicate Processing
Features and Functionality
Security
Troubleshooting
QUESTION 1
Which two features differ between the probabilistic and deterministic approach to Suspect
Duplication Processing? (Choose two.)
A. candidate list selection
B. matching critical data elements between praties
C. handing A2 suspects
D. determining the match category
Answer: B,D
Explanation:
QUESTION 2
What is a design component of Data Persistency Entitlements?
A. Ancestors
B. Accessors
C. Activities
D. Profiles
Answer: B
Explanation:
QUESTION 3
An external system provides a daily master data feed into InfoSphere MDM Server. New business
proxies are created to synchronize this information with existing data in the MDM database. The
synchronization process involves calling existing InfoSphere MDM Server transactions. What
information does the business proxy use to resolve the identities of business objects and detect
transactions needed in the composite transaction?(Choose two.)
A. business object primary key fields
B. business object foreign key fields
C. business object business key fields
D. business key fields in parent business object hierarchy
Answer: C,D
Explanation:
QUESTION 4
Which two statements are true about the type of history database triggers in InfSphere MDM
Server?(Choose two.)
A. SIMPLE triggers populate the history record in audit tables when a record is inserted into an
operational table in the InfoSphere MDM Server database.
B. COMPOUND triggers populate the history record in audit tables when a record is updated or
deleted from within an operational table in the InfoSphere MDM Server database.
C. SIMPLE triggers populate the history record in audit tables when a record is updated from
within an operational table in the InfoSphere MDM Server database.
D. COMPOUND triggers populate the history record in audit tables when a record is inserted or
updated from within an operational table in the InfSphere MDM Server database.
Answer: C,D
Explanation:
Test information:
Number of questions: 63
Time allowed in minutes: 90
Required passing score: 67%
Languages: English
Section 1 - Configure and Deploy InfoSphere MDM Server in a Development Workstation (9%)
Given a scenario, describe workstation RAD/RSA development environment setup
Demonstrate knowledge of deploying Custom Code
Demonstrate knowledge of configuring MDM Server features
Section 2 - MDM Server Architecture and Domain Model (12%)
Describe basic MDM Server architecture
Describe MDM Server business entities and their relationships
Section 3 - Extensions and Additions (through Workbench) (12%)
Given a scenario, demonstrate knowledge of differences between a data extension and an addition
Given a scenario, demonstrate knowledge of creating code tables
Demonstrate knowledge of how to create a behavior extension
Section 4 - Composite Transactions (8%)
Describe how to create composite transactions using Business Proxy
Describe the difference between composite XML transactions and Java business proxy composites
Section 5 - External Rules and Validation (9%)
Describe External Business Rules Framework
Describe how to create a new external rule
Describe external validation and when to use it
Section 6 - Search Strategy (5%)
Describe search strategy (high level)
Describe different implementations of seach strategy
Section 7 - Suspect Duplicate Processing (14%)
Describe party SDP work flow
Demonstrate knowledge of implementing customized SDP logic
Deomonstrate knowledge of 'evergreening'
Section 8 - Features and Functionality (16%)
Describe simple/compound history
Describe the MDM Server components
Demonstrate knowledge of configurable inquiry levels
Section 9 - Security (6%)
Describe MDM Server data visibility and accessibility control
Demonstrate knowledge of Authentication versus Authorization
Section 10 - Troubleshooting (9%)
Given a scenario, demonstrate knowledge of configuring and analyzing MDM Server log files
Given a scenario, demonstrate knowledge of Error handling
The IBM Certified Developer - InfoSphere MDM Server v9.0 will certify that the successful candidate has important knowledge and skills necessary to configure and deploy InfoSphere MDM Server v9.0 in a development workstation along with being able to customize the data model and develop custom services through the use of the Infosphere MDM Server v9.0 workbench.
Recommended Prerequisite Skills
Major topics covered by the test include:
Configure and Deploy InfoSphere MDM Server in a Development Workstation
MDM Server Architecture and Domain Model
Extensions and Additions (through Workbench)
Composite Transactions
External Rules and Validation
Search Strategy
Suspect Duplicate Processing
Features and Functionality
Security
Troubleshooting
QUESTION 1
Which two features differ between the probabilistic and deterministic approach to Suspect
Duplication Processing? (Choose two.)
A. candidate list selection
B. matching critical data elements between praties
C. handing A2 suspects
D. determining the match category
Answer: B,D
Explanation:
QUESTION 2
What is a design component of Data Persistency Entitlements?
A. Ancestors
B. Accessors
C. Activities
D. Profiles
Answer: B
Explanation:
QUESTION 3
An external system provides a daily master data feed into InfoSphere MDM Server. New business
proxies are created to synchronize this information with existing data in the MDM database. The
synchronization process involves calling existing InfoSphere MDM Server transactions. What
information does the business proxy use to resolve the identities of business objects and detect
transactions needed in the composite transaction?(Choose two.)
A. business object primary key fields
B. business object foreign key fields
C. business object business key fields
D. business key fields in parent business object hierarchy
Answer: C,D
Explanation:
QUESTION 4
Which two statements are true about the type of history database triggers in InfSphere MDM
Server?(Choose two.)
A. SIMPLE triggers populate the history record in audit tables when a record is inserted into an
operational table in the InfoSphere MDM Server database.
B. COMPOUND triggers populate the history record in audit tables when a record is updated or
deleted from within an operational table in the InfoSphere MDM Server database.
C. SIMPLE triggers populate the history record in audit tables when a record is updated from
within an operational table in the InfoSphere MDM Server database.
D. COMPOUND triggers populate the history record in audit tables when a record is inserted or
updated from within an operational table in the InfSphere MDM Server database.
Answer: C,D
Explanation:
Tuesday, May 23, 2017
C2090-304 IBM InfoSphere QualityStage v9.1 Solution Developer
Test information:
Number of questions: 63
Time allowed in minutes: 90
Required passing score: 71%
Languages: English, Japanese
This exam will certify that the successful candidate has important knowledge and skills necessary to professionally design and develop a QualityStage v9.1 solution to produce efficient and accurate results.
Section 1 - Methodology (5%)
Describe the steps in data quality methodology
Understand the impact of data integration preparsing
Section 2 - Design Considerations (13%)
Identify the steps for standardization
Demonstrate knowledge how to optimize QualityStage jobs using parallel concepts
Demonstrate knowledge how to handle data from multiple countries
Describe initial vs. delta vs. real-time design considerations
Section 3 - Investigation (8%)
Demonstrate knowledge of investigation types
Describe how investigation results can be used
Section 4 - Standardization / Adresses / Postal (14%)
Describe the differences between certification, vertification and standardization
Define what the standardization stages are and how to use them
Describe the purpose of standardization and what results are produced by the process
Section 5 - Rule Sets (16%)
Demonstrate knowledge of how to customize standardization rules
Demonstrate knowledge of the components of a rule and their functions
Demonstrate knowledge of managing standardizations rules
Demonstrate knowledge of user defined standardization rules
Section 6 - Matching (21%)
Demonstrate knowledge of match concepts
Describe the match job components
Describe how to review and tune a match
Demonstrate knowledge of managing match specification (re-usability)
Demonstrate knowledge of match job design to achieve optimal performance
Section 7 - Survive (10%)
Describe the purpose of the survive stage
Demonstrate knowledge of the different rule types for surviving data and when to use them
Describe how to implement a survive stage
Section 8 - Setup and Troubleshooting (14%)
Identify how to troubleshoot a QualityStage job
Describe how to configure data quiality environment functionality
Describe QualityStage deployment considerations
Demonstrate knowledge of NLS/non-NLS install and its impact on QualityStage stages
Explain the process necessary to run multiple copies of the job (job multi-instance)
IBM Certified Solution Developer - InfoSphere QualityStage v9.1
Job Role Description / Target Audience
The IBM Certified Solution Developer - InfoSphere QualityStage v9.1 is a data quality developer, analyst and architect and has important knowledge and skills necessary to professionally design and develop a QualityStage v9.1 solution to produce efficient and accurate results.
Recommended Prerequisite Skills
Must understand overall QualityStage functionality:
Possess detailed knowledge of QualityStage stages to develop an effective application
Postal Applications and Address Verification Interface (AVI)
Real-time design of QualityStage
Integration into InfoSphere DataStage solutions
Job design using the DataStage and QualityStage Designer interface
Assess the appropriateness and quality of data for data integration initiative
Ensures QualityStage solution meets business requirements
Monitors resolution of data quality issues
Provides metadata to create functional and technical specifications for data integration/cleansing applications
Design auditing processes to meet data integrity needs
Design data quality processes through a QualityStage application
Determine the appropriate tool to fulfill data quality and business requirements
QUESTION 1Number of questions: 63
Time allowed in minutes: 90
Required passing score: 71%
Languages: English, Japanese
This exam will certify that the successful candidate has important knowledge and skills necessary to professionally design and develop a QualityStage v9.1 solution to produce efficient and accurate results.
Section 1 - Methodology (5%)
Describe the steps in data quality methodology
Understand the impact of data integration preparsing
Section 2 - Design Considerations (13%)
Identify the steps for standardization
Demonstrate knowledge how to optimize QualityStage jobs using parallel concepts
Demonstrate knowledge how to handle data from multiple countries
Describe initial vs. delta vs. real-time design considerations
Section 3 - Investigation (8%)
Demonstrate knowledge of investigation types
Describe how investigation results can be used
Section 4 - Standardization / Adresses / Postal (14%)
Describe the differences between certification, vertification and standardization
Define what the standardization stages are and how to use them
Describe the purpose of standardization and what results are produced by the process
Section 5 - Rule Sets (16%)
Demonstrate knowledge of how to customize standardization rules
Demonstrate knowledge of the components of a rule and their functions
Demonstrate knowledge of managing standardizations rules
Demonstrate knowledge of user defined standardization rules
Section 6 - Matching (21%)
Demonstrate knowledge of match concepts
Describe the match job components
Describe how to review and tune a match
Demonstrate knowledge of managing match specification (re-usability)
Demonstrate knowledge of match job design to achieve optimal performance
Section 7 - Survive (10%)
Describe the purpose of the survive stage
Demonstrate knowledge of the different rule types for surviving data and when to use them
Describe how to implement a survive stage
Section 8 - Setup and Troubleshooting (14%)
Identify how to troubleshoot a QualityStage job
Describe how to configure data quiality environment functionality
Describe QualityStage deployment considerations
Demonstrate knowledge of NLS/non-NLS install and its impact on QualityStage stages
Explain the process necessary to run multiple copies of the job (job multi-instance)
IBM Certified Solution Developer - InfoSphere QualityStage v9.1
Job Role Description / Target Audience
The IBM Certified Solution Developer - InfoSphere QualityStage v9.1 is a data quality developer, analyst and architect and has important knowledge and skills necessary to professionally design and develop a QualityStage v9.1 solution to produce efficient and accurate results.
Recommended Prerequisite Skills
Must understand overall QualityStage functionality:
Possess detailed knowledge of QualityStage stages to develop an effective application
Postal Applications and Address Verification Interface (AVI)
Real-time design of QualityStage
Integration into InfoSphere DataStage solutions
Job design using the DataStage and QualityStage Designer interface
Assess the appropriateness and quality of data for data integration initiative
Ensures QualityStage solution meets business requirements
Monitors resolution of data quality issues
Provides metadata to create functional and technical specifications for data integration/cleansing applications
Design auditing processes to meet data integrity needs
Design data quality processes through a QualityStage application
Determine the appropriate tool to fulfill data quality and business requirements
How does QualityStage output the correct ISO code for a record?
A. ISO code functionality is not available.
B. ISO code supplied by the Country rule set.
C. ISO code supplied by the USPREP rule set.
D. ISO code supplied by the US Address rule set.
Answer: C
Explanation: The ISOterritorycode is appended to the domain preprocessor abbreviation (PREP).
QUESTION 2
You need to create a batch delta match process for transaction records against a very large
master file of existing clients.
Which QualityStage match option should be used?
A. Transitive One-source match
B. Two-source many-to-one match
C. Deterministic One-source match
D. Two-source many-to-many match
Answer: A
Explanation: Transitive One-source matchcan extend further than one-source-dependent
because it uses all the pairs that score above the match cutoff. It's recommended if you want to
account forinconsistentdata entryin fields that assist in duplicate identification.
QUESTION 3
How can Word Investigation reports be used to modify a rule set?
A. Corrects spelling errors in the data field.
B. Adds tokens to allow identification of additional duplicates.
C. Identifies new tokens to allow additional words to be classified.
D. Identifies matched words to be used in match designer frequency distribution.
Answer: A
Explanation:
QUESTION 4
Which statement about the jobs used by the Match Specification Setup Wizard is true?
A. The jobs must be created.
B. The jobs must be imported.
C. The jobs exist for only One-source individual match.
D. The jobs are created in the repository at installation time.
Answer: A
Explanation:
QUESTION 5
When would you use the survive technique 'Most Frequent'?
A. When more than one target field is required.
B. When the most frequent occurrence is required.
C. When the most frequently populated value is required.
D. When the most frequently populated value is required with two or more occurrences.
Answer: D
Explanation:
Wednesday, May 10, 2017
C2070-994 IBM Datacap V9.0 Solution Designer
Test information:
Number of questions: 66
Time allowed in minutes: 120
Required passing score: 65%
Languages: English
The test contains five sections, totaling 65ti multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Datacap Architecture (17%)
Demonstrate understanding of Datacap architecture
Explain general architecture
Explain capacity planning and load balancing configuration
Demonstrate an understanding of distributed environments
Demonstrate an understanding of mobile architecture
Demonstrate an understanding of High Availability and Scaling
Demonstrate an understanding of High Availability and Scaling
Identify minimum installation requirements
Demonstrate knowledge of Datacap databases
Demonstrate knowledge of Datacap application offerings
Demonstrate understanding of wTM
Section 2 - Analyze Business Requirements (19%)
Determine what information to gather from images
Identify ingestion sources
Determine business validation rules
Determine workflow steps
Demonstrate understanding of export requirements
Determine security requirements
Determine reporting requirements
Section 3 - Design a Datacap Taskmaster Solution (26%)
Demonstrate knowledge of creating Datacap document hierarchy
Analyze job and task design
Demonstrate knowledge of ingestion
Demonstrate knowledge of document conversions
Demonstrate knowledge of page identification
Demonstrate general page id knowledge
Demonstrate knowledge of Fingerprinting
Demonstrate knowledge of recognition methodology
Demonstrate knowledge of validation techniques
Demonstrate knowledge of export approaches
Demonstrate knowledge of FastDoc
Demonstrate knowledge of RuleRunner
Demonstrate knowledge of critical Datacap folder/file configuration
Section 4 - Develop Application and Solution Components (29%)
Identify uses of Maintenance Manager
Demonstrate understanding of Report Viewer
Demonstrate understanding of RuleRunner
Demonstrate knowledge of using FastDoc admin
Demonstrate understanding of Datacap Studio
Demonstrate understanding of Studio AppWizard
Demonstrate knowledge of how to develop Task Profiles
Demonstrate knowledge of how to develop rulesets, rules, and functions
Demonstrate knowledge of applying rules to Datacap Document Hierarchy (DCO)
Demonstrate understanding of web administration
Section 5 - Solution Testing and Deployment (9%)
Demonstrate knowledge of performing solution testing
Demonstrate knowledge on how to use Datacap Studio to test
Explain steps required to move solution between deployment targets
Demonstrate ability to enable logging for all the components
Demonstrated knowledge of troubleshooting techniques
IBM Certified Solution Designer - Datacap V9.0
Job Role Description / Target Audience
This intermediate level certification test certifies that the successful candidate has the knowledge to create the theoretical and/or detailed technical design of an application, solution, and infrastructure using IBM Datacap V9.0. Provide expertise to evaluate and choose between alternatives; assist with balancing costs with capabilities and priorities. Identify products / technologies / processes to be included, and determine points of required integration and customization. Identify sizing and capacity issues, as well as conflicts with existing processes or environments.
Recommended Prerequisite Skills
Before preparing for this certification, basic understanding of the following is recommended and assumed:
- Knowledge of IBM Datacap components: FastDoc, Datacap Web Server, Report Viewer, Desktop, Dstudio, RuleRunner, Maintenance Manager, Datacap Navigator and Dashboard
- IBM Content Navigator
- Knowledge of WebSphere Application Server
- Cloud technologies
- Ability to write actions for IBM Datacap: VBScript, C#, XML
- Knowledge of Microsoft IIS
- Knowledge of Out-of-the-Box component interfaces
- Knowledge of content acquisition: import, fax, email and scan
- Knowledge of document and image conversion
- Knowledge of document hierarchy
- Knowledge of document and page identification
- Knowledge of recognition
- Knowledge of routing: branching, jumping and splitting
- Knowledge of verification and validation
- Knowledge of export and repositories
- Knowledge of databases
- Authentication and Authorization
Number of questions: 66
Time allowed in minutes: 120
Required passing score: 65%
Languages: English
The test contains five sections, totaling 65ti multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Datacap Architecture (17%)
Demonstrate understanding of Datacap architecture
Explain general architecture
Explain capacity planning and load balancing configuration
Demonstrate an understanding of distributed environments
Demonstrate an understanding of mobile architecture
Demonstrate an understanding of High Availability and Scaling
Demonstrate an understanding of High Availability and Scaling
Identify minimum installation requirements
Demonstrate knowledge of Datacap databases
Demonstrate knowledge of Datacap application offerings
Demonstrate understanding of wTM
Section 2 - Analyze Business Requirements (19%)
Determine what information to gather from images
Identify ingestion sources
Determine business validation rules
Determine workflow steps
Demonstrate understanding of export requirements
Determine security requirements
Determine reporting requirements
Section 3 - Design a Datacap Taskmaster Solution (26%)
Demonstrate knowledge of creating Datacap document hierarchy
Analyze job and task design
Demonstrate knowledge of ingestion
Demonstrate knowledge of document conversions
Demonstrate knowledge of page identification
Demonstrate general page id knowledge
Demonstrate knowledge of Fingerprinting
Demonstrate knowledge of recognition methodology
Demonstrate knowledge of validation techniques
Demonstrate knowledge of export approaches
Demonstrate knowledge of FastDoc
Demonstrate knowledge of RuleRunner
Demonstrate knowledge of critical Datacap folder/file configuration
Section 4 - Develop Application and Solution Components (29%)
Identify uses of Maintenance Manager
Demonstrate understanding of Report Viewer
Demonstrate understanding of RuleRunner
Demonstrate knowledge of using FastDoc admin
Demonstrate understanding of Datacap Studio
Demonstrate understanding of Studio AppWizard
Demonstrate knowledge of how to develop Task Profiles
Demonstrate knowledge of how to develop rulesets, rules, and functions
Demonstrate knowledge of applying rules to Datacap Document Hierarchy (DCO)
Demonstrate understanding of web administration
Section 5 - Solution Testing and Deployment (9%)
Demonstrate knowledge of performing solution testing
Demonstrate knowledge on how to use Datacap Studio to test
Explain steps required to move solution between deployment targets
Demonstrate ability to enable logging for all the components
Demonstrated knowledge of troubleshooting techniques
IBM Certified Solution Designer - Datacap V9.0
Job Role Description / Target Audience
This intermediate level certification test certifies that the successful candidate has the knowledge to create the theoretical and/or detailed technical design of an application, solution, and infrastructure using IBM Datacap V9.0. Provide expertise to evaluate and choose between alternatives; assist with balancing costs with capabilities and priorities. Identify products / technologies / processes to be included, and determine points of required integration and customization. Identify sizing and capacity issues, as well as conflicts with existing processes or environments.
Recommended Prerequisite Skills
Before preparing for this certification, basic understanding of the following is recommended and assumed:
- Knowledge of IBM Datacap components: FastDoc, Datacap Web Server, Report Viewer, Desktop, Dstudio, RuleRunner, Maintenance Manager, Datacap Navigator and Dashboard
- IBM Content Navigator
- Knowledge of WebSphere Application Server
- Cloud technologies
- Ability to write actions for IBM Datacap: VBScript, C#, XML
- Knowledge of Microsoft IIS
- Knowledge of Out-of-the-Box component interfaces
- Knowledge of content acquisition: import, fax, email and scan
- Knowledge of document and image conversion
- Knowledge of document hierarchy
- Knowledge of document and page identification
- Knowledge of recognition
- Knowledge of routing: branching, jumping and splitting
- Knowledge of verification and validation
- Knowledge of export and repositories
- Knowledge of databases
- Authentication and Authorization
Monday, May 8, 2017
C2070-993 IBM Case Manager V5.2.1 Solution Designer
Test information:
Number of questions: 62
Time allowed in minutes: 120
Required passing score: 57%
Languages: English
The test contains five sections, totaling 62 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Planning and Architecture (18%)
Demonstrate an understanding of IBM Case Manager Architecture
Identify solutions best addressed by Case Manager
Identify key differences between development and production environments
Identify integrated products and add-on software capabilities including licensing
Section 2 - Designing a Case Solution (30%)
Demonstrate an understanding of the Case Manager object model
Demonstrate an understanding of Case Builder and its Artifacts
Demonstrate an understanding of external documents
Demonstrate an understanding of Case Task and Process Fragments
Demonstrate an understanding of the Page Designer
Demonstrate an understanding of IBM Content Navigator integration
Demonstrate an understanding of the security model
Demonstrate the use of the Case Operations Component
Section 3 - Deploying, Testing and Troubleshooting a Case Solution (15%)
Demonstrate an understanding of the deployment structure and its limitations
Demonstrate knowledge of project areas
Demonstrate the use of the Case Manager Administration Client
Demonstrate knowledge of solution deployment troubleshooting
Demonstrate knowledge of solution comparison
Section 4 - Extending a Case Management Solution (16%)
Demonstrate knowledge of integrating custom widgets and business rules
Identify IBM capabilities to extend Case Manager
Demonstrate an understanding of building a custom application using REST service and JavaScript APIs
Demonstrate an understanding of mobile integration
Section 5 - Solution Migration (13%)
Demonstrate an understanding of Case Manager Configuration Manager, Case Manager Administration Client and FileNet Deployment Manager
Demonstrate an understanding of the requirements and steps to migrate a solution
Demonstrate an understanding of configuring security in a production environment
Section 6 - Business Metrics and Analytics (8%)
Demonstrate knowledge of using Case Analyzer
Demonstrate knowledge of using Case Monitor and Cognos RTM
Demonstrate knowledge of using Watson Content Analytics with Enterprise Search
IBM Certified Solution Designer - Case Manager V5.2.1
Job Role Description / Target Audience
This intermediate level certification test certifies that the successful candidate has the knowledge to create the theoretical and/or detailed technical design of an application, solution, and infrastructure using IBM Case Manager v5.2.1 (ICM). Provide expertise to evaluate and choose between alternatives; assist with balancing costs with capabilities and priorities. Identify products / technologies / processes to be included, and determine points of required integration and customization. Identify sizing and capacity issues, as well as conflicts with existing processes or environments.
Recommended Prerequisite Skills
Before preparing for this certification, basic understanding of the following is recommended and assumed for your environment:
- Knowledge of IBM Case Manager
- Knowledge of IBM FileNet Content Platform Engine
- Knowledge of supported Application Servers
- Knowledge of Content Navigator
- Knowledge of Cognos RealTime Monitoring
- Knowledge of Watson Content Analytics
- Knowledge of Box integration
- Knowledge of VCS integration
Number of questions: 62
Time allowed in minutes: 120
Required passing score: 57%
Languages: English
The test contains five sections, totaling 62 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Planning and Architecture (18%)
Demonstrate an understanding of IBM Case Manager Architecture
Identify solutions best addressed by Case Manager
Identify key differences between development and production environments
Identify integrated products and add-on software capabilities including licensing
Section 2 - Designing a Case Solution (30%)
Demonstrate an understanding of the Case Manager object model
Demonstrate an understanding of Case Builder and its Artifacts
Demonstrate an understanding of external documents
Demonstrate an understanding of Case Task and Process Fragments
Demonstrate an understanding of the Page Designer
Demonstrate an understanding of IBM Content Navigator integration
Demonstrate an understanding of the security model
Demonstrate the use of the Case Operations Component
Section 3 - Deploying, Testing and Troubleshooting a Case Solution (15%)
Demonstrate an understanding of the deployment structure and its limitations
Demonstrate knowledge of project areas
Demonstrate the use of the Case Manager Administration Client
Demonstrate knowledge of solution deployment troubleshooting
Demonstrate knowledge of solution comparison
Section 4 - Extending a Case Management Solution (16%)
Demonstrate knowledge of integrating custom widgets and business rules
Identify IBM capabilities to extend Case Manager
Demonstrate an understanding of building a custom application using REST service and JavaScript APIs
Demonstrate an understanding of mobile integration
Section 5 - Solution Migration (13%)
Demonstrate an understanding of Case Manager Configuration Manager, Case Manager Administration Client and FileNet Deployment Manager
Demonstrate an understanding of the requirements and steps to migrate a solution
Demonstrate an understanding of configuring security in a production environment
Section 6 - Business Metrics and Analytics (8%)
Demonstrate knowledge of using Case Analyzer
Demonstrate knowledge of using Case Monitor and Cognos RTM
Demonstrate knowledge of using Watson Content Analytics with Enterprise Search
IBM Certified Solution Designer - Case Manager V5.2.1
Job Role Description / Target Audience
This intermediate level certification test certifies that the successful candidate has the knowledge to create the theoretical and/or detailed technical design of an application, solution, and infrastructure using IBM Case Manager v5.2.1 (ICM). Provide expertise to evaluate and choose between alternatives; assist with balancing costs with capabilities and priorities. Identify products / technologies / processes to be included, and determine points of required integration and customization. Identify sizing and capacity issues, as well as conflicts with existing processes or environments.
Recommended Prerequisite Skills
Before preparing for this certification, basic understanding of the following is recommended and assumed for your environment:
- Knowledge of IBM Case Manager
- Knowledge of IBM FileNet Content Platform Engine
- Knowledge of supported Application Servers
- Knowledge of Content Navigator
- Knowledge of Cognos RealTime Monitoring
- Knowledge of Watson Content Analytics
- Knowledge of Box integration
- Knowledge of VCS integration
Subscribe to:
Posts (Atom)
