P2090-047 Online Practice Questions and Answers

When loading a local ASCII file into table via an external table, where can the SQL be submitted?

A. From a User Defined Function.

B. From a JDBC application networked to the system.

C. From nzsql on an AIX machine networked to the system.

D. From nzsql on Microsoft Windows networked to the system.

If 'admin' user is running a query, what percentage of resources are available when Guaranteed Resource Allocation (GRA) is Enabled?

A. The maximum GRA assigned to the ADMIN group.

B. The maximum GRA assigned to the PUBLIC group.

C. 100% of the resources while other resource groups are active.

D. Typically half of the resources while other resource groups are active.

Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?

A. Bypasses the host.

B. Flows through the host.

C. Compressed on the host.

D. Uncompressed on the host.

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.

Which attribute CANNOT be defined for both users and groups?

A. Row set limit.

B. Default priority.

C. Query time out.

D. Password expiration.

Which clause CANNOT be used with a CREATE VIEW statement?

A. SUM ()

B. GROUP BY

C. ORDER BY

D. OUTER JOIN

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

A. The load can be configured to automatically continue to load 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.

If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?

A. A maximum of 20% of resources when other users are on the system.

B. A maximum of 50% of resources when other users are on the system.

C. A maximum of 80% of resources when no other users are on the system.

D. A maximum of 100% of resources when no other users are on the system.

When is the ToplogyImbalance event triggered?

A. When a SAS switch has failed.

B. When the path the path between an S-Blade and its disks has failed.

C. When a disk enclosure's voltage sensor is reading outside the nominal range.

D. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).

What are two considerations for usage of materialized views? (Choose two)

A. Materialized views are not supported.

B. Materialized views are logical entities.

C. Materialized views may improve query performance.

D. Materialized views are the same as database views.

E. Materialized views are considered for usage by the Optimizer.