Saturday, December 2, 2017

Exam 98-380 Introduction to Programming Using Block-Based Languages (Touch Develop)

Published: January 27, 2017
Languages: English
Audiences: Academics
Technology: Programming
Credit toward certification: MTA

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Apply Strategies to Solve Computational Problems (15-20%)
Identify basic algorithmic steps to solve simple problems
Decompose simple problems into steps, sequence processes in the appropriate order, describe storyboards, resolve challenges and errors related to logic or pseudocode
Decompose a computational problem into sub-problems
Describe computer programs that use logical subdivisions, describe solutions that use programmable strategies such as objects, functions, and parameters in the pseudo code provided, identify situations when code can be reviewed

Design Algorithms (25-30%)
Create Algorithms
Differentiate problems as easy or hard for computers to solve, apply the concept of iteration, create simple algorithms
Analyze game play to identify the algorithmic sequences
Analyze a game and create a sequence of instructions for playing it, identify an event, create the code for an event in block-based editors, explain the “on every frame” code and event handlers
Create and analyze algorithms used to implement animation and movement in code
Describe animation that uses a series of individual frames, resolve errors in algorithms, create algorithms that can be translated into pseudocode or block-based code, use code to command items on the screen or device
Explain sequence, selection, and iteration
Define loops, identify the control variable, predict the output of loop, random number, and control variable constructs, identify conditional statements; choose the appropriate Boolean logic for specific results

Work with Data Representation in Block-Based Programming Languages (15-20%)
Represent data in text, sounds, pictures, and numbers
Create code to add and position objects, such as sprites on a screen or device, identify data examples as text, sound, pictures, or numbers, change the parameters of “set frame grid” to work with different sprite sheets, explain the role of cloud variables, explain the impact of variable scope, including cloud variables, global variables, and local or temporary variables, design, create, and populate a table or two-dimensional array, describe multiple uses for data
Employ simple data structures to solve computational problems
Declare and use variables in a program, use input and variables to calculate new information, describe arrays, lists, and collections, explain the differences between variables and arrays
Describe how data is accessed in apps and games
Distinguish among variable data types, add, remove, and insert elements in a collection, iterate through collections using for loops and for-each loops, describe how random numbers are used

Solve Computational Problems by Using Modeling and Simulation (5-10%)
Solve computational problems by using computer and non-computer methods
Use algorithms and Boolean logic, use games and apps to simulate practical tasks such as converting currencies
Represent events observed in the physical world by coding simulation and modeling programs
Create programs and apps that mimic random occurrences, create programs and apps that demonstrate fundamentals of physics such as gravity, acceleration, and bounce

Code Programs in Block-Based Programming (15-20%)
Implement solutions using code
Identify the basic coding elements of the programming environment, create code for conditional statements, create conditional statements using AND, OR, and NOT, create loops, use counting variables
Use libraries and built-in functions to facilitate programming solutions
Code by using ready-made functions related to objects including the game board, wall, obstacle, sprite, string, textbox, collection, and turtle
Make connections between elements of mathematics and computer science
Plot points on a gaming coordinate system, analyze a game to discover how random numbers are used, use the random range function to generate random numbers, evaluate random numbers by using conditionals

Assess Personal Security in Internet Communications (5-10%)
Explain the basic components of Internet communication
Explain how information travels across the Internet, define cloud computing, describe the Internet of Things, describe the roles of cloud computing and cloud storage and their uses
Explain the principles of security
Describe how personal information can be used in inappropriate ways, describe how to prevent someone from gaining access to an online account, describe steps that websites take to keep passwords secure, describe the Caesar Cipher
Implement encryption and authentication strategies
Encode and decode messages using Unicode, evaluate passwords based on security criteria, describe how hashed passwords enhance Internet security

Examine the Software Development Process (5-10%)
Plan and create programs
Analyze problems in relation to your audience and identify which apps or games can be part of the solution and how they can be used, describe user-experience principles, gather user input, use code or text to create instructions for using a program
Describe software development processes used to solve problems
Plan project tasks and delegate responsibilities, describe a cycle of create, evaluate, and revise
Analyze and evaluate completed programs
Evaluate for readability and usability, give and receive feedback, evaluate feedback and revise the program accordingly

QUESTION 1
This question requires that you evaluate the underlined text to determine if it is correct.
You are writing an app for Best For You Organics Company.
The app needs to allow the user to convert a recipe from cups to liters. The app will use the conversion ratio of 1 cup is equal to 0.2366 liters.
You define the pseudocode as follows:
INPUT cups
liters = cups * 0.2366
OUTPUT liters
Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

A. No change is needed.
B. cups * 2.366
C. cups / 0.2366
D. cups / .02366 * 10

Answer: A


QUESTION 2
You are creating a calculator app. The Power function must calculate the result of raising a number by a positive exponent value.
You create the following pseudocode:
Function Power(number, exponent)
DECLARE result
End Function
You need to complete the pseudocode for the function.
Which pseudocode should you use?

A. WHILE exponent > 1 SET result TO result * number SET exponent TO exponent – 1LOOPReturn result
B. IF exponent > 1 SET result TO result * number SET exponent TO exponent – 1END IFReturn result
C. IF exponent > 1 SET result TO result * number SET exponent TO exponent + 1END IFReturn result
D. WHILE exponent > 1 SET result TO result * number SET exponent TO exponent + 1LOOPReturn result

Answer: C

QUESTION 3
You are creating an app that will allow university students to connect with advisors and other students to discuss stressful situations. Only students who attend the university can access the app.
Which two steps should you take to protect student’s identity and personal information? (Choose two.)

A. Hash student data transmissions with a random salt.
B. Hash the password with a random salt.
C. Encrypt student data transmissions.
D. Hash the password using an algorithm in the Google database.
E. Encrypt the password.

Answer: C

QUESTION 4
Humberto wants to create a Touch Develop game that he can play with his friends competing for the highest score. Because Humberto’s friends live out of state, he needs to create a game that can be played on different devices with each player’s score being saved and compared to the other friend’s scores. He needs help determining the right type of variable to store the highest player’s score for use in his game.
You need to give Humberto advice on the correct type of variable he needs to create for his game.
Which variable type should you recommend?

A. Table
B. Global
C. Local
D. Cloud

Answer: B

Explanation:
References: http://bjc.berkeley.edu/bjc-r/cur/programming/variables/global-variables.html


Saturday, November 11, 2017

C9010-260 IBM Power Systems with POWER8 Sales Skills V2

Number of questions: 62
Number of questions to pass: 41
Time allowed: 120 mins
Status: Live

This exam consists of 4 sections described below.

Competition 15%
Differentiate Power Systems servers against the competition, including Oracle, HP, Dell, and Cisco.
Differentiate Power Systems servers against x86 Linux competition.
Differentiate IBM virtualization solutions, such as PowerVM and PowerKVM, against competitive virtualization solutions, including VMware, Hyper-V, KVM and XenServer.
Recognize opportunities in situations where IBM has partnered with the competition (e.g. Oracle on Power).
Identify appropriate tools and resources (e.g. IBM COMP, Executive Briefing Center, Eagle Study) to use in competitive situations.
Discuss the benefits of porting existing applications / databases to POWER8.
Differentiate Cloud AWS (Amazon Web Services), Microsoft Azure, and Oracle Cloud from Power-based cloud solutions.

General Product Knowledge 27%
Describe the IBM Power Systems Scale-out and Linux models, including capabilities and/or limitations.
Recognize the targeted market opportunity for the Power Systems with NVIDIA technology.
Describe the IBM Power Systems Enterprise model servers, including capabilities and/or limitations.
Describe Power Systems peripherals (e.g. HMC/Virtual HMC, I/O expansion drawers, UPS, racks, tape and/or off-line storage), and when these are recommended or required.
Given a scenario, determine which disk storage is appropriate (traditional internal disk, internal SSD, flash, or external storage).
Given a scenario, determine which operating system is appropriate (AIX, IBM i, or Linux).
Describe Power Systems Software products and their intended function, including PowerHA, PowerVM, PowerSC, PowerVC, PowerVP, PowerKVM, etc.
Describe Power Systems architecture, technologies, and operating systems capabilities which support reliability, availability and/or serviceability (RAS).
Describe the energy management capabilities of Power Systems.
Describe available I/O adapters at a high level (e.g. SAS, Flash, Fibre Channel, Infiniband, Ethernet), including those built into the system, and how they apply to current solutions.
Describe key IBM products which support cloud, analytics, mobile, security, and social workload requirements.
Describe the unique advantages that CAPI functionality brings to Power Systems solutions.
Describe customer benefits that can be provided by the OpenPOWER Foundation.
Describe customer benefits and competitive advantages that are provided by solutions aligned with the open source community.

High Level Solution Design 29%
Given a set of customer requirements, determine which Power Systems server (e.g., Enterprise vs. Scale-out), operating system, applicable I/O, and systems software supports those needs.
When a client's requirements can be met by either Scale-out or Enterprise systems, articulate the pros and cons of each approach.
Identify pricing advantages or disadvantages of running different operating systems on Power Systems (e.g., implications of IFLs, PVUs, CBUs, etc.).
Identify cost justification elements unique to a customer's requirements (e.g., staffing, financial, software, networking, etc.).
Based on customers' business needs, determine appropriate cloud, analytics, mobile, security, or social solutions.
Based on customer requirements, identify unique Power Systems features that satisfy business needs (e.g., reduced number of cores, FPGAs, CAPI, flash, CoD, RAS, etc.).
Determine pre-sales and pre-install Technical Delivery Assessment (TDA) requirements for enterprise systems.
Identify key elements of a POWER8 proposal that would be included in an Executive Summary.
Overcome design obstacles such as physical space, electrical requirements, training, migration issues, and time-line constraints.
Explain the purpose and uses of Hardware and Software Maintenance (HW/SWMA) at a high level.
Identify the business and processing requirements of a new or existing client, relative to Power Systems solutions.
Overcome objections which would prevent a successful sale, such as budgetary constraints, technological options (high level), conflicting customer strategies, etc.
Engage appropriate resources such as ATS, Techline, eConfig, PartnerWorld, Lab Services, Executive Briefing Center, COMP, etc.

Value Proposition 29%
Describe how Power Systems technologies contribute to lower overall TCO and can improve ROI, including demonstrating an understanding of resources available to determine TCO.
Describe how Power Systems offerings contribute to competitive TCA.
Identify business benefits of Power Systems that solve typical customer pain points (performance, energy consumption, server sprawl, RAS, and budget).
Explain the versatility of Power Systems servers (e.g., virtualization, partition/application mobility, resource utilization, etc.).
Compare the value proposition of Power Systems solutions against / to competitive x86 solutions.
Discuss the benefits of an optimized solution stack (hardware, OS, middleware).
Describe the Power Systems roadmap and how it demonstrates IBM's commitment to customer investment protection.
Describe the key benefits of Power Systems for strategic solutions, such as cloud, analytics, mobile, security, and social.
Identify ISV and IBM middleware (e.g., WebSphere, Rational, Tivoli, Redis, SAP HANA, DB2) solutions that run on Power Systems.
Describe the value that CAPI (Coherent Accelerator Processer Interface) brings to the POWER8 architecture (e.g., differentiate the use cases, recognize the value) and where it is likely to be used.
Identify the IBM cloud solutions on Power Systems (e.g., Cloud Orchestrator, IBM Power Systems Solution Edition for Scale-out Cloud, etc.).
Identify the IBM analytics solutions on Power Systems (e.g., DB2 BLU on Power, IBM Data Engine for Hadoop and Spark - Power Systems Edition, IBM Data Engine for Analytics - Power Systems Edition, IBM Data Engine for NoSQL - Power Systems Edition,Spectrum Scale (GPFS), Cognos, InfoSphere Streams, etc.).
Identify the IBM mobile solutions on Power Systems, e.g., IBM MobileFirst Platform Foundation (formerly IBM WorkLight).
Articulate the infrastructure advantages provided by Power Systems (e.g., virtualization, availability, performance, environmental, tools and standards, security, application availability, scalability, Capacity on Demand).

This exam has an Assessment Exam option: A9010-260 Assessment: IBM Power Systems with POWER8 Sales Skills V2

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: Korean, Japanese, 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, Web presentation or reference material. The recommended course and reference materials will help you gain the skill and product knowledge outlined in the test objectives. They do not teach the answers to the test questions, and are not intended to. 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. Reviewing/studying the course and reference materials will not guarantee that you will achieve certification.

IBM POWER8 certification preparation education can be found at the sites below:
IBMers: IBM Systems Academy
Business Partners or Clients: IBM PartnerWorld University
PartnerWorld Code: 03005910
Replaces PW Code: 03005909

Status: Live
The following guidelines reflect the minimum experience and skills one should possess to achieve the credential of IBM Certified Sales Specialist - Power Systems with POWER8 V2:

Recommended Experience:
Candidates must have experience in IBM Power Systems sales and / or sales support roles. The successful candidate structures solutions for customers based on their business requirements, has detailed product knowledge of the Power Systems portfolio (Scale-out and Enterprise systems), and has 12-18 months of experience assessing customer needs.

The Certified Sales Specialist utilizes sales tools and resources in order to manage customer relationships and develop solution proposals.
Recommended Prerequisite Skills

Successful candidates will demonstrate the following specific skills when proposing solutions to customers, regardless of whether AIX, Linux, or IBM i is the primary operating environment:
Detailed knowledge of the Power Systems family of POWER8 servers.
An ability to articulate the unique capabilities and benefits of the Power Systems architecture.
An ability to work with Power Systems, storage, software, and services experts in order to develop a customer focused IBM solution based on the customer's business needs and constraints.
An understanding of the unique characteristics that AIX, Linux, and IBM i operating systems provide and require on Power Systems.
An understanding of the benefits that can be achieved with IBM Power Systems software products such as PowerVM, PowerVC, PowerHA, PowerSC, PowerVP, etc.
An understanding of IBM product and services offerings for big data, analytics, cloud, mobile, social, and security solutions on POWER8 servers.
An ability to successfully position Power Systems products against competitive products and solutions, such as those from Oracle, HP, Cisco, x86 server vendors, and competitive storage vendors.
An awareness of tools and resources available to complete a proposal.
The ability to identify the elements of a complete and successful proposal.
An ability to effectively manage customer relationships, such as responding to objections and understanding the role of the Technical Server Specialist in the sales process.

QUESTION: No: 1
A customer plans to implement a web-based solution that requires 34 Power cores. They want to acquire
a POWER8 solution with the best TCA .
Assuming all other configuration requirements are equal, which solution provides the best TCA?

A. Two S824s
B. One E870
C. One S822
D. Three S814S

Answer: A


QUESTION: No: 2
What elements of POWER8 technology can be explogted by software developers to optimize performance
on an E870?

A. First Failure Data Capture (FFDC) and Senrice processor
B. Hypervisor and Thermal Power Management Device (TPMD)
C. Transactional memory and SMT
D. Active Memory Expansion and storage keys

Answer: C


QUESTION: No: 3
Which of the following is required to run IBM Cloud PowerVC Manager?

A. AIX
B. VIOS
C. Linux
D. IBM i

Answer: D


QUESTION: No: 4
A customer needs to update their Linux applications and is comparing Power to x86 solutions.
What benefit can be highlighted to demonstrate the value that POWER8 offers compared to x86
solutions?

A. POWER8 offers faster processor speeds.
B. POWER8 offers more sockets and cores per server.
C. PowerVM is more secure than VIVIware.
D. POWER8 offers four times the number of threads per core than x86.

Answer: C


QUESTION: No: 5
Which of the following RAS features is available on POVVER8 Scale-out

A. Redundant System Clocks
B. Dynamic Processor Deallocation
C. Capacity on Demand
D. Redundant System Processors

Answer: A

Monday, October 9, 2017

1Z0-964 Oracle Project Portfolio Management Cloud 2017 Implementation Essentials

Associated Certification Paths
Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.

Oracle Project Portfolio Management Cloud 2017 Certified Implementation Specialist

Exam Details
Duration: 120
Number of Questions: 76
Passing Score: 60%
Exam has been validated against Oracle Fusion Project Portfolio Management Cloud Service R12.
Format: Multiple Choice

Fusion Project Portfolio Management overview
Describe the components of Oracle Cloud Project Portfolio Management
Explain the components available for integration

Navigation, User Experience, and Personalization
Describe the business processes that are supported by approvals and workflows
Set up approval and notification tasks

Oracle Fusion Applications Security Overview
Describe the Fusion Applications Security Console
Identify the roles delivered in a seeded security implementation
Manage roles and duties

Fusion Functional Setup Manager
Describe the Fusion Functional Setup Manager
Manage an implementation project
Describe the Rapid Implementation Workbook

Configure Fusion Common Applications
Explain Organizational Structures in Fusion Project Performance Management
Set up Enterprise Structures Units
Manage Reference Data sharing

Common project configuration
Explain common project configuration in Fusion Project Performance Management
Manage Subledger Accounting

Configure Fusion Project Foundation
Set up Project Calendars and Periods
Set up Types and Categorizations
Set up Project Roles
Manage Project Resources
Describe Rate Schedules
Describe Project Types
Explain Action Controls (Microsoft Project Integration)
Set up Transaction Sources
Manage Project Statuses

Configure Fusion Project Costing
Configure Fusion Project Cost Collection Center
Manage Burdening Schedules
Manage Allocations
Explain capitalized interest calculations
Describe Budgetary Controls
Configure Time & Labor for projects
Configure Fusion Integration Options
Describe Fusion Integration Methods

Configure Fusion Project Control
Configure the Resource Breakdown Structure
Setup Plan Types
Set up Project Budgets and Forecasts
Describe Project templates
Describe Financial Plans vs Project Plans

Configure Fusion Project Billing
Configure the Project Contract Model
Set up Revenue Recognition
Set up Project Invoicing
Configure Project Cross Charging and Transfer Pricing
Describe Borrowed and Lent vs Intercompany / Interproject Billing

Configure Project Performance Reporting
Configure Key Performance Indicators for project performance reporting

Configure Project Management
Describe common project execution components
Set up Project and Task codes
Set up Issue and Deliverable types
Describe project requirements
Set up Project Enterprise Structures
Configure Social Network for Project Execution

Configure Project Resource Management
Configure Project Labor Enterprise Resources
Set up Resource Pools
Set up Talent Profile Content

Fusion Project Reporting
Configure Infolets for PPM
Describe Oracle Transactional Business Intelligence (OTBI)



Wednesday, August 16, 2017

300-170 DCVAI Implementing Cisco Data Center Virtualization and Automation

Exam Number 300-170 DCVAI
Associated Certifications CCNP Data Center
Duration 90 minutes (60-70 questions)
Available Languages English

This exam tests a candidate's knowledge of implementing data center infrastructure including virtualization, automation, Cisco Application Centric Infrastructure (ACI), ACI network resources, and, ACI management and monitoring.

Exam Description
The Implementing Cisco Data Center Virtualization and Automation (DCVAI) exam (300-170) is a 90-minute, 60–70 question assessment. This exam is one of the exams associated with the CCNP Data Center Certification. This exam tests a candidate's knowledge of implementing Cisco data center infrastructure including virtualization, automation, Application Centric Infrastructure, Application Centric Infrastructure network resources, and Application Centric Infrastructure management and monitoring. The course, Implementing Cisco Data Center Virtualization and Automation v6 (DCVAI), helps candidates to prepare for this exam because the content is aligned with the exam topics.

The following topics are general guidelines for the content likely to be included on the exam. However, other related topics may also appear on any specific delivery of the exam. In order to better reflect the contents of the exam and for clarity purposes, the guidelines below may change at any time without notice.

1.0 Implement Infrastructure Virtualization 19%

1.1 Implement logical device separation

1.1.a VDC
1.1.b VRF

1.2 Implement virtual switching technologies

2.0 Implement Infrastructure Automation 16%

2.1 Implement configuration profiles

2.1.a Auto-config
2.1.b Port profiles
2.1.c Configuration synchronization

2.2 Implement POAP

2.3 Compare and contrast different scripting tools

2.3.a EEM
2.3.b Scheduler
2.3.c SDK

3.0 Implementing Application Centric Infrastructure 27%

3.1 Configure fabric discovery parameters

3.2 Implement access policies

3.2.a Policy groups
3.2.b Protocol policies
3.2.b [i[ LLDP, CDP, LCAP, and link-level
3.2.c AEP
3.2.d Domains
3.2.e Pools
3.2.f Profiles
3.2.f [i] Switch
3.2.f [ii] Interface

3.3 Implement VMM domain integrations

3.4 Implement tenant-based policies

3.4.a EPGs
3.4.a [i] Pathing
3.4.a [ii] Domains
3.4.b Contracts
3.4.b [i] Consumer
3.4.b [ii] Providers
3.4.b [iii] vzAny (TCAM conservation)
3.4.b [iv] Inter-tenant
3.4.c Private networks
3.4.c [i] Enforced/unenforced
3.4.d Bridge domains
3.4.d [i] Unknown unicast settings
3.4.d [ii] ARP settings
3.4.d [iii] Unicast routing

4.0 Implementing Application Centric Infrastructure Network Resources 25%

4.1 Implement external network integration

4.1.a External bridge network
4.1.b External routed network

4.2 Implement packet flow

4.2.a Unicast
4.2.b Multicast
4.2.c Broadcast
4.2.d Endpoint database

4.3 Describe service insertion and redirection

4.3.a Device packages
4.3.b Service graphs
4.3.c Function profiles

5.0 Implementing Application Centric Infrastructure Management and Monitoring 13%

5.1 Implement management

5.1.a In-band management
5.1.b Out-of-band management

5.2 Implement monitoring

5.2.a SNMP
5.2.b Atomic counters
5.2.c Health score evaluations

5.3 Implement security domains and role mapping

5.3.a AAA
5.3.b RBAC

5.4 Compare and contrast different scripting tools

5.4.a SDK
5.4.b API Inspector / XML
QUESTION 1
You have a Cisco Nexus 1000V Series Switch. When must you use the system VLAN?

A. to use VMware vMotion
B. to perform an ESXi iSCSI boot
C. to perform a VM iSCSI boot
D. to perform an ESXi NFS boot

Answer: A


QUESTION 2
Which option must be defined to apply a configuration across a potentially large number of switches in the most scalable way?

A. a configuration policy
B. a group policy
C. an interface policy
D. a switch profile

Answer: C


QUESTION 3
Which two options are benefits of using the configuration synchronization feature? (Choose two )

A. Supports the feature command
B. Supports existing session and port profile functionality
C. can be used by any Cisco Nexus switch
D. merges configurations when connectivity is established between peers O supports FCoE in vPC topologies

Answer: A,C

Thursday, June 22, 2017

C2090-556 Informix 11.50 Application Developer

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

The test contains six sections totalling approximately 58 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Database Objects (16%)
Demonstrate knowledge of database objects
Describe when to use SQL routines, functions and modules
Demonstrate knowledge of data types

Section 2 - Traditional Data Manipulation (31%)
Demonstrate knowledge of privileges needed to access data in an application
Describe the differences between dynamic and static SQL
Demonstrate knowledge of distributed queries
Given a scenario, demonstrate knowledge of changing data
Demonstrate knowledge of cursors
Given a scenario, demonstrate the ability to manipulate large objects
Knowledge of built-in functions

Section 3 - SPL Programming (14%)
Core concepts
Core functionality
Triggers
Error Handling in SPL routines

Section 4 - Core Concepts (24%)
Demonstrate knowledge of the difference between SQLI and Distributed Relational Database Architecture (DRDA)
Demonstrate the ability to submit an SQL statement
Describe how to manipulate result sets
Demonstrate knowledge of problem determination
Demonstrate knowledge of isolation levels, locks and logging

Section 5 - Extensibility (16%)
Demonstrate knowledge of existing database extensions
Demonstrate knowledge of UDTs
How to create functions to support UDTs
Demonstrate knowledge of casting
Demonstrate knowledge of Access Methods

IBM Certified Application Developer - Informix 11.50

Job Role Description / Target Audience
This certification exam certifies that the successful candidate has an intermediate level of skills and abilities necessary to design, build, execute and deploy Informix 11.50 database applications, including knowledge of database extension.

Recommended Prerequisite Skills
Significant experience with intermediate or advanced level skills in developing applications that interact with Informix databases should be demonstrated. This individual has strong skills in Informix SQL and in database application development concepts as well as having knowledge of the extensibility features of Informix.

Requirements
This certification requires 1 test(s).
Test(s) required:

Click on the link(s) below to see test details, test objectives, suggested training and sample tests.
Test C2090-556 - Informix 11.50 Application Developer

QUESTION 1
What are user created temporary tables used for?

A. To persistently write temporary data to disk.
B. To share result sets across multiple sessions.
C. To access a temporary result set within one session.
D. To automatically delete data based on a time policy.

Answer: C

Explanation:


QUESTION 2
In an ANSI compliant database, what value of SQLCODE indicates a successful query that
returned no rows?

A. 100
B. -330
C. -201
D. -1

Answer: A

Explanation:


QUESTION 3
Which Committed Read isolation level statement is correct?

A. It locks all rows examined.
B. It does not check for locks.
C. It checks for locks after returning a row.
D. It checks for locks before returning a row.

Answer: D

Explanation:


QUESTION 4
Which two values can be used for connection type field from sqlhosts file when using Distributed
Relational Database Architecture (DRDA) protocol? (Choose two.)

A. ontlitcp
B. onipcshm
C. onsoctcp
D. drtlitcp
E. drsoctcp

Answer: D,E

Explanation:

Wednesday, May 31, 2017

C2090-320 DB2 11 Fundamentals for z/OS

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

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

Section 1 - Working with SQL and XML (14%)
Basic ability to write a DML SQL statement
Basic ability to access and process XML data (XQuery, Xpath)
Basic knowledge of most commonly used special registers
Basic knowledge of built-in functions

Section 2 - Security (8%)
Basic knowledge of restricting data access (authorities, privileges, views, profiles, roles, trusted contexts)
Basic ability to write a Data Control Language (DCL) SQL statement

Section 3 - Planning (17%)
Basic ability to connect to DB2 servers (demonstrate ability to use remote access)
Basic knowledge of different types of tables (Base, MQT, Auxiliary, Partitioned, Temporal � at a high level; when is it appropriate to use each type) and table spaces
Basic knowledge of subsystem parameters
Basic knowledge of DB2 architecture (address spaces, logs, IRLM)
Basic knowledge of data sharing concepts
Basic knowledge of database workloads (transactional processing vs. analytics)
Basic knowledge of encoding scheme concepts

Section 4 - Operations (14%)
Basic knowledge of DB2 commands and DSN commands
Basic knowledge of DB2 utilities
Basic knowledge of troubleshooting (Explain, SQL Codes)

Section 5 - Data Concurrency (10%)
Basic knowledge of transaction management (COMMIT, ROLLBACK, AUTOCOMMIT and SAVEPOINT)
Basic knowledge of locking
Given a situation, basic knowledge to identify the isolation levels that should be used

Section 6 - Application Design (19%)
Basic ability to create and call a stored procedure or a user defined function (understanding of passing parameters and obtaining results)
Basic knowledge of temporary tables (how they are created and when they should be used)
Basic knowledge of triggers (how they function; when they might be used)
Basic knowledge of program preparation and BIND options
Basic knowledge of referential integrity and constraints
Basic knowledge of non-relational data concepts (XML data, LOB data)
Basic knowledge of Temporal (Time Travel) Tables - System-period, Application-period, and Bi-temporal - ability to create and query

Section 7 - Working with Database Objects (17%)
Basic ability to demonstrate usage of IBM-supplied and user-defined data types
Basic ability to write a DDL SQL statement
Basic ability to identify characteristics and properties of DB2 objects (Tables, Indexes, Views,...)
Basic ability to look up information in the DB2 catalog

Friday, May 26, 2017

C2090-311 IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

Test information:
Number of questions: 30
Time allowed in minutes: 60
Required passing score: 60%
Languages: English, Japanese
If you are knowledgeable with DB2 10.5 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.
Section 1 – DB2 Server Management (17%)
Demonstrate the ability to configure DB2 workload for analytics system
DB2_WORKLOAD=ANALYTICS
DB CFG DFT_TABLE_ORG COLUMN
DB CFG DATABASE PAGE SIZE = 32K
DB CFG DFT_DEGREE=ANY
DB CFG DFT_EXTENT_SZ=4
Importance of UTIL_HEAP_SZ CFG for COLUMN ORGANIZED tables load
Demonstrate the ability to use autonomic features in DB2 10.5 BLU Acceleration
AUTO_RUNSTATS is not supported for COLUM ORGANIZED tables
Automatic Space Reclaims in BLU acceleration tables
Demonstrate knowledge of Data Studio 4.1
Demonstrate the ability to use Automated workload management when workload set to ANALYTICS
Section 2 – Physical Design (37%)
Demonstrate the ability to understand industry leading DB2 10.5 BLU Acceleration 7 big ideas
Simple to Impement and Use – No Indexes, No MDC, No MQT, No Partitioning, No Statistical Views
Friendly Huffman encoding – More frequent the values, the fewer bits in dictionary and packed registers. Performing most operations on encoded values.
Usage of SIMD Instruction Sets
Maximize CPU cache
Column Store – Minimal IO / Work performed directly on columns / Improved memory density / Cache efficiency
Memory Caching Facility – Leave the interesting data instead of traditional LRU or MRU algorithms
Data Skipping through SYNOPSIS Tables
Demonstrate the ability to understand and implement compression features
Table Compression – Data Compression / Value Compression / Adaptive Compression / COLUMN ORGANIZED table compression
Database backup compression
Demonstrate the ability to use expression based indexes and the statistics on those expression based indexes
Using RUNSTATS
Using Statistics Profiles
Automatic Statistics Collection
Knowledge of Oracle Migration and Compatibility Features in DB2 10.5
Demonstrate the ability to use Information Uniqueness Constraints
Knowledge of SQL compatibility enhancements
Extended row size support
Exclude null keys support
Section 3 – Monitoring DB2 Activity (17%)
Demonstrate the ability to use new monitor elements
Demonstrate the ability to use new monitor elements to monitor dynamic prefetch requests for data in column-oriented tables.
Demonstrate the ability to use new new monitor elements to measure column data size.
Demonstrate the ability to use new monitor elements to measure time spent in Columnar Data Engine (CDE)
Demonstrate knowledge of the new EXPLAIN enhancements Knowledge of SQL compatibility enhancements
Demonstrate the ability to understand new CTQ (Column Table Queue) Operator in the explain
Knowledge of new monitoring function – MON_GET_ROUTINE
Demonstrate knowledge of HADR monitoring enhancements
HEARTBEAT_MISSED
HEARTBEAT_EXPECTED
STANDBY_SPOOL_PERCENT
STANDBY_ERROR_TIME
Section 4 – High Availability (17%)
Knowledge of enhancements to pureScale
Understand the ability to use Online REORG in pureScale
Knowledge of replay member in pureScale standby cluster
Knowledge of HADR setup in a pureScale cluster environment
Demonstrate the ability to undestand Rolling Fix Pack Updates in pureScale
Demonstrate the ability to undestand STMM Multi-Tenancy Feature in pureScale
Demonstrate the ability to understand Explicit Hierarchical Locking Multi-Tenancy in pureScale system
Knowledge of DB2 Advanced Copy Services customized scripts
Section 5 – Utilities (13%)
Demonstrate the ability to use IBM Optim Query Workload Tuner
The Workload Table Organization Advisor
Support for comparing access plans before and after
Access Plan Explorer and in access plan graphs for the new CTQ operator
Demonstrate the ability to use DB2 10.5 Utilities
db2convert
LOAD Command – Additional ANALYZE phase for COLUMN ORGANIZED tables
Default AUTOMATIC STATISTICS COLLECTION in LOAD command for COLUMN ORGANIZED tables
IBM Certified Database Administrator – DB2 10.5 DBA for LUW Upgrade from DB2 10.1
Job Role Description / Target Audience
If you are knowledgeable with DB2 10.5 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.
This exam covers only the new features and functionality of DB2 10.5 for Linux, UNIX and Windows – you must possess the DB2 10.1 DBA for Linux, UNIX and Windows certification in order to qualify for the upgrade exam.
C2090-311 IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1
QUESTION 1
How is the Query Workload Tuner license installed and enabled?
A. With Data Studio, using the license activation kit.
B. By executing the db2licm command after data server installation.
C. With the Optim Performance Manager Server, using the license activation kit.
D. By running the Query Workload Tuner license activation command on the appropriate
WebSphere server.
Answer: A
Explanation:

QUESTION 2
If the DB2_WORKLOAD registry variable has not been set which database manager configuration
parameter must be modified, before a query that accesses a column-organized table can be
executed?
A. INTRA_PARALLEL
B. QUERY_HEAP_SZ
C. MAXIMUM DEGREE
D. SHEAPTHRES SHR
Answer: A

Saturday, February 4, 2017

C2020-615 IBM Cognos Real-time Monitoring Developer

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

Related certifications:
IBM Certified Developer - Cognos Real-time Monitoring
IBM Certified Solution Expert - Cognos BI

If your job role includes configuring, modeling and maintaining the IBM Cognos Real-time Monitoring applications, then you may consider adding this certification to your professional portfolio.

The IBM Cognos Financial Statement Developer exam covers key concepts, technologies, and functionality of Real-time Monitoring. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.

Architecture (18%)
Demonstrate knowledge of architecture concepts
Demonstrate knowledge of integration with Cognos 10
Demonstrate knowledge of Streaming Data Store concepts
Describe data acquisition concepts
Describe Alerting Engine concepts
Demonstrate knowledge of various system settings

Business Requirements and Key Performance Indicators (10%)
Demonstrate appropriate use-cases for the solution
Demonstrate appropriate KPIs for the solution

Data Modeling (30%)
Demonstrate knowledge of Agents
Describe Data Streams concepts
Demonstrate knowledge of Lookup Tables
Demonstrate knowledge of View concepts
Demonstrate knowledge of View implementation
Demonstrate knowledge of Cubes

Security and Authentication Providers (9%)
Identify security model concepts
Demonstrate knowledge of Authentication Providers

Business Rules and Exception Management (14%)
Demonstrate basic knowledge of the exception management architecture
Demonstrate knowledge of exception management advanced capabilities
Demonstrate knowledge of alert subscription
Demonstrate knowledge of augmenting alerts with data

Dashboard (12%)
Demonstrate knowledge of Dashboard and Dashboard Object concepts
Demonstrate knowledge of Watchpoints

Business Insight (7%)
Demonstrate knowledge of using RTM objects
C2020-615 IBM Cognos Real-time Monitoring Developer
IBM Certified Developer - Cognos Real-time Monitoring

Job Role Description / Target Audience
The Real-time Monitoring developer is responsible for configuring, modeling and maintaining IBM Cognos Real-time Monitoring applications. This individual is a new to Real-time Monitoring and will be able to participate as an effective team member.

To achieve the IBM Certified Developer - Cognos Real-time Monitoring certification, candidates must possess the skills identified under Recommended Prerequisite Skills, if any, and pass one (1) exam.

Click the test link below to see the overview, objectives, and test preparation recommendations

Recommended Prerequisite Skills
Prior to your preparation for this associate-level certification, the following knowledge and skills are recommended and assumed:

Experience in database design
Working knowledge of SQL
Experience deploying software application infrastructure (databases, networking)
Experience in database performance and tuning
Knowledge of and experience in deploying application servers and Web Servers

Requirements
This certification requires 1 test(s).

Test(s) required:
Test C2020-615 - IBM Cognos Real-time Monitoring Developer

IBM Certified Solution Expert - Cognos BI

Job Role Description / Target Audience
The BI Solution Expert (Professional) is responsible to analyze, plan, design, deploy, and operate Cognos applications using an appropriate methodology and development approach.

To achieve the IBM Certified Solution Expert - Cognos BI certification, candidates must possess the skills identified under Recommended Prerequisite Skills, if any, and pass four (4) exams.

Click the test link below to see the overview, objectives, and test preparation recommendations.

Recommended Prerequisite Skills
Prior to your preparation for this professional-level certification, the following knowledge and skills are recommended and assumed:

Knowledge of the Cognos Solutions Implementation Methodology
Technical proficiency in features of the Cognos Managers and Studios

QUESTION 1
Which three settings are required to synchronize the user and/or roles from an external directory
server, like LDAP, to Real-time Monitoring? (Choose three.)

A. LDAP User Primary Email
B. LDAP User Base DN
C. LDAP Port
D. LDAP Synchronization User DN
E. LDAP Principal DN Prefix

Answer: B,C,D

Explanation:


QUESTION 2
What contains the minimum required access permissions to create a cube?

A. CREATE for Views, Cubes, and Dimensions, CREATE for Lookup Tables and Data Streams,
and READ-ONLY for an existing View
B. CREATE for Views, Cubes, and Dimensions, CREATE for Lookup Tables and Data Streams,
and READ-ONLY for the dimensions to include in the cube
C. CREATE for Views, Cubes, and Dimensions, READ-ONLY for an existing View, and READONLY
for the dimensions to include in the cube
D. CREATE for Views, Cubes and Dimensions, and READ-ONLY for an existing View

Answer: C

Explanation:


QUESTION 3
When editing a user's Access Permissions, what is meant by the term Effective Permissions?

A. the greatest level of permission assigned by Role-Granted and User-Specific permissions
B. the user's permissions against the currently selected object
C. the lowest level of permission assigned by Role-Granted and User-Specific permissions
D. the permission implementation that most effectively secures your application

Answer: A

Explanation:



Thursday, February 2, 2017

C2020-021 IBM OpenPages Developer

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

Related certifications:
IBM Certified Developer - OpenPages

The IBM OpenPages Developer exam will certify that the successful candidate has the fundamental knowledge to participate as an effective team member in the implementation of IBM OpenPages Platform and components for a customer solution.

OpenPages Overview (16%)
Identify the purpose of OpenPages
Identify the technology stack overview
Describe how to customize OpenPages
Describe the OpenPages user interface

Data Model (18%)
Describe the object model rules
Describe the Business Entity structure
Identify Core Data Model Spine
Describe how to manage objects and associations
Describe administrative configuration concepts (e.g., dependencies, views, objects, fields)

Security Model (17%)
Identify roles and role-based security models
Demonstrate knowledge of Security Access Control Permissions
Demonstrate knowledge of security domains
Describe role assignments and how to assign access for users
Identify user and group configurations
Describe security rules

Profile Configuration (18%)
Identify field behavior
Describe views
Describe AFCON concepts

OpenPages GRC Features and Functions (20%)
Describe triggers
Identify UI Extensions / Helpers / Utilities (JSPs)
Identify Computed Fields and Reporting Fragment Configuration
Identify import/export methods

OpenPages Implementation Process (11%)
Identify the implementation phases (BASIM)
Identify environment migration

Job Role Description / Target Audience
The IT Consultant (also known as the Consulting Engineer) will write reports and programs (this exam is not intended for report writers), implement solutions for OpenPages GRC platform deployments, deliver high-quality technical deliverables and might be called upon to assist with the development of a Statement Of Work (SOW). The candidate will also participate in the OpenPages community via knowledge sharing, best practice documentation and training.

To achieve the IBM Certified Developer - OpenPages certification, candidates must possess the skills identified under Recommended Prerequisite Skills, if any, and pass one (1) test.

Click the test link below to see the overview, objectives, and test preparation recommendations.

Recommended Prerequisite Skills
Prior to your preparation for this certification, the following knowledge and skills are recommended and assumed (but not tested) :

Intermediate to advanced competency in Microsoft Excel.
Intermediate to advanced competency in J2EE web-based platforms.
Intermediate to advanced commercial programming experience in HTML, JSP, XML and Java, using OO concepts, SQL, Java script.

Requirements
This certification requires 1 test(s).

Test(s) required:
Click on the link(s) below to see test details, test objectives, suggested training and sample tests.
Test C2020-021 - IBM OpenPages Developer