P2090-050 IBM PureData System for Analytics Technical Mastery Test v1 Questions and Answers

AIX

SUSE Linux

Nucleus OS

Redhat Linux

Groom allows the user to add row level security.

Groom validates primary key constraints on the table.

Groom reorders rows based on the DISTRIBUTE ON clause.

Groom allows the user to reorganizetables based on the ORGANIZE ON clause.

No more than 4 users can be assigned to GroupA.

If users in GroupA submit more than 4 queries they will fail.

If users in GroupA submit more than 4 queries, then they will queue in order.

The job maximum cannot be less than the default concurrent query limit of 48.

Collocation hash join processing

Distributed hash join processing

Broadcast sort merge join processing

Replication sort merge join processing

The table statistics are used to facilitate disk space reclamation of deleted rows.

The optimizer uses statistics to determine the optimal execution plan for queries.

The Zone Map information cross references the table statistics for each column to avoid scanning.

The Field Programmable Gate Array (FPGA) utilizes the statistics to identify which row/columns to filter.

1.

2.

4.

12.

GROOM TABLE requires space to make a complete copy of the table.

GROOM TABLE only operates on tables that include an ORGANIZE ON clause.

GROOM TABLE prevents nzload from adding data while groom is in progress.

GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress.

Plans

Disks

Tables

Queries

nzload will fail.

nzload automatically continues without user intervention.

nzload must be stopped and resumed by the user from the last check point.

nzload automatically restarts but the user must remove the allowReplay option.

SUM ()

GROUP BY

ORDER BY

OUTER JOIN

Materialized views can contain aggregates.

Materialized views can contain a HAVING clause.

Materialized views can contain a WHERE clause.

Materialized views can contain an ORDER BY clause.

Materialized views can reference only onebase table in the FROM clause.

Disk to FPGA to Host to User.

Disk to FPGA to S-Blade to User.

Disk to Host to S-Bladeto FPGA to User.

Disk to FPGA to S-Blade to Host to User.

The user account is provided super-user privileges.

The user account exists in the LDAP authentication server.

The user account password is at least 8 characters in length.

The user account iscreated on the active and standby server.

Queries with no joins.

Queries returning only one row in the result set.

SQL statements less than 255 characters in length.

Queries with a runtime estimation of less than 2 seconds.

It includes a date portion.

It includes a timezone offset.

The value is reevaluated each time the row is selected.

The value is initially assigned when the row is first created.

High Availability

Load Balancing

High Concurrency

Work Load Management