Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

P2090-047 Questions and Answers

Note! Following P2090-047 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

P2090-047 Questions and Answers

Question # 6

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.

Full Access
Question # 7

What is the maximum number of columns you can choose as organizing keys for clustered base table?

A.

1

B.

2

C.

4

D.

8

Full Access
Question # 8

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

A.

Turn ODBC tracing ON.

B.

Issue "SELECT * FROM _V_SESSION;"

C.

Go to the query history within the Windows NzAdmin GUI tool.

D.

Run EXECUTION PLAN before the query has been submitted.

E.

Issue "SHOW PLANFILE <nn>;" after the query has been submitted.

Full Access
Question # 9

Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?

A.

Use the COPY command.

B.

Use external tables and UNIX pipes.

C.

Use nzbackup and nzrestore commands.

D.

Use a CTAS (Create Table as Select) SQL statement.

Full Access
Question # 10

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-Blade to FPGA to User.

D.

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

Full Access
Question # 11

Which statement is true?

A.

MATERIALIZED VIEWS can be run against EXTERNAL tables.

B.

GENERATE STATISTICS can be run against EXTERNAL tables.

C.

EXTERNAL table data is deleted using the SQL DELETE command.

D.

EXTERNAL tables can be used to unload data to a Microsoft Windows directory.

Full Access
Question # 12

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.

Full Access
Question # 13

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

Full Access
Question # 14

The PureData System for Analytics implements which level of transaction isolation?

A.

Serializable

B.

Committed read

C.

Repeatable read

D.

Uncommitted read

Full Access
Question # 15

What function can nzbackup perform?

A.

Back up pg.log files.

B.

Back up TEMP tables.

C.

Back up host data (catalog metadata).

D.

Back up the data using the specified number of streams.

Full Access
Question # 16

What is required to troubleshoot a query?

A.

nzevents and the pg.log.

B.

nzsql and the ODBC config.

C.

nzinventory and the dbos.log.

D.

nzdumpschema and the execution plan.

Full Access
Question # 17

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

Full Access
Question # 18

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

A.

Turn ODBC tracing ON.

B.

Issue "SELECT * FROM _V_SESSION;"

C.

Go to the query history within the Windows NzAdmin GUI tool.

D.

Run EXECUTION PLAN before the query has been submitted.

E.

Issue "SHOW PLANFILE <nn>;" after the query has been submitted.

Full Access
Question # 19

The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?

A.

The typical or most common types of queries.

B.

The longest and shortest running queries on the system.

C.

The queries submitted by specific users or groups of users.

D.

The rotational speed of the disk drives during query execution.

Full Access