Ensurepass

QUESTION 1

Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?

 

A.

Queries on the table will invoke compression.

B.

Queries on date range may involve processing skew.

C.

Queries on date range will utilize only host processing.

D.

Queries on the table will invoke compression on the date columns.

 

Correct Answer: B

 

 

QUESTION 2

What is the host Linux file that must be modified to adjust optimizer settings permanently?

 

A.

/nz/data/postgresql.conf

B.

/nz/data/config/system.cfg

C.

/nz/kit/sys/initTopology.cfg

D.

/nz/kit/log/sysmgr/sysmgr.log

 

Correct Answer: A

 

 

QUESTION 3

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.

 

Correct Answer: CE

 

 

QUESTION 4

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.

 

Correct Answer: C

 

 

QUESTION 5

Which two statements are trueabout 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.

 

Correct Answer: CE

 

 

QUESTION 6

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;

 

Correct Answer: A

 

 

QUESTION 7

When setting up a crontab entry, what must be done on a PureData Systemfor Analytics server?

 

A.

Create an nzcron event.

B.

nzstop/nzstart the database.

C.

Stop and start the appliance.

D.

Add entry to active host and standby host.

 

Correct Answer: D

 

 

QUESTION 8

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.

 

Correct Answer: B

 

 

QUESTION 9

Which condition will interrupt a query running on a fully operational PureDataSystem for Analytics?

 

A.

One fan fails.

B.

One disk fails.

C.

Active host fails.

D.

One power supply fails.

Correct Answer: C

 

 

QUESTION 10

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 ADMINgroup.

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.

 

Correct Answer: D

 

Free VCE & PDF File for IBM P2090-050 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

Comments are closed.