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 external tables and UNIX pipes.
C. Use nzbackup and nzrestore commands.
D. Use a CTAS (Create Table as Select) SQL statement.
Which statement is NOT true regarding the nzload utility?
A. nzload runs on windows.
B. nzload runs on SuSE Linux.
C. nzload blocks update/delete against the target table.
D. nzload runs on the PureData System for Analytics host.
When unloading data via an external table, where can the SQL be submitted?
A. From a User Defined Function.
B. From nzsql on an AIX machine networked to the system.
C. From nzsql on Microsoft Windows networked to the system.
D. From an ODBC application on Windows networked to the system.
Which file format is NOT supported by the nzload utility?
A. ASCII delimited format.
B. Fixed length record format.
C. gzip compressed file format.
D. PureData System for Analytics compressed file format.
Which statement is NOT true?
A. nzrestore can restore selected tables.
B. nzrestore can restore from an nzbackup UNIX pipe.
C. nzrestore can restore to a different database from the backup database.
D. nzrestore can restore to a different PureData System for Analytics server from the backup server.
OLE-DB based applications requires which PureData System for Analytics software?
A. Install the JDBC driver for windows.
B. Install the ODBC driver for windows.
C. Install the OLE-DB Driver for windows.
D. Install the nzload bulk load for windows.
Which statement regarding temporary tables is true?
A. They are limited to 1 terabyte in size.
B. They may include a DISTRIBUTE ON clause.
C. They are limited to 16 per user per database.
D. They will be included in any nzbackup of the database.
What is the fastest join utilized by PureData System for Analytics?
A. Hash join.
B. Merge join.
C. Expression join.
D. Cross product join.
In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)
A. nzsql
B. An ODBC driver manager.
C. The system does not support 64 bit ODBC.
D. A 64-bit ODBC driver for the same UNIX environment.
E. A 32-bit ODBC driver for the same UNIX environment.
What is true about queries submitted on the PureData System for Analytics Appliance?
A. Queries are uncompressed by the host and sent to the user.
B. Queries are consolidated by the host and executed together in one block.
C. Queries are compiled by the host and executed in parallel by the S-Blades.
D. Queries are compressed by the host and optimized for parallel processing.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-047 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.