P2090-050 Online Practice Questions and Answers

Which component failure does NOT trigger a HardwareServiceRequested event?

A. Fan

B. Disk

C. Host

D. S-Blade

Which command is usedto display operational statistics about system capacity, faults, and performance?

A. nzstats

B. nzstate

C. nzshow

D. nzsystem

Which CREATE DATABASE attributes are required?

A. The database name.

B. The database name and the redo log file name.

C. Thedatabase name and the table space name.

D. The database name and the temporary table space name.

Which of the following is a valid datatype definition?

A. TEXT

B. CLOB

C. CHAR(64000)

D. NUMERIC(1,38)

Columns in a table may be zonemapped. How are those columns chosen?

A. They are automatically selected by the system.

B. They are based on the same columns as the table's distribution key.

C. They are added via the ALTER TABLE ADD INDEX(column_name) statement.

D. They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement.

nzload is invoked with the "allowReplay" option enabled. While the PureData System for Analytics Appliance changes state from online to pausing then to online, which statement is true about the nzload process on the Appliance?

A. nzload will fail.

B. nzload automatically continues without user intervention.

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

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

What is true about queries submitted on the PureData System for Analytics Appliance?

A. Queries are uncompressed by the host and sent to the user.

B. Queries are consolidated by the host and executed together in one block.

C. Queries are compiled by the host and executed in parallel by the S-Blades.

D. Queries are compressed by the host and optimized for parallel processing.

What is the fastest join utilized by PureData System for Analytics?

A. Hash join.

B. Merge join.

C. Expression join.

D. Cross product join.

When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query history NOT collect data?

A. Plans

B. Disks

C. Tables

D. Queries

When a poor choice of distribution key is made, what is the impact to storage allocation?

A. Data is likely to negatively affect views.

B. Data is likely to negatively affect compression.

C. Data is likely to generate duplicate sequence values.

D. Data is likely to be unevenly spread across the system.