IBM P2090-050 - IBM PureData System for Analytics Technical Mastery Test v1 Exam
Page: 3 / 27
Total 131 questions
Question #11 (Topic: Topic 1)
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.
Answer: C,E
Question #12 (Topic: Topic 1)
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).
Answer: D
Question #13 (Topic: Topic 1)
Which component failure does NOT trigger a HardwareServiceRequested event?
A. Fan
B. Disk
C. Host
D. S-Blade
Answer: C
Question #14 (Topic: Topic 1)
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.
Answer: C
Question #15 (Topic: Topic 1)
The query history data collected DOES NOT provide insight to which of the type of
performance and behavior questions?
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.
Answer: D
