P2090-047 Online Practice Questions and Answers

A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?

A. Use a CURSOR.

B. Use an EXTERNAL table.

C. Use the COPY command.

D. Increase the PreFetch Count.

You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

A. Delete from PROD..TableA

B. Select * from PROD..TableA

C. Truncate table PROD..TableA

D. Insert into PROD..TableA select * from DEV..TableB

Which component failure does NOT trigger a HardwareServiceRequested event?

A. Fan

B. Disk

C. Host

D. S-Blade

Which condition will NOT fail or restart a running query on a PureData System for Analytics Appliance?

A. Disk resets or fails.

B. Host resets or fails.

C. S-Blade resets or fails.

D. Snippet Processing Unit (SPU) resets or fails.

Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?

A. Use explain.

B. Use statistics.

C. Use pg.log file.

D. Set show_plan = true;

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.

What will occur when two tables are joined together and the data is NOT collocated?

A. No data movement is required.

B. A merge join operation will be performed.

C. A cluster based join method is performed.

D. Data is dynamically redistributed or broadcasted.

Which two statements are true about queries on the PureData System for Analytics Appliance? (Choose two.)

A. Queries are executed in parallel by the host.

B. Queries must be compressed before they can be executed.

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

D. Queries must be uncompressed by the user and executed in parallel by the host.

E. A query is compiled into a snippet which is executed across all available S-Blades.

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

A. nzstats

B. nzstate

C. nzshow

D. nzsystem

What will prevent a GROOM TABLE command from running on a table named TableA?

A. If there are any materialized views on the table TableA.

B. If there are any active selects running against the table TableA.

C. If there are any active nzloads running against the table TableA.

D. If there are any active updates running against the table TableA.

When a CREATE TABLE AS (CTAS) is performed on a table creating more than 1,000,000,000 rows, which statement is true?

A. Groom will be automatically invoked.

B. Primary key constraints will be checked.

C. Statistics will automatically be generated.

D. Materialized views will be automatically generated.

Which statement is true for database users and groups?

A. All users must belong to admin group.

B. Creation of users and groups is not allowed.

C. Users and groups are local and tied to a particular database.

D. Users and groups are global and not tied to a particular database.

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 function can nzrestore perform?

A. Restore TEMP tables.

B. Restore database triggers.

C. Rename tables during the restoration.

D. Return materialized views to their original state.

Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)

A. The number of rows in the table.

B. The column histogram statistics.

C. The number of NULLs in each column.

D. The number of unique values in each column.

E. The minimum and maximum column value information (excluding text columns).