top of page
Search

Why is it Important to do IBM PureData System for Analytics Certification?

  • Writer: Palak Mazumdar
    Palak Mazumdar
  • Oct 24, 2018
  • 5 min read

IBM PureData System for Analytics certification questions and exam summary helps you to get focused on the exam. This guide also helps you to be on C2090-560 exam track to get certified with good score in the final exam.

The IBM Professional Certification Program offers you the ability to earn credentials to demonstrate your expertise. It is designed to validate your skills and capability to perform role-related tasks and activities at a specified level of competence. The achievement of an IBM Professional Certification demonstrates to your colleagues and employers your expertise in the related IBM technologies and solutions.

It is the mission of the IBM Professional Certification Program to:

  • Provide a reliable, valid and fair method of assessing skills and knowledge.

  • Develop a worldwide community of highly skilled certified professionals who recommend, sell, service, support and/or use IBM products and solutions.

IBM Professional Certification program has a complete range of certifications, from entry-level to advanced, that include many different job roles to suit your professional needs.

IBM PureData System for Analytics Certification C2090-560 Exam Syllabus:

1. Database Design

  • Ability to design, create and manage databases and database objects (tables, views, etc.)

  • Ability to create and manage users and groups

  • Knowledge of the Netezza schema concept

  • Demonstrate the ability to design, implement and maintain materialilzed views

  • Knowledge of the benefits of clustered based tables

  • Demonstrate knowledge and application of sequences

  • Demonstrate knowledge of zone maps

  • Demonstrate knowledge of and application of data types

  • Demonstrate knowledge of table defaults and constraints

2. Physical Optimization

  • Demonstrate knowledge of data distribution and skew

  • Ability to select an appropriate data distribution key

  • Knowledge of PureData System for Analytics implementation of temporary tables

  • Demonstrate knowledge of optimizer settings

  • Abilty to maintain statistics and knowledge of impact on performance

  • Demonstrate the ability to correctly size system for capacity planning

  • Ability to utilize groom table feature and knowledge of impact on performance and storage

3. Netezza Appliance Components

  • Knowledge of the TwinFin architecture and disks/dataslices

  • Ability to identify the number of disks/dataslices on a system

  • Knowledge of the appliance architecture (FPGA, SPU, Disk Array, etc.)

4. High Availability Architecture

  • Demonstrate knowledge of Linux High Availability (HA) and Distributed Replicated Block Device (DRDB)

  • Knowledge of behavior of nzLoad and query processing with a state change (host, disk, blade)

5. Security

  • Knowledge of access/priviledge database objects

  • Knowledge of using Lightweight Directory Access Protocol (LDAP)

  • Knowledge of Linux system administration

  • Knowledge of ODBC/JDBC in a Unix or Windows environment and OLE-DE connectivity

  • Knowledge of new cryptographics mode and Row Secure Tables

6. Data Movement

  • Demonstrate ability to use external tables in loading and unloading data

  • Demonstrate ability to use backup/restore utilities

  • Demonstrate ability to perform inserts (external tables vs cross system)

  • Demonstrate ability to design cross-database access

  • Demonstrate ability to use nzload

7. Monitoring and Performance

  • Demonstrate knowledge of log files

  • Demonstrate knowledge of locks with update, delete, insert, and select

  • Demonstrate knowledge of transactions that use temporary tables

  • Demonstrate knowledge of system views

  • Describe alerts

  • Describe data flow and life of a query

  • Demonstrate knowledge of compression

  • Demonstrate knowledge of broadcasts and co-location/redistribute

  • Demonstrate knowledge of data skew

  • Analyzing Query Plan Files (Explain plans vs execution plans; Joins (expression based, cross product, merge, hash joins); recognizing the correct query plan (original vs executing))

  • Performance Tuning (Multiple Snippets (Data Restrict Optimization); Snippets Limiter; Invisible Columns)

8. Troubleshooting

  • Demonstrate knowledge of directory location (log files)

  • Demonstrate knowledge of nzdumpschema

  • Demonstrate knowledge of Event Manager Changes

9. Operations

  • Ability to manage the system using the command line interface

  • Demonstrate knowledge of NZ_ defaults settings

  • Query History (Enablement, management, selection tables, configuration files, staging, notifications)

  • Software Support Toolkit (common tasks - migration, table movement)

  • Backup and Recovery

  • Replication

  • System Health Check (basic and advanced)

  • Demonstrate knowledge to administer BI and Analytic functionality

10. Transaction Management

  • Serialization issues

  • Data Columns (housekeeping) (CreateXID, DeleteXID, RowID)

  • Unreferencable rows

11. Workload Management

  • GRA (Guaranteed Resource Allocation)

  • PQE (Priority Query Execution)

  • SQB (Short Query Bias)

  • Virtual Tables

  • New features (7.1 and later)

  • Scheduler Rules

C2090-560 Certification Summary

C2090-560 IBM PureData System for Analytics Certification Exam Sample Questions:

C2090-560 IBM PureData System for Analytics Certification Sample questions are provided for each exam to illustrate the various question types that may appear. For some credentials, a practice exam is also available.


IBM C2090-560 Sample Questions:

Q1: A system is grayed out in the Computers section of the Navigation Tree. Which basic check should be performed?


Options:

a) Look at the Relay for the grayed out system and determine if the Relay Service is running.

b) Determine if the system is a laptop. Laptop systems often connect to and disconnect from the network and when disconnected, it will be grayed out.

c) Attempt to ping the system from a workstation. If it is not reachable, it means the system is most likely turned off and is in a normal state at this time.

d) Attempt to ping the system from the IBM Tivoli Endpoint Manager Server. If it is not reachable, it means the system is most likely turned off and is in a normal state at this time.


Q2: Which statement is true about Relay Affiliation group names?


Options:

a) The names are case sensitive.

b) Names must start with a double underscore.

c) Names must not use a relay machine name.

d) Any naming scheme can be set up by an administrator.


Q3: What makes a system a good candidate to be an IBM Tivoli Endpoint Manager (TEM) Relay?


Options:

a) It should always be a system dedicated to the relay.

b) An existing system that meets the requirements of the TEM Relay.

c) It should run Windows Server 2003, Windows Server 2008, or Mac OS X Server.

d) It should have dual network interfaces to isolate agents from downstream relays.


Q4: In which language can the Retrieved Properties be written that underlies each analysis?


Options:

a) Python

b) Javascript

c) Relevance

d) Action Script


Q5: Why would an IBM Tivoli Endpoint Manager (TEM) administrator use the task relay setting Name Override?


Options:

a) to provide an alternate domain name for the agent connections to a relay

b) to have the relay report a different name to the server to avoid name collision with another relay

c) to have the relay display a different name in the TEM Console than its default name so it can be grouped with other relays

d) to have the relay use a different domain name so it can be part of a Managed Service Point segmented customer environment


Q6: Which two types of operators can log into the IBM Tivoli Endpoint Manager Console?

(Choose two.)


Options:

a) Operator

b) Super User

c) Administrator

d) Master Operator

e) Site Administrator


Q7: Which computer groups are available in an IBM Tivoli Endpoint Manager V8.1 environment?


Options:

a) Automatic, Static, Ad-Hoc

b) Dynamic, Manual, Ad-Hoc

c) Automatic, Manual, Ad-Hoc

d) Automatic, Manual, Temporary


Q8: How should operating system and application patches be tested?


Options:

a) contact the right software vendor

b) install them on specific test systems

c) rely on bulletins from specific vendors

d) review the Fixlet code that performs the patching


Q9: What are three requirements for an endpoint to be used as a relay?

(Choose three)


Options:

a) Java V1.4.2 or higher

b) minimum free hard drive space: 2 GB

c) Firefox V2.0 or above (for UNIX relays)

d) a two-way TCP connection to its parent

e) a two-way UDP connection to its parent

f) Internet Explorer V4.0 or above (for Windows relays)


Q10: What is an IBM Tivoli Endpoint Manager analysis?


Options:

a) It allows viewing of various client properties.

b) It allows changing of various client properties.

c) It is a task used to analyze the status of the clients.

d) It is a Fixlet used to analyze the status of the clients.


Answers:

Question: 1 Answer: b

Question: 2 Answer: d

Question: 3 Answer: b

Question: 4 Answer: c

Question: 5 Answer: a

Question: 6 Answer: a, d

Question: 7 Answer: c

Question: 8 Answer: b

Question: 9 Answer: b, d, f

Question: 10 Answer: a


How to Register for IBM PureData System for Analytics Certification Exam?

Registration Options:

  • Register for IBM PureData System for Analytics Certification Exam on Pearson VUE.

Comments

bottom of page