IBM PureData System for Transactions Technical Mastery Test v1 試験
Question No : 1
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 : 2
Which nzload operation statement is correct?
Question No : 3
Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?
Question No : 4
Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?
Question No : 5
Which statement is true about the groom feature?
Question No : 6
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 : 7
Which CREATE DATABASE attributes are required?
Question No : 8
The PureData System for Analytics implements which level of transaction isolation?
Question No : 9
What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)
A. The views on TableA.
B. The privileges on TableA.
C. The distribution key of TableB.
D. The materialized views on TableB.
E. The order of the data stored in TableB.
Question No : 10
Which condition will interrupt a query running on a fully operational PureData System for Analytics?
Question No : 11
On which component(s) does the UDX run?
Question No : 12
Which command is used to abort a user's SQL transaction?
Question No : 13
Which command is used to display operational statistics about system capacity, faults, and performance?
Question No : 14
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.
Question No : 15
Why is table skew important to manage?