We're so confident of our products that we provide no hassle product exchange.
IBM PureData System for Analytics Technical Mastery Test v1 Sample Questions:
1. Which statement about theGROOM TABLE feature is true?
A) GROOM TABLE only operates on tables that include an ORGANIZE ON clause.
B) GROOM TABLE prevents nzload from adding data while groom is in progress.
C) GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress.
D) GROOM TABLE requires space to make a complete copy of the table.
2. A SELECT statement spends all its time returning 1 billion rows.What can be done to make this faster?
A) Use the COPY command.
B) Use a CURSOR.
C) Increase the PreFetch Count.
D) Use an EXTERNAL table.
3. All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?
A) USERS
B) GUEST
C) GLOBAL
D) PUBLIC
4. Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?
A) Use the COPY command.
B) Use nzbackup and nzrestore commands.
C) Use external tables and UNIX pipes.
D) Use a CTAS (Create Table as Select) SQL statement.
5. On which component(s) does the UDX run?
A) The host, the S-blades and theFPGAs.
B) The S-blades and the FPGAs only.
C) The host and the S-blades only.
D) The host only.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: D | Question # 3 Answer: D | Question # 4 Answer: D | Question # 5 Answer: C |
By Hugh
