IBM PureData System for Transactions Technical Mastery Test v1 認定 P2090-047 試験問題:
1. What CANNOT be measured and managed by system views?
A) Status of the host attached storage.
B) Temperature values on S-blade.
C) Power supply status for each frame.
D) Resource group utilization and history.
2. Which is NOT a function of the Field Programmable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?
A) Aggregates
B) Restricts
C) Projects
D) Decompresses
3. What should be considered when you are asked to select the distribution key columns for a very large fact table?
A) Columns used to join to other large tables.
B) As many columns as possible.
C) Columns that contain many nulls.
D) Columns that contain few unique values.
4. What two conditions must be met to achieve a collocated join between two tables? (Choose two.)
A) Both tables have primary keys defined.
B) Both join columns have identical data types.
C) Both join columns have the same name.
D) Both tables must be distributed on random.
E) Both tables must be distributed on their join column.
5. In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)
A) The nzsystem command was used to set the QUERYTIMEOUT to two minutes.
B) The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.
C) The runaway query event was configured for two minutes.
D) The pg.log file was configured for two minutes.
E) The runaway query event was enabled.
質問と回答:
質問 # 1 正解: A | 質問 # 2 正解: A | 質問 # 3 正解: A | 質問 # 4 正解: B、E | 質問 # 5 正解: B、E |