632 お客様のコメント
質問 1：
Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?
A. Disk to FPGA to S-Blade to User.
B. Disk to FPGA to S-Blade to Host to User.
C. Disk to FPGA to Host to User.
D. Disk to Host to S-Blade to FPGA to User.
正解：B
質問 2：
What will prevent a GROOM TABLE command from running on a table named TableA?
A. If there are any materialized views on the table Table
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.
正解：A
質問 3：
Which statement about the GROOM TABLE feature is true?
A. GROOM TABLE requires space to make a complete copy of the table.
B. GROOM TABLE only operates on tables that include an ORGANIZE ON clause.
C. GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress.
D. GROOM TABLE prevents nzload from adding data while groom is in progress.
正解：C
質問 4：
How does the PureData System for Analytics utilize the distribution key to store records on disk?
A. System assigns records to a FPGA based on their distribution key value.
B. System assigns records to a Netezza Database Accelerator based on their distribution key value.
C. System assigns records to the host based on their distribution key value.
D. System assigns records to a logical data slice based on their distribution key value.
正解：D
質問 5：
What two conditions must be met to achieve a collocated join between two tables? (Choose two.)
A. Both join columns have the same name.
B. Both tables must be distributed on random.
C. Both join columns have identical data types.
D. Both tables have primary keys defined.
E. Both tables must be distributed on their join column.
正解：C,E
質問 6：
Which statement is NOT true regarding the nzload utility?
A. nzload runs on the PureData System for Analytics host.
B. nzload runs on windows.
C. nzload runs on SuSE Linux.
D. nzload blocks update/delete against the target table.
正解：D
質問 7：
A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.
A. Select distinct(datasliceid) from TableA;
B. Select distinct (ColumnA) from TableA;
C. Select datasliceid, count(*) from TableA group by 1 order by 2;
D. Select ColumnA, count(*) from TableA group by ColumnA order by 2;
正解：C
Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?
A. Disk to FPGA to S-Blade to User.
B. Disk to FPGA to S-Blade to Host to User.
C. Disk to FPGA to Host to User.
D. Disk to Host to S-Blade to FPGA to User.
正解：B
質問 2：
What will prevent a GROOM TABLE command from running on a table named TableA?
A. If there are any materialized views on the table Table
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.
正解：A
質問 3：
Which statement about the GROOM TABLE feature is true?
A. GROOM TABLE requires space to make a complete copy of the table.
B. GROOM TABLE only operates on tables that include an ORGANIZE ON clause.
C. GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress.
D. GROOM TABLE prevents nzload from adding data while groom is in progress.
正解：C
質問 4：
How does the PureData System for Analytics utilize the distribution key to store records on disk?
A. System assigns records to a FPGA based on their distribution key value.
B. System assigns records to a Netezza Database Accelerator based on their distribution key value.
C. System assigns records to the host based on their distribution key value.
D. System assigns records to a logical data slice based on their distribution key value.
正解：D
質問 5：
What two conditions must be met to achieve a collocated join between two tables? (Choose two.)
A. Both join columns have the same name.
B. Both tables must be distributed on random.
C. Both join columns have identical data types.
D. Both tables have primary keys defined.
E. Both tables must be distributed on their join column.
正解：C,E
質問 6：
Which statement is NOT true regarding the nzload utility?
A. nzload runs on the PureData System for Analytics host.
B. nzload runs on windows.
C. nzload runs on SuSE Linux.
D. nzload blocks update/delete against the target table.
正解：D
質問 7：
A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.
A. Select distinct(datasliceid) from TableA;
B. Select distinct (ColumnA) from TableA;
C. Select datasliceid, count(*) from TableA group by 1 order by 2;
D. Select ColumnA, count(*) from TableA group by ColumnA order by 2;
正解：C
宫本** -
たくさん問題を解いておきたい方にはおすすめできますね。出題範囲を100％カバーしている。Pass4TestのP2090-047は最強。友達にも勧めました。