IBM P2090-050 - IBM PureData System for Analytics Technical Mastery Test v1 Exam
Page: 1 / 27
Total 131 questions
Question #1 (Topic: Topic 1)
A SELECT statement spends all its time returning 1 billion rows.What can be done to make
this faster?
this faster?
A. Use a CURSOR.
B. Use an EXTERNAL table.
C. Use the COPY command.
D. Increase the PreFetch Count.
Answer: B
Question #2 (Topic: Topic 1)
What function can nzbackup perform?
A. Back up pg.log files.
B. Back up TEMP tables.
C. Back up host data (catalog metadata).
D. Back up the data using the specified number of streams.
Answer: D
Question #3 (Topic: Topic 1)
nzbackup/nzrestore with the -user option has been replaced with which option to allow
multi-level security (MLS) information, suchas categories, cohorts, and levels to be backed
up/restored?
multi-level security (MLS) information, suchas categories, cohorts, and levels to be backed
up/restored?
A. -all
B. -mls
C. -users
D. -globals
Answer: D
Question #4 (Topic: Topic 1)
When loading a local ASCII file into table via an external table, where can the SQL be
submitted?
submitted?
A. From a User Defined Function.
B. From a JDBC application networked to the system.
C. From nzsql on an AIX machine networked to the system.
D. From nzsql on Microsoft Windows networked to the system.
Answer: B
Question #5 (Topic: Topic 1)
Which is NOT a function that can be performed bynzbackup?
A. Backup data
B. Backup schemas
C. Backup users/groups
D. Backup the /nz/data directory
Answer: D
