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.
Tuesday, December 19, 2017
C9510-801 IBM PureApplication System V2.0 System Administration
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
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
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
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)
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 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
Subscribe to:
Posts (Atom)
