P2090-050 Online Practice Questions and Answers

Which nzload operation statement is correct?

A. nzload must have a control file.

B. nzload performs singleton inserts.

C. nzload user must have CREATE EXTERNAL TABLE privilege.

D. nzload must be run from the PureData System for Analytics host.

Which statement describesadministrative privileges?

A. Provides audit functionality for the database.

B. Manages resource allocations for concurrent processing.

C. Gives permission to execute global operations and to create objects.

D. Gives additional storage to select members of the administrator group.

What CANNOT be measured and managed by system views?

A. Temperature values on S-blade.

B. Status of the host attached storage.

C. Power supply status for each frame.

D. Resource group utilization and history.

When a temporary table is created, where will the data be stored?

A. On the host under the /nz/tmp directory.

B. On the S-Blades under the data partition.

C. Held in physical memory on the S-Blades.

D. On the S-Blades under the swap partition.

Where are the database log files located?

A. /var/log

B. /usr/local

C. /nz/kit/log

D. The SYSTEM database

What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

A. root

B. public

C. admin

D. system

Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?

A. Queries on the table will invoke compression.

B. Queries on date range may involve processing skew.

C. Queries on date range will utilize only host processing.

D. Queries on the table will invoke compression on the date columns.

You havecreated a group GroupA with JOB MAXIMUM of 4, which statement is true?

A. No more than 4 users can be assigned to GroupA.

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

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

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

Which procedural logic is NOT supported by NZPLSQL?

A. Scrollable Cursors

B. Looping (while, for)

C. Conditionals (if/else)

D. Returning a scalar result or a result set

Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?

A. Disk to FPGA to Host to User.

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

C. Disk to Host to S-Bladeto FPGA to User.

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

What function can nzrestore perform?

A. Restore TEMP tables.

B. Restore database triggers.

C. Rename tables during therestoration.

D. Return materialized views to their original state.

With LDAP enabled, which of the followingis verified against an LDAP server?

A. Database user ADMIN privileges.

B. Database user SELECT privileges.

C. Database user GROUP authentication.

D. Database user password authentication.

What must the Linux administrator ensure when creating a Linux user on the host?

A. The user account is provided super-user privileges.

B. The user account exists in the LDAP authentication server.

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

D. The user account iscreated on the active and standby server.

Which is NOT a function of the FieldProgrammable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?

A. Projects

B. Restricts

C. Aggregates

D. Decompresses

How does the PureData System for Analytics utilize the distribution key to store records on disk?

A. System assigns records to a FPGA based on their distribution key value.

B. System assigns records to the host based on their distribution key value.

C. System assigns records to a logical data slicebased on their distribution key value.

D. System assigns records to a Netezza Database Accelerator based on their distribution key value.