IBM PureData System for Transactions Technical Mastery Test v1 P2090-047 Prüfungsfragen mit Lösungen:
1. What should be considered when you are asked to select the distribution key columns for a very large fact table?
A) Columns that contain few unique values.
B) Columns that contain many nulls.
C) As many columns as possible.
D) Columns used to join to other large tables.
2. Which CREATE DATABASE attributes are required?
A) The database name and the table space name.
B) The database name.
C) The database name and the temporary table space name.
D) The database name and the redo log file name.
3. OLE-DB based applications on UNIX requires which PureData System for Analytics software?
A) Install the OLE-DB driver for UNIX.
B) Install the ODBC driver for UNIX.
C) OLE-DB is not supported on UNIX.
D) Install the JDBC driver for UNIX.
4. When a poor choice of distribution key is made, what is the impact to storage allocation?
A) Data is likely to be unevenly spread across the system.
B) Data is likely to generate duplicate sequence values.
C) Data is likely to negatively affect compression.
D) Data is likely to negatively affect views.
5. Which User Defined Function (UDF) statement is true?
A) It accepts zero or more input values and produces one or more output values.
B) it accepts exactly one input value and produces one or more output values.
C) It accepts zero or more input values but produces one output value.
D) It accepts exactly one input value and produces exactly one output value.
Fragen und Antworten:
| 1. Frage Antwort: D | 2. Frage Antwort: B | 3. Frage Antwort: C | 4. Frage Antwort: A | 5. Frage Antwort: C |
1088 Kundenbewertungen
