C9020-668 IBM Storage Technical V1

Number of questions: 60
Number of questions to pass: 33
Time allowed: 90 mins
Status: Live

This exam consists of 4 sections described below.

Application of Resources and Tools 20%
Given a scenario, evaluate which tool(s) to use based upon key applications, performance requirements, customer pain points, capacity / growth requirements, and the impact on total cost.
Describe uses of IBM maintenance, IBM websites, IBM tools, and IBM processes.
Given a scenario, identify high-level steps to integrate new solutions into an existing systems environment.

Customer Environment, Requirements, and Plans 32%
Describe a customer's hardware and software environment.
Describe customer operational constraints, including power, cooling, personnel, knowledge level, service level requirements.
Identify disaster recovery and high availability requirements.
Identify customer performance requirements, including throughput and latency.
Identify the customer's capacity and growth requirements and the impact on total cost.

Hybrid Cloud and Analytics Concepts 13%
Describe ways the IBM storage portfolio enables hybrid, public, and private clouds.
Describe ways the IBM storage portfolio enables analytics.
Describe ways the IBM storage portfolio provides security.

Product Information 35%
Given a scenario, describe the difference between various storage media and align them to a requirement of TCA, performance, and upgradability.
Given a scenario, explain the difference in cost, performance, and reliability of IBM storage solutions.
Given a scenario, describe IBM's competitive advantages.
Given a scenario, describe how IBM enterprise storage products help clients solve data and device management issues through application efficiency and integration.
Given a scenario, explain alternatives to the existing environment to provide additional functionality.

This exam has an Assessment Exam option: A9020-668 Assessment: IBM Storage Technical V1

Assessment exams are web-based exams that provides you, at a cheaper costs, the ability to check your skills before taking the certification exam.

This assessment exam is available in: English
Passing the exam does not award you a certification, and it is only used to help you assess if you are ready or not to take the certification exam.

You can register for it at Pearson VUE and it will provide you a score report, showing you how you did in each section.

All IBM certification tests presume a certain amount of "on-the-job" experience which is not present in any classroom or Web presentation. The recommended courses and links will help you gain the skill and product knowledge represented in the test objectives. They do not teach the answers to the test questions, and are not intended to do so. This information may not cover all subject areas in the certification test, or may contain more recent information than is present in the certification test. Taking these or any classes will not guarantee that you will achieve certification

IBM Storage Technical V1 certification preparation education can be found at the sites below.
IBM employees: IBM Systems Academy
Business Partners: IBM PartnerWorld University

---

QUESTION 1
Which solution meets a customer’s requirements for 100,000 IOPS, lowest latency, and maximum TB of raw capacity for an Oracle database?

A. IBM FlashSystem A9000
B. IBM Storwize V7000F
C. IBM FlashSystem V9000
D. IBM FlashSystem 900

Answer: D

Explanation:
IBM FlashSystem 900 is designed to accelerate the applications that drive business – like those using an Oracle Database.
IBM FlashSystem 900 can scale usable capacity from as low as 2 TB to as much as 57 TB in a single system.
FlashSystem 900 delivers Tier 0 top application performance with up to 1.1 million 100% random read IOPS and 600,000 100% random write IOPS.

---

QUESTION 2
Which non-concurrent capacity upgrade is possible for a customer with an IBM FlashSystem 900?

A. Systems purchased with eight 2.9 TB flash modules can be expanded to twelve 2.9 TB flash modules.
B. Systems purchased with eight 5.7 TB flash modules can be expanded to twelve 2.9 TB flash modules.
C. Systems purchased with eight 1.2 TB flash modules can be expanded to twelve 2.9 TB flash modules.
D. Systems purchased with eight 1.2 TB flash modules can be expanded to twelve 5.7 TB flash modules.

Answer: A

Explanation:
FlashSystem 900 can be populated with up to 12 x 1.2 TB IBM MicroLatency modules in increments , 6, 8, 10, or 12; or up to 12 x 2.9 TB or 5.7 TB IBM MicroLatency modules
in increments , 8, 10, or 12.
These modules of either 1.2 TB, 2.9 TB, or 5.7 TB cannot be intermixed. Capacity can be upgraded by purchasing the AF23 (1.2 TB), AF24 (2.9 TB)) or AF25 (5.7 TB) IBM MicroLatency module feature codes as MES upgrades. Here are the upgrade paths:

References:http://www.redbooks.ibm.com/technotes/tips1261.pdf

---

QUESTION 3
A customer is interested in purchasing an IBM TS7650G ProtecTIER Gateway for its production site and one for replication at its DR site. The DR site is a target only site.
How is the cost of the solution affected by the replication?

A. ProtecTIER replication is included with base license.
B. ProtecTIER replication is included with hardware and no license is required.
C. ProtecTIER replication licensing is required at both sites.
D. ProtecTIER replication licensing is required at the primary site only.

Answer: C

Explanation:
You must have a license for the replication feature for each ProtecTIER server in the replication grid.

References:https://www.ibm.com/support/knowledgecenter/en/STVRB7_3.2.0/ts7650ipg_r eplication.html

---

QUESTION 4
A customer has an older IBM storage subsystem and wants to know where to find the Service Discontinued data for the product.
What should the technical specialist tell the customer?

A. Check IBM Digital Techline Center.
B. Check IBM SSIC webpage.
C. Check the IBM sales manual.
D. Check the IBM Knowledge Center.

Answer: D

Explanation:
When service is discontinued, corrections to known problems remain available, but the development team is redirected to other work, and no new, tested corrections will be generated for general use. Known problems may be reviewed and ordered via electronic vehicles such as the internet (e.g., http://www.ibm.com/support) however support provided by the IBM Client Support representatives, will be discontinued.

References:https://www-304.ibm.com/support/customercare/sas/f/handbook/offerings.html

Click here to view complete Q&A of C9020-668 exam
Certkingdom Review, Certkingdom PDF Torrents

Best IBM C9020-668 Certification, IBM C9020-668 Training at certkingdom.com

JN0-647 Enterprise Routing and Switching Exam

JN0-647 Enterprise Routing and Switching Exam

This list provides a general view of the skill set required to successfully complete the specified certification exam. Topics listed are subject to change.

Interior Gateway Protocols (IGPs)
BGP
IP Multicast
Ethernet Switching and Spanning Tree
Layer 2 Authentication and Access Control
IP Telephony Features
Class of Service (CoS)

Interior Gateway Protocols (IGPs)

Describe the concepts, operation or functionality of IGPs
IS-IS
RIP
OSPFv2 and OSPFv3
Routing Policy
Given a scenario, demonstrate knowledge of how to configure, troubleshoot, or monitor IGPs

BGP

Describe the concepts, operation or functionality of BGP
BGP route selection process
Next hop resolution
BGP attributes - concept and operation
BGP communities
Regular expressions
Load balancing - multipath, multihop, forwarding table
NLRI families -- inet, inet6
Advanced BGP options
Given a scenario, demonstrate knowledge of how to configure, troubleshoot, or monitor BGP
Implement BGP routing policy

IP Multicast

Describe the concepts, operation or functionality of IP multicast
Components of IP multicast, including multicast addressing
IP multicast traffic flow
Any-Source Multicast (ASM) vs. Source-Specific Multicast (SSM)
RPF - concept and operation
IGMP, IGMP snooping
PIM dense-mode and sparse-mode
Rendezvous point (RP) - concept, operation, discovery, election
SSM - requirements, benefits, address ranges
Anycast RP
MSDP
Routing policy and scoping
Given a scenario, demonstrate knowledge of how to configure, troubleshoot, or monitor IP multicast
IGMP, PIM-DM, or PIM-SM (including SSM)
Implement IP multicast routing policy

Ethernet Switching and Spanning Tree

Describe the concepts, operation or functionality of advanced Ethernet switching
Filter-based VLANs
Private VLANs
Dynamic VLAN registration using MVRP
Tunnel Layer 2 traffic through Ethernet networks
Junos Fusion Enterprise
Layer 2 tunneling using Q-in-Q and L2PT
Given a scenario, demonstrate knowledge of how to configure, troubleshoot, or monitor advanced Ethernet switching
Filter-based VLANs
Private VLANs
Dynamic VLAN registration using MVRP
Tunnel Layer 2 traffic through Ethernet networks
Junos Fusion Enterprise
Layer 2 tunneling using Q-in-Q and L2PT
Describe the concepts, operation or functionality of advanced spanning tree protocols, including MSTP or VSTP
Given a scenario, demonstrate knowledge of how to configure, troubleshoot, or monitor MSTP or VSTP

Layer 2 Authentication and Access Control

Describe the operation of various Layer 2 authentication or access control features
Authentication process flow
802.1x - concepts and functionality
MAC RADIUS
Captive portal
Server fail fallback
Guest VLAN
Considerations when using multiple authentication/access control methods
Given a scenario, demonstrate how to configure, troubleshoot, or monitor Layer 2 authentication or access control

IP Telephony Features

Describe the concepts, operation or functionality of features that facilitate IP telephony deployments
Power over Ethernet (PoE)
LLDP and LLDP-MED
Voice VLAN
Given a scenario, demonstrate how to configure, troubleshoot, or monitor features used to support IP telephony deployments

Class of Service (CoS)

Describe the concepts, operation or functionality of Junos CoS for Layer 2/3 networks
CoS processing on Junos devices
CoS header fields
Forwarding classes
Classification
Packet loss priority
Policers
Schedulers
Drop profiles
Shaping
Rewrite rules
Given a scenario, demonstrate knowledge of how to configure, troubleshoot, or monitor CoS for Layer 2/3 networks

---

QUESTION 1
You are configuring a scheduler map on an EX9200 Series device. You want to ensure that traffic is dropped in a policing action once traffic exceeds the configured transit rate.
Which configuration parameter will meet this requirement?

A. exact
B. rate-limit
C. remainder
D. percent

Answer: B

---

QUESTION 2
Which two statements are true about PIM source-specific multicast (SSM)? (Choose two.)

A. The receiver DR builds a source-base tree to the RP.
B. S, G is always used.
C. A Different group address must be used by each source.
D. IGMPv3 is required.

Answer: B,D

---

QUESTION 3
Which statement is correct about CoS policers on Junos devices?

A. Traffic that exceeds a policer’s traffic profile can be dropped or assigned to aspecific drop profile.
B. A policer can assign in-profile traffic to a specific forwarding class.
C. A policer does not alter in-profile traffic.
D. Policers can be configured to buffer traffic that exceeds the policer’s traffic profile.

Answer: C

---

QUESTION 4
Which statement is correct about MSTP?

A. MSTP enables mapping multiple independent spanning-tree instances onto one physical topology.
B. MSTP enables dynamic discovery of Layer 2 neighbors.
C. MSTP dynamically manages VLAN registration in a LAN.
D. MSTP uses stacked VLAN tags to extend a Layer 2 Ethernet connection between multiple sites.

Answer: A

---

QUESTION 5
Which type of BGP is used to peer with a different autonomous system?

A. external
B. classless
C. dynamic
D. static

Answer: A

Click here to view complete Q&A of JN0-647 exam
Certkingdom Review, Certkingdom PDF Torrents

Best HP JN0-647 Certification, Juniper JN0-647 Training at certkingdom.com

C8060-217 IBM Sterling B2B Integrator V5.2.6 Solution Implementation

Number of questions: 67
Number of questions to pass: 40
Time allowed: 120 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 five sections totalling 67 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Architecture, Design and Installation 15%
Configure the database
Install IBM Sterling B2B Integrator and associated components
Understand IBM Sterling B2B Advanced Communications architecture
Describe the installation and configuration of external CLA2
Explain the configuration and deployment of perimeter servers
Explain the deployment of Adapter Container(s)
Design and deploy a cluster environment
Configure cluster for disaster recovery

Section 2 - Configuration of Services and Adapters 14%
Define adapters and services for a specific deployment
Configure Server Adapters
Create multiple service configurations of a specific service
Implement Adapter suites
Configure a client adapter to connect to an external server
Configure adapter to use a perimeter server
Demonstrate how communication servers interact with mailboxes

Section 3 - Implementation and Deployment 34%
Understand the relationship of Service configurations and business processes
Understand version control within IBM Sterling B2B Integrator
Create and edit business processes
Use of XPath within business processes
Identify services and adapters required for a given use case
Configure out-of-the-box business processes
Manage communications protocols
Understand communications protocols for IBM Sterling B2B Advanced Communications
Manage EDI standards
Use Scheduler
Understand Service Groups
Use core mailboxing
Understand Global Mailbox
Use mapping and translation

Section 4 - Administration 21%
Configure system maintenance
Use the System Troubleshooter functionality
Analyze Performance Tuning
Deploy upgrades and apply patches
Configure Property files
Use bin Directory Files
Configure visibility of data
Use resource management to move assets between environments

Section 5 - Security 16%
Manage digital certificates and keys
Configure encryption and signing
Configure a user with associated permissions
Understand Hardware Security Module (HSM) integration
Define and configure user authentication
Integrate with and configure proxy servers
Configure common industry standard levels of security
Configure certification validation at runtime
Secure the user interfaces to ensure compliance
Encrypt system passwords

PartnerWorld Code: 15003702
Replaces PW Code: 15003701

Status: Live
This intermediate level certification is intended for solution implementers who are responsible for installing, business process developing, configuring, deploying and troubleshooting IBM Sterling B2B Integrator V5.2.x. Specifically, this exam covers content up to IBM Sterling B2B Integrator V5.2.6. Solution implementers should be able to independently perform IBM Sterling B2B Integrator V5.2.6 project assignments.

A solution implementer who passes this exam is able to:
install IBM Sterling B2B Integrator and its components (e.g. perimeter servers, CLA2 adapter)
use Graphical Process Modeler (GPM) and Business Process Modeling Language (BPML) to develop and implement business processes
develop and implement common integration business processes to meet business needs using best practices
provide visibility, status and tracking of business transactions with trading partners
develop and implement service and adapter configurations
be familiar with the EDI standards, and understand trading partner configuration and related pre-defined processes and services
implement EDI translation
apply common troubleshooting techniques
configure performance tuning parameters
onboard trading partners
apply high availability best practices
implement the project by configuring the appropriate security configurations to meet the project security requirements
configure maintenance activities (e.g. housekeeping jobs, patching, upgrades)
configure the reporting utility

Recommended Prerequisite Skills

Before preparing for this certification, understanding of the following is recommended and assumed:
Conceptual understanding of operating systems and related supporting technology
Conceptual understanding of a JVM
Basic understanding of databases and SQL
Basic understanding of networking, protocols, security, and demilitralized zone (DMZ)
Understanding of B2B industry standards (e.g. X12, EDIFACT, etc.)
Understanding of basic XML concepts and languages (e.g. XSD, etc.)
Understand the related cluster installation, load balancer, firewall, high availability and performance setting options

In preparing for this certification, the following IBM courses are recommended to further improve your skills associated with the exam topics. Refer to the Test Preparation web page for additional information and recommendations.

6F87G: IBM Sterling B2B Integrator Fundamentals
6F88G: IBM Sterling B2B Integrator Data Mapping and EDI Processing (X12) v5.2.6.1
6F89G: IBM Sterling B2B Integrator Administration and Tuning v5.2.6.1
6F100G: IBM Sterling B2B Integrator Advanced Business Process Modeling

Click here to view complete Q&A of C8060-217 exam
Certkingdom Review, Certkingdom PDF Torrents

Best IBM C8060-217 Certification, IBM C8060-217 Training at certkingdom.com

C7010-010 IBM Cúram V6.0.4 Application Development

Number of questions: 50
Number of questions to pass: 35
Time allowed: 75 mins

The contents of this exam is applicable for IBM Cúram V6.0.4 and later V6 versions.
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 five sections totalling 50 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections. The contents of this exam is applicable to IBM Cúram V6.0.4 and later V6 versions.

Section 1 - IBM Cúram Infrastructure 10%
Identify the components of IBM Cúram Social Program Management
Outline the runtime architecture used in IBM Cúram for the client and server applications
Access product documentation that is provided with the IBM Cúram application
Select the appropriate build target for a particular task
Other - file types

Section 2 - Server Development 30%
Use RSA fragments, RSA packages, and the CODE_PACKAGE option
Model the following classes: Domain Definition, Entity, Struct, Process, and Facade
Interpret the class hierarchy that is generated from modeled classes
Model the following relationships: Index, Foreign Key, Assignable, Aggregation
Define appropriate stereotype operations for entity, process and facade classes
Specify options for exit points, auditing and optimistic locking
Define code tables, data manager files, and message files
Implement exception handling
Specify modeled and mandatory field validations
Implement server validation and post-processing messages using the Informational Manager
Perform server-side testing and tracing
Generate unique IDs

Section 3 - Client Development 20%
Identify features for localization and externalizing strings
Select the necessary build targets for client development
Employ common UIM elements: PAGE, CLUSTER, FIELD, CONNECT, LINK, PAGE_PARAMETER, SOURCE, TARGET, SERVER_INTERFACE, ACTION_SET, ACTION_CONTROL
Implement a simple search feature
Implement a modify feature
Identify the parts of the IBM Cúram user interface
Configure application navigation features
Implement the following client features: multiple submit, select lists, display images, views, wizards and in-page navigation, and expandable lists
Invoke the UIM Generator to create pages
Add logic to your UIM pages using JSP scriptlets and JavaScript
Use features to perform client-side validation
Identify out-of-the-box domain specific controls or widgets and the use of the Custom Widget Development Framework (CWDF)
Perform client tracing

Section 4 - Server Customization 30%
Identify the features for deprecation reporting
Access and interpret documentation to determine the compliant customization approach
Specify the build precedence using the component order variables
Customize non-source code artifacts compliantly: message files, code tables, data manager files, server configuration files
Configure validations using the Administration Suite
Customize source code artifacts compliantly: Structs, Façade and Process classes, Entity classes, Domain Definitions
Distinguish between service layer classes developed using the persistence infrastructure and those developed using the classic development approach
Customize service layer implementations using the Event/Listener pattern, Strategy pattern, and references to services layer classes

Section 5 - Client Customization 10%
Customize client artifacts compliantly, including UIM pages, property files, application navigation, images, and style sheets
Determine the purpose of the key client configuration files and how they can customized
Implement a plug-in for custom data conversion and sorting
Identify the options for customizing widgets

Overview
PartnerWorld Code: 58000501
Replaces PW Code: 58000501

Status: Live
This intermediate level certification is intended for Java developers who will work as Cúram developers for V6.0.4 and V6.0.5.
Recommended Prerequisite Skills

Before preparing for this certification, working knowledge of the following is recommended and assumed:
object-oriented concepts
Java
XML
SQL
n-tier enterprise applications

In preparing for this certification, the following IBM courses are highly recommended:

9D32G (or 9D44G): Fundamentals of the IBM Cúram SPM Platform for Developers V6.0.4 (or V6.0.5)

OR

9D40G (or 9D49G): Fundamentals of the IBM Cúram SPM Platform for Developers (ADE) V6.0.4 (SPVC) (or V6.0.5)
AND
9D41G (or 9D50G): Fundamentals of the IBM Cúram SPM Platform for Developers (Customization) V6.0.4 (SPVC) (or V6.0.5)

You may also consider taking one of the following courses to practice using IBM Cúram features:

9D46G (or 9D53G): IBM Cúram SPM Platform Development Environment 6.0.4 - Expert Arena (SPVC) (6.0.5)

---

QUESTION 1
Which of the following entity method stereotypes require SQL to be provided?

A. nsread
B. ns
C. nsmulti
D. batch
E. nsmodify

Answer: B,C

---

QUESTION 2
The default control for CODETABLE values in a Cúram page is a drop-down menu. The default control for CODETABLE values in a Cúram page is a drop-down menu. How can this be replaced with a set of radio buttons?

A. Ensure that the underlying Domain Definition on the model resolves to SHORT_CODETABLE_CODE.
B. Set the SHORT attribute on the FIELD to true.
C. Set the Radio Button option on the Domain Definition to true.
D. Set the Radio Button option on the corresponding struct to true.

Answer: A

---

QUESTION 3
Which of the following are valid subdirectories of a server component directory?

A. model
B. codetable
C. database
D. EJBserver
E. message

Answer: A,B,E

---

QUESTION 4
Which of the following are stored in the datamanager_config.xml file?

A. Database table names used by the application
B. Database type and port numbers
C. References to DMX files containing data to be inserted on a build
D. References to SQL scripts to be run on a build
E. References to CTX files containing code tables to be inserted on a build

Answer: C,D

---

QUESTION 5
An application's Server Components folder contains the following components: Appeals, core, custom, ISScreening, and ServicePlanning. The SERVER_COMPONENT_ORDER variable is set as follows: SERVER_COMPONENT_ORDER=custom, ServicePlanning.
Which of the following statements BEST reflects the order of priority (decreasing priority left to right) in which the generators will process the components?

A. custom, ServicePlanning, core
B. custom, ServicePlanning
C. custom, ServicePlanning, Appeals, core, ISScreening
D. custom, ServicePlanning, Appeals, ISScreening, core
E. Appeals, custom, ISScreening, ServicePlanning, core

Answer: D

Click here to view complete Q&A of C7010-010 exam
Certkingdom Review, Certkingdom PDF Torrents

Best IBM C7010-010 Certification, IBM C7010-010 Training at certkingdom.com

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 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:

---

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:

---

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:
 

---

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:

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

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

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

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

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

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:

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

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

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 1
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:

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

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