IBM P2090-047 - IBM PureData System for Transactions Technical Mastery Test v1 Exam
Page: 2 / 27
Total 132 questions
Question #6 (Topic: Topic 1)
Which nzload operation statement is correct?
A. nzload must have a control file.
B. nzload performs singleton inserts.
C. nzload user must have CREATE EXTERNAL TABLE privilege.
D. nzload must be run from the PureData System for Analytics host.
Answer: C
Question #7 (Topic: Topic 1)
Name the CLI application that allows you to load data from ASCII files to database tables?
A. nzload
B. loadmgr
C. nzimport
D. nzrestore
Answer: A
Question #8 (Topic: Topic 1)
You have access to two databases, DEV and PROD. Currently you are connected to the
DEV database. Which operation is permitted?
DEV database. Which operation is permitted?
A. Delete from PROD..TableA
B. Select * from PROD..TableA
C. Truncate table PROD..TableA
D. Insert into PROD..TableA select * from DEV..TableB
Answer: B
Question #9 (Topic: Topic 1)
Which statement is true?
A. MATERIALIZED VIEWS can be run against EXTERNAL tables.
B. GENERATE STATISTICS can be run against EXTERNAL tables.
C. EXTERNAL table data is deleted using the SQL DELETE command.
D. EXTERNAL tables can be used to unload data to a Microsoft Windows directory.
Answer: D
Question #10 (Topic: Topic 1)
What is required to troubleshoot a query?
A. nzevents and the pg.log.
B. nzsql and the ODBC config.
C. nzinventory and the dbos.log.
D. nzdumpschema and the execution plan.
Answer: D
