Friday, June 23, 2017

C2090-558 Informix 11.70 Fundamentals

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

The test contains six sections totalling approximately 60 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 Installation (16%)
Identify data access restrictions
Describe database workloads
Describe data type concepts for database planning
Demonstrate knowledge of how to configure and install Informix
Demonstrate knowledge of embeddability considerations and the deployment utility

Section 2 - Security (3%)
Demonstrate knowledge of authentication
Demonstrate knowledge of authorizations

Section 3 - DBMS Instances and Storage Objects (14%)
Describe how to identify and connect to Informix servers and databases
Demonstrate knowledge of how to create and configure storage objects
Demonstrate general knowledge of the system databases and database catalogs

Section 4 - Informix Tables, Views and Indexes (15%)
Given a scenario, describe how to create a table
Describe when referential integrity should be used
Describe methods of data value constraint
Describe the differences between a table, view, sequences, synonyms, and indices
Describe triggers and appropriate uses
Demonstrate knowledge of schema commands

Section 5 - Informix Data using SQL (14%)
Describe how to use SQL to SELECT data from tables
Describe how to use SQL to UPDATE, DELETE, or INSERT data
Demonstrate knowledge of transactions
Describe how to call a procedure or invoke a user defined function

Section 6 - Data Concurrency and Integrity (10%)
Identify isolation levels and their effects
Identify objects on which locks can be obtained
Describe transaction integrity mechanisms

Section 7 - Tools and Utilities (15%)
Describe onstat, oninit, and onmode utilities
Demonstrate knowledge of data movement utilities
Describe sysadmin database and its functionality
Demonstrate knowledge of the features or functions available in Informix tools

Section 8 - Backup and Restore (8%)
Demonstrate knowledge of backup procedures
Demonstrate knowledge of recovery procedures

Section 9 - Replication Technologies (5%)
Describe the purpose of the different replication technologies

IBM Certified Database Associate - Informix 11.70 Fundamentals

Job Role Description / Target Audience
The successful candidate for the IBM Certified Database Associate - Informix 11.70 Fundamentals has important knowledge, skills, and abilities necessary to provide entry level administration of Informix, including basic SQL (Structured Query Language), how Informix is installed, how to create databases and database objects, security, transaction isolation, backup and recovery procedures, and describe replication technologies and purposes.

This certification targets:
Entry level technical professionals - programming, system design, architect
University students - application of information technology
Entry level DBAs - database administration

Recommended Prerequisite Skills

The following subjects are covered within this examination:
Planning and Installation
Security
DBMS Instances and Storage Objects
Informix Tables, Views, and Indexes
Informix Data using SQL
Data Concurrency and Integrity
Tools and Utilities
Backup and Restore
Replication Technologies
QUESTION: 1
When restoring data, which granularity of object may NOT be restored?

A. a single table
B. a single chunk
C. a single dbspace
D. an entire instance

Answer: B

QUESTION: 2
Which command would you execute to restore to a specific moment-in—time?

A. onbar—t timestamp
B. onbar—r —|og Iognum
C. onbar —r —t timestamp
D. onbar —r -| timestamp

Answer: C

QUESTION: 3
Click the Exhibit button.


An administrator created a table using the SQL statement shown in the exhibit to perform a load operation every day
at 11:00 Al\/I. What is the best way to optimize a backup strategy to recover the client table in case of a failure?

A. a |eveI—1 backup at 6:00 Al\/I everyday
B. a |eveI—0 backup soon after the load operation
C. a |eveI—1 backup on Sunday and continuous log backup
D. a |eveI—2 backup at 6:00 Al\/I every day and continuous log backup

Answer: B

QUESTION: 4
Which command option should be used to resume an interrupted onbar restore?

A. -RETRY
B. -RESTART
C. -RElNTllALZE
D. -BEGlN_AGAlN

Answer: B
Posted by at No comments:
Labels: , , , , , , ,

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:
Posted by at No comments:
Labels: , , , , , , ,

Sunday, June 18, 2017

C9510-418 IBM WebSphere Application Server Network Deployment V9.0 Core Administration

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

Section 1: Install and update the environment (14%)
Apply maintenance to the product
Demonstrate an understanding of the IBM Installation Manager and IBM Packaging Utility and its role in installing, configuring, and maintaining IBM WebSphere Application Servers and components both locally and remotely.
Perform a silent installation for IBM WebSphere Application Server and fix pack installations.
Perform post-installation verification.
Troubleshoot installation problems.
Backup and restore the configuration including the use of checkpoints

Section 2: Create a high availability configuration (9%)
Create multi-node topology and appropriate high availability model.
Manage nodes in an IBM WebSphere Application Server topology.
Configure and manage the HTTP server and the web server plug-in for high availability.
Configure distributed session management for high availability and failover scenarios.

Section 3: Configure security (17%)
Configure user repositories.
Configure SSL for clients and servers.
Implement multiple security domains.
Apply administrative and application security roles.
Configure different authentication and authorization mechanisms.
Configure Java Enterprise, Web and Web Services Security.

Section 4: Monitor and tune the environment (9%)
Use performance tooling to monitor the IBM WebSphere Application Server runtime.
Tune parameters that affect IBM WebSphere Application Server performance.
Use the Performance Monitoring Infrastructure (PMI) metrics and poll MBeans for performance data.
Configure and monitor the WebSphere Application Server caching mechanisms.

Section 5: Troubleshoot post-installation problems (11%)
Enable High Performance Extensible Logging (HPEL) and view HPEL data.
Enable Cross Component Trace (XCT) and view trace data in XCT Log Viewer.
Use tools to trigger and analyze heap dumps, javacore dumps, system core dumps and verbose Garbage Collection (GC).
Use "mustgather" documentation and/or the IBM Support Assistant to collect and analyze diagnostic data or submit data to IBM Support.
Configure, review and analyze log files for the following: First Failure Data Capture (FFDC), system logs, native logs, and trace logs.

Section 6: Administer and configure the environment (20%)
Connect databases.
Create and manage Full profiles.
Configure resources.
Illustrate the usage of the Integrated Solutions Console.
Use the capabilities of the Job Manager tooling.
Configure or modify an IBM WebSphere Application Server environment by using properties files and/or the monitored directory feature.
Configure an external HTTP server for the environment.
Use the standard set of command line tools to perform administrative tasks.

Section 7: Configure Intelligent Management features (6%)
Use the dynamic cluster elasticity feature.
Create and configure On Demand Routers (ODR) and the ODR plug-in and associated service policies to enable the dynamic operations.
Use health policies and actions to monitor and react to changing performance in the environment.
Configure and maintain application editions.

Section 8: Demonstrate an understanding of a multi-tier environment (6%)
Identify the components and services in an IBM WebSphere Application Server configuration and describe how they are related or interact.
Demonstrate an understanding of how requests traverse various WebSphere Application Server ND topologies.

Section 9: Deploy and administer applications (8%)
Perform partial updates of enterprise applications, web applications, and business level applications.
Deploy applications to an IBM WebSphere Application Server environment.

IBM Certified System Administrator - WebSphere Application Server Network Deployment V9.0

Job Role Description / Target Audience
This intermediate level certification is intended for system administrators (system integrators, infrastructure architects, application architects and solutions architects) who perform the installation, configuration and day-to-day tasks associated with ensuring the smooth, reliable, and efficient operation of an IBM WebSphere Application Server Network Deployment environment.

This includes tasks related to:
1. Architecture
2. Product Installation, Configuration, and Maintenance
3. Application Management (Deployment and Configuration)
4. Administrative Tools
5. Security Configuration
6. Clustering and Workload Management
7. Intelligent Management
8. Performance Monitoring and Tuning
9. Problem Determination

This system administrator is generally self-sufficient and can perform most of the tasks involved in the role with limited assistance from peers, product documentation, and vendor support services.

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.
· basic Java Enterprise Edition knowledge
· basic web application architecture and deployments
· basic utilization of the command line interface and Jython/Jacl
· understanding of operating systems
· network and operating system security concepts
· networking problem determination skills
· operating system problem determination skills
QUESTION 1
Which two ways are valid ways to install applications to IBM WebSphere Application Server? (Select two.)

A. wsadminscript
B. JMS messaging
C. IBM Installation Manager
D. IBM Tivoli Access Manager
E. Integrated Solutions Console

Answer: A,E

Explanation:
Deploy an application or module using the administrative console, wsadmin, programming, or deployment tools.
References:https://www.ibm.com/support/knowledgecenter/en/SSAW57_8.5.5/com.ibm.we bsphere.nd.doc/ae/crun_app_install.html

QUESTION 2
Which is true when an administrator properly updates a single file within an application?

A. The administrator can use apartial application update.
B. The administrator must redeploy the full application file.
C. The administrator can manually update the file on the file system.
D. The administrator must uninstall the application, and then, reinstall with the updated application file.

Answer: C

QUESTION 3
Which is true about software repositories for IBM Installation Manager?

A. Repositories must be local.
B. Repositories must be online.
C. Repositories can be either local or online.
D. Repositories are only in the media package.

Answer: C

Explanation:
IBM Installation Manager is a single installation program that can use remote or local software repositories to install,modify, or update certain IBM products. It determines and shows available packages, checks prerequisites and interdependencies, and installs or modifies the selected packages. You also use IBM Installation Manager to uninstall the packages that it installed.
References:http://www-01.ibm.com/support/docview.wss?uid=swg24023498

QUESTION 4
Which of the following is true about creating multiple security domains?

A. A new security domain can be created only using the administrative console.
B. Global security must be enabled before creating new multiple security domains.
C. Only usersassigned to the security-admin role can create new multiple security domains.
D. If a unique name for the domain is not specified, the system will automatically create one.

Answer: C

Explanation:
Only users assigned to the administrator role can configure multiple security domains.
References:https://www.ibm.com/support/knowledgecenter/SSAW57_8.5.5/com.ibm.websp here.nd.doc/ae/csec_sec_multiple_domains.html

Posted by at No comments:
Labels: , , , , , , ,

Thursday, June 1, 2017

300-165 DCII Implementing Cisco Data Center Unified Fabric

Implementing Cisco Data Center Unified Fabric
Exam Number 300-165 DCII
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 key protocols, routing and switching protocols, maintenance, management, operations, security, and storage.

The Implementing Cisco Data Center Infrastructure (DCII) exam (300-165) 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 key protocols, routing and switching protocols, maintenance, management, operations, security, and storage. The course, Implementing Cisco Data Center Infrastructure v6 (DCII), 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 Data Center Protocols 29%

1.1 Implement vPC

1.2 Implement FabricPath

1.2.a Segment ID
1.2.b Distributed gateway, anycast HSRP
1.2.c Multiprotocol BGP
1.2.d vPC+

1.3 Implement VXLAN

1.3.a Distributed gateway
1.3.b Multiprotocol-BGP-EVPN
1.3.c vPC

1.4 Implement OTV

1.5 Implement LISP

2.0 Implement Routing and Switching Protocols 22%

2.1 Implement routing protocols

2.1.a OSPFv2, OSPFv3
2.1.b IS-IS
2.1.c PIM
2.1.d FHRP
2.1.d [i] HSRP
2.1.d [ii] VRRP

2.2 Implement switching protocols

2.2.a STP
2.2.b LACP/port channel
2.2.c FEX, VNTAG

3.0 Data Center Infrastructure Maintenance, Management, and Operations 14%

3.1 Plan and execute software updates

3.1.a Disruptive / nondisruptive
3.1.b EPLD

3.2 Implement configuration management

3.2.a Backups / restore
3.2.b Checkpoints /rollback

3.3 Implement infrastructure monitoring

3.3.a Logging
3.3.b SNMP
3.3.c Call Home
3.3.d NetFlow
3.3.e SPAN

3.4 Configure time synchronization

3.4.a PTP
3.4.b NTP

4.0 Data Center Infrastructure Security 12%

4.1 Implement ACLs

4.2 Implement AAA and RBAC

4.3 Implement keychain authentication

4.4 Implement first-hop security

4.4.a Dynamic ARP inspections
4.4.b DHCP snooping
4.4.c Unicast RPF
4.4.d MACsec
4.4.e Port security

4.5 Implement CoPP

4.6 Implement fabric binding and port security

5.0 Infrastructure Storage 23%

5.1 Implement Fibre Channel fabric

5.1.a Switched fabric initialization
5.1.b Port channels, ISL
5.1.c FCID
5.1.d FCIP

5.2 Implement Fibre Channel Protocol services

5.2.a Zoning
5.2.b Cisco Fabric Services
5.2.c FCNS
5.2.d Device alias
5.2.e VSAN
5.2.f FSPF

5.3 Implement FCoE Unified Fabric

5.3.a Storage VDC
5.3.b FIP
5.3.c FCoE topologies
5.3.d DCB
QUESTION 1 - (Topic 1)
Which statement about the Layer 3 card on the Cisco Nexus 5500 Series Switch is true?

A. BGP support is not provided, but RIP, EIGRP, and OSPF support is provided.
B. Up to two 4-port cards are supported with up to 160 Gb/s of Layer 3 forwarding capability.
C. Up to 16 FEX connections are supported.
D. Port channels cannot be configured as Layer 3 interfaces.

Answer: C

Explanation:
From the Cisco NX-OS 5.1(3)N1(1) release and later releases, each Cisco Nexus 5500 Series device can manage and support up to 24 FEXs without Layer 3. With Layer 3, the number of FEXs supported per Cisco Nexus 5500 Series device is 8. With Enhanced vPC and a dual-homed FEX topology each FEX is managed by both Cisco Nexus 5000 Series devices. As a result, one pair of Cisco Nexus 5500 Series devices can support up to 24 FEXs and 16 FEXs for Layer 2 and Layer 3.
Reference: http://www.cisco.com/en/US/docs/switches/datacenter/nexus5000/sw/mkt_ops_guides/513 _n1_1/n5k_enhanced_vpc.html

QUESTION 2 - (Topic 1)
Which statement about SNMP support on Cisco Nexus switches is true?

A. Cisco NX-OS only supports SNMP over IPv4.
B. Cisco NX-OS supports one instance of the SNMP per VDC.
C. SNMP is not VRF-aware.
D. SNMP requires the LAN_ENTERPRISE_SERVICES_PKG license.
E. Only users belonging to the network operator RBAC role can assign SNMP groups.

Answer: B

Explanation:
Cisco NX-OS supports one instance of the SNMP per virtual device context (VDC). By default, Cisco NX-OS places you in the default VDC. SNMP supports multiple MIB module instances and maps them to logical network entities. SNMP is also VRF aware. You can configure SNMP to use a particular VRF to reach the SNMP notification host receiver. You can also configure SNMP to filter notifications to an SNMP host receiver based on the VRF where the notification occurred.
Reference: http://www.cisco.com/c/en/us/td/docs/switches/datacenter/sw/5_x/nx-os/system_management/configuration/guide/sm_nx_os_cg/sm_9snmp.html

QUESTION 3 - (Topic 1)
Which three items must be configured in the port profile client in Cisco UCS Manager? (Choose three.)

A. port profile
B. DVS
C. data center
D. folder
E. vCenter IP address
F. VM port group

Answer: B,C,D

Explanation:
After associating an ESX host to a DVS, you can migrate existing VMs from the vSwitch to the DVS, and you can create VMs to use the DVS instead of the vSwitch. With the hardware-based VN-Link implementation, when a VM uses the DVS, all VM traffic passes through the DVS and ASIC-based switching is performed by the fabric interconnect.
In Cisco UCS Manager, DVSes are organized in the following hierarchy: vCenter
Folder (optional)
Datacenter
Folder (required)
DVS
At the top of the hierarchy is the vCenter, which represents a VMware vCenter instance. Each vCenter contains one or more datacenters, and optionally vCenter folders with which you can organize the datacenters. Each datacenter contains one or more required
datacenter folders. Datacenter folders contain the DVSes.
Reference: http://www.cisco.com/c/en/us/td/docs/unified_computing/ucs/sw/gui/config/guide/1-3-1/b_UCSM_GUI_Configuration_Guide_1_3_1/UCSM_GUI_Configuration_Guide_1_3_1_c hapter28.html

QUESTION 4 - (Topic 1)
Which GLBP load-balancing algorithm ensures that a client is always mapped to the same VMAC address?

A. vmac-weighted
B. dedicated-vmac-mode
C. shortest-path and weighting
D. host-dependent

Answer: D

Explanation:
Host dependent—GLBP uses the MAC address of the host to determine which virtual MAC address to direct the host to use. This algorithm guarantees that a host gets the same virtual MAC address if the number of virtual forwarders does not change.
Reference: http://www.cisco.com/c/en/us/td/docs/switches/datacenter/sw/5_x/nx-os/unicast/configuration/guide/l3_cli_nxos/l3_glbp.html

Posted by at No comments:
Labels: , , , , , , ,
Subscribe to: Posts (Atom)