Tuesday, December 19, 2017

C9510-801 IBM PureApplication System V2.0 System Administration

Number of questions: 58
Number of questions to pass: 36
Time allowed: 120 mins
Status: Live

The test consists of eight sections containing a total of approximately 57 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Cloud Configuration and Management 12%
Compare and contrast the purpose of IP groups, cloud groups, and environment profiles, and explain their relationships.
Identify resource sharing requirements and design an environment profile configuration to allocate cloud resources based on the requirements.
Create and configure IP groups, cloud groups and environment profiles.
Configure cloud groups for high availability.
Architect and deploy shared services.

Section 2 - Access Control Management 16%
Configure the system to use an LDAP repository for authentication.
Identify asset management requirements and design an authorization scheme based on the requirements.
Manage access to system and workload resources with users and groups.
Identify pattern deployment requirements and configure environment profiles to authorize pattern deployment.
Configure a local user account and its policies.
Configure the system to use customer supplied certificates.

Section 3 - Network Administration and Configuration 9%
Demonstrate an understanding of basic system network configuration concepts.
Demonstrate an understanding of the types of network subnets, namely system management, application data, and cloud group management.
Demonstrate an understanding of the system's DNS requirements.
Identify network isolation requirements, then design and configure the system's VLANs and Links based on the requirements.

Section 4 - Storage Administration 12%
Create and manage storage volumes and storage volume groups.
Allocate and attach storage to workload virtual machines (VMs).
Compare and contrast the advantages of block storage for separating the lifecycle of storage and the application.
Define storage replication profiles and storage volume pairs.
Configure the system to use external storage.
Configure a GPFS file system across multiple systems.

Section 5 - System Monitoring 14%
Using built-in tools, monitor health and performance of system resources and workloads to identify potential problems.
Anticipate user problems based on system status.
Configure and deploy monitoring shared services.
Configure PureApplication System monitoring to send system events to an enterprise event monitor.
Configure Service and Support Manager.
Administer PMRs for Call Home events.
Using reports, analyze system usage for capacity planning and chargeback.

Section 6 - Problem Determination 16%
Determine component failure using the Infrastructure Map.
Analyze events and problems, and identify actions required.
Analyze the job queue.
Run system diagnostics.
Gather collecion sets for IBM Software Support.
Open a Problem Management Record (PMR) or Service Request (SR).
Schedule on-site service.
Configure IBM service representative account access.
Apply a system update.

Section 7 - Multisystem Environment Configuration 12%
Identify and define multisystem requirements and strategies.
Explain the relationship between management domains, deployment subdomains, and locations.
Configure management domains and deployment subdomains.
Configure externally managed cloud resources (environment profile, cloud groups, and IP groups).
Deploy a shared service using externally managed cloud resources (environment profile, cloud groups, and IP groups).

Section 8 - Business Continuity 10%
Configure backup and restore for the system and components.
Explain the system's high availability capabilities, including hardware redundancy and workload failover.
Architect a disaster recovery strategy between two systems.
Identify file sharing and replication requirements and design a solution to configure GPFS file systems and filesets.

The sample test is designed to give the candidate an idea of the content and format of the questions that will be on the certification exam. Performance on the sample test is NOT an indicator of performance on the certification exam. This should not be considered an assessment tool.

To prepare for this test, it is first recommended that you are familiar with the job role description and the parameters this certification is based on, as well as have knowledge of the topics outlined in the test objectives/skills measured on the test. Compare your own technical level to the test objectives and the recommended training resources, and then determine for yourself how much preparation you require. Note that these educational sources are recommended, but not required (*) before taking a certification test.

Before preparing for the certification test, it is recommended that you measure your current level of skill by taking the Sample Test (located from the "Sample/Assessment test" link above)..

You can prepare for the test through the Self-Study Approach. Sources within this approach collectively cover the skills measured on the test.

The recommended educational resources listed are not intended to be a substitute for, but should complement, relevant practical experience.
Extensive product knowledge is required to pass the test.

Every effort has been made to make the recommended educational resources as complete and as accurate as possible, but no warranty of fitness is implied. The resources provided are on an as is basis. IBM shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from course or publication content..

Web Resource

Configuring event forwarding

Administering support for GPFS

Monitoring Agent for IBM PureApplication System

Administering users, user groups, and security

Administering block storage replication

Monitoring virtual application instances

Contacting IBM PureApplication System and PureApplication Service Technical Support

Administering storage volume groups

Importing console SSL certificates and keys

Administering hardware resources

IBM PureApplication System backup and restore, Part 2: System backup

A tour of the hardware in IBM PureApplication System

Adoption Scenarios for IBM PureApplication System - Chaper 4.5.23:Deploy GPFS for disaster recovery

Installing maintenance and updates

High availability overview

Deploying an external System Monitoring shared service

Troubleshooting and Support

Events and error messages

Monitoring the middleware

Deploying virtual system patterns

Configuring network settings

Demonstrating workload isolation in IBM PureApplication System

Working with shared services

Managing administrative access in IBM PureApplication System

Expanding storage volume size

IBM Service Request Help

Configuring the system to use external storage devices

Integrating with LDAP servers

Understanding security roles for IBM PureApplication System 8283

Organizing your problem information when reporting PureApplication System problems

Creating environment profiles

Deploying shared services in a multisystem environment

Running system diagnostics

Viewing cloud group reports

Configuring Service and Support Manager

Configuring an Active/Active GPFS deployment

Adding system connections

Understanding user account policies

Administering IP groups

Administering the system

Managing application runtime environments in IBM PureApplication System

Administering cloud resources

Obtaining a collection set of troubleshooting information for IBM Software Support

Managing backup and restore

Administering cloud groups

Enabling ibmeng access for the IBM service representative

System Monitoring shared service

Administering the job queue

Overview
PartnerWorld Code: 59000102
Replaces PW Code: 59000101

Status: Live
This intermediate level certification targets system administrators who configure, operate, secure, monitor, and maintain IBM PureApplication System V2.0.

These system administrators perform initial set-up and day-to-day administration of the system. This includes:

Cloud configuration and management
Access control management
Network administration and configuration
Storage administration
System monitoring
Problem Determination
Multisystem environment configuration
Business continuity

These system administrators are expected to be generally self-sufficient and be able to perform the tasks involved in the role with limited assistance from peers, product documentation, or vendor support services.

To attain the IBM Certified System Administrator - PureApplication System V2.0 certification, candidates must pass 1 test. To prepare for the test, it is recommended to refer to the job role description and recommended prerequisite skills, and click the link to the test below to refer to the test objectives and the Test preparation tab.
Recommended Prerequisite Skills

Knowledge and foundational skills one needs to possess before acquiring skills measured on the certification test. These foundational skills are NOT measured on the test. For skills measured on the test, see Test Objectives.)

Knowledge of:
cloud computing principles including infrastructure as a service (IaaS) and platform as a service (PaaS).
system monitoring.
networking and storage concepts.
the IBM Support procedures.
authentication and authorization
high availability and disaster recovery

Requirements
This certification requires 1 exam

Exam Required:
C9510-801 - IBM PureApplication System V2.0 System Administration

Each 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.

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.






Saturday, November 18, 2017

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


Monday, November 6, 2017

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

Thursday, October 26, 2017

C8010-475 IBM Tealeaf Customer Experience Management V9.0 Implementation

Number of questions: 57
Number of questions to pass: 35
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 seven sections totalling 57 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 14%
Understand factors for sizing
Understand network requirements
Understand the modules and their requirements and capabilities
Express Tealeaf module data requirements required for implementation
Express data and integration requirements for Tealeaf CX Mobile
Describe how data from the Tealeaf logging framework is returned and interpreted within the Tealeaf system

Section 2 - PCA Installation and Configuration 14%
Understand how the PCA works
Perform RPM installation
Understand the basics of administering Linux
Set up the link between the CX and the PCA environments
Understand the requirements for SSL decryption
Understand Tealeaf sessionization
Configure the interface for capturing traffic

Section 3 - CX Installation and Configuration 22%
Understand the basics of administering Windows and SQL
Identify the key requirements for CX installation (Window OS, SQL, .NET, etc.)
Validate network requirements
Configure different Tealeaf Servers (Portal, Report, Processing, Replay, Search, etc.)
Configure different CX server services (Alert service, Data collector canister manager, transport service, etc.)
Use TMS to configure Tealeaf CX
Configure Session Agents

Section 4 - Privacy and Filtering 9%
Identify where and how sensitive data can be filtered in the Tealeaf system
Identify the components of a privacy rule
Configure privacy rules to meet filtering requirements
Test privacy and security configurations

Section 5 - Replay 11%
Set up the initial Replay configuration
Describe concepts related to replay of Rich Internet Application (RIA)
Differentiate between RTV and BBR
Configure Replay rules

Section 6 - Administration and Maintenance 11%
Analyze and apply requirements for high availability and failover
Understand PCA maintenance
Understand CX maintenance
Illustrate Tealeaf optimization concepts for traffic and search optimization
Understand Tealeaf backup

Section 7 - Data Validation and Troubleshooting 19%
Understand Data Validation Methodology and validate quality of data
Determine how to validate data in a given scenario
Use the logs in the application for implementation validation
Identify issues caused by misconfigured sessionization
Understand when and why to adjust logging levels for different components and how it can be done
Identify causes of spooling and how to make changes as required to affect the spool
Identify storage requirements and issues, and understand potential causes/remedies
Understand the Tealeaf status report and how to configure it
Understand Tealeaf processes related to troubleshooting

PartnerWorld Code: 33000701
Replaces PW Code: Not Applicable

Status: Live
This intermediate level certification is intended for implementers, solution architects, implementation engineers and implementation consultants for IBM Tealeaf Customer Experience Management V9.0. This professional is responsible for architecting, implementing or deploying, and configuring the solution. This examination will also cover the general factors influencing sizing, admin maintenance, Replay configuration, privacy, and system optimization.
This professional should have at least one (1) year of experience working with IBM Tealeaf Customer Experience Management, preferably in the implementation role and should have executed at least one implementation.
This professional is also expected to have working knowledge of skillset covered in C2080-474, IBM Tealeaf Customer Experience Management V8.7, Business Analysis. Exam C2080-474 is recommended before taking this exam.
Recommended Prerequisite Skills

Before preparing for this certification, understanding of the following is recommended and assumed:
good understanding of Tealeaf use cases, objectives and requirements
intermediate knowledge of web applications (including for example: JavaScript, HTML, PHP, Ajax, jQuery, JSON, Dojo)
intermediate knowledge of networking, routers, load balancing, HTTP/S protocol, firewalls
intermediate knowledge of Linux, Windows, and SQL administration


Thursday, October 19, 2017

C7010-013 IBM Cúram V6.0.5 Business Analysis and Design

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)





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





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