IBM PureData System for Analytics Technical Mastery Test v1 試験
Question No : 1
Given the following query: SELECT * FROM TableA, TableB WHERE TableA.c_custkey = TableB.o_custkey;
What type of join processing will occur when the query is executed?
A. Collocation hash join processing
B. Distributed hash join processing
C. Broadcast sort merge join processing
D. Replication sort merge join processing
Question No : 2
Which command is used to display operational statistics about system capacity, faults, and performance?
Question No : 3
You have created a group GroupA with JOB MAXIMUM of 4, which statement is true?
A. No more than 4 users can be assigned to GroupA.
B. If users in GroupA submit more than 4 queries they will fail.
C. If users in GroupA submit more than 4 queries, then they will queue in order.
D. The job maximum cannot be less than the default concurrent query limit of 48.
Question No : 4
What is required to troubleshoot a query?
Question No : 5
Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?
Question No : 6
When are zonemaps initially created for a table?
Question No : 7
nzbackup/nzrestore with the -user option has been replaced with which option to allow multi-level security (MLS) information, suchas categories, cohorts, and levels to be backed up/restored?
Question No : 8
Which nzload operation statement is correct?
Question No : 9
On which component(s) does the UDX run?
Question No : 10
Which is NOT a function that can be performed bynzbackup?
Question No : 11
TableA is currently being accessed in a number of long running queries.
Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?
Question No : 12
Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from the system?
Question No : 13
Which statement is true?
Question No : 14
Which is a function of the Linux-HA heartbeat?
Question No : 15
The PureData System for Analytics implements which level of transaction isolation?