P2090-050 Online Practice Questions and Answers

Which is NOT a function that can be performed bynzbackup?

A. Backup data

B. Backup schemas

C. Backup users/groups

D. Backup the /nz/data directory

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.

Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?

A. AIX-HA

B. Linux-HA

C. SuSE-HA

D. Solaris-HA

Why is generating statistics on a table important to query performance?

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

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

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

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

When working with sequences, which statement will always be true?

A. One-up numbers are generated.

B. Integers (wholenumbers) are generated.

C. The first value generated is the number 1.

D. The sequence number assigned will be unique across all tables and databases.

Which statement is true about a simple load using external tables?

A. The load can be configured to automatically continue toload if the S-Blade resets or fails.

B. The load can be configured to automatically create a backup file of the table being loaded.

C. The load can be configured to automatically create a duplicate copy of the table being loaded.

D. The load can be configured to automatically remove duplicate rows from the table being loaded.

What is the state of the two hosts on a properly functional PureData System for Analytics Appliance?

A. Active - Active

B. Active - Stand by

C. Stand by -Backup

D. Stand by - Passive

The simplest query execution plan file must have the following minimum nodes?

A. ScanNode, RestrictNode, LimitNode, ReturnNode

B. ScanNode, RestrictNode, HashNode, ReturnNode

C. ScanNode, RestrictNode, ProjectNode, ReturnNode

D. ScanNode, RestrictNode, AggregateNode, ReturnNode

Where are the database log fileslocated?

A. /var/log

B. /usr/local

C. /nz/kit/log

D. The SYSTEM database

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.