Number of questions: 67
Time allowed in minutes: 90
Required passing score: 63%
Languages: English, Japanese
Section 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
Section 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 abillity to correctly size system for capacity planning
Abilty to utlize groom table feature and knowledge of impact on performance and storage
Section 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.)
Section 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)
Section 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
Section 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
Section 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 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)
Section 8 Troubleshooting
Demonstrate knowledge of directory location (log files)
Demonstrate knowledge of nzdumpschema
Demonstrate knowledge of Event Manager Changes
Section 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
System Health Check (basic and advanced)
Demonstrate knowledge to administer BI and Analytic functionality
Section 10 Transaction Management
Data Columns (housekeeping) (CreateXID, DeleteXID, RowID)
Section 11 Workload Management
GRA (Guarenteed Resource Allocation)
PQE (Priority Query Execution)
SQB (Short Query Bias)
New features (7.1 and later)�
IBM Certified Specialist – PureData System for Analytics v7.1
Job Role Description / Target Audience
An IBM Certified Specialist drives the design, implementation and support applications on the PureData System for Analytics platform. This individual has experience designing a PureData System for Analytics in accordance with best practices of ETL, BI, data modeling, and analytical solution.
Recommended Prerequisite Skills
Knowledge and experience managing IBM PureData System for Analytics Platform applications
Knowledge of SQL fundamentals within IBM PureData System for Analytics Platform applications
Experience in data warehouse industry best practices
Basic understanding of Linux and UNIX
What are the minimum permissions required to install an IBM Tivoli Endpoint Manager (TEM) Relay from the TEM Console?
A. TEM Operator
B. Local Administrator
C. Domain Administrator
D. TEM Master Operator
What is an IBM Tivoli Endpoint Manager analysis?
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.
What statement is correct when assigning roles to Active Directory security groups in IBM Tivoli Endpoint Manager Web Reports?
A. Security groups can be assigned any role.
B. Security groups can only be assigned the role Normal.
C. Security groups can only be assigned the role Read-only.
D. Security groups can only be assigned the role Administrator.
Which statement is true about Relay Affiliation group names?
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.
Why would an IBM Tivoli Endpoint Manager (TEM) administrator use the task relay setting Name Override?
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