1302 お客様のコメント
質問 1：
When setting up a crontab entry, what must be done on a PureData System for Analytics server?
A. Create an nzcron event.
B. Add entry to active host and standby host.
C. Stop and start the appliance.
D. nzstop/nzstart the database.
正解：B
質問 2：
Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?
A. Use a CTAS (Create Table as Select) SQL statement.
B. Use the COPY command.
C. Use nzbackup and nzrestore commands.
D. Use external tables and UNIX pipes.
正解：A
質問 3：
Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from the system?
A. nzhw
B. sar
C. nzsystem
D. nzinventory
正解：A
質問 4：
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. A 32-bit ODBC driver for the same UNIX environment.
D. A 64-bit ODBC driver for the same UNIX environment.
E. The system does not support 64 bit ODB
正解：B,D
質問 5：
You have created a group GroupA with JOB MAXIMUM of 4, which statement is true?
A. No more than 4 users can be assigned to Group
B. If users in GroupA submit more than 4 queries they will fail.
C. If users in GroupA submit more than 4 queries, then they will queue in order.
D. The job maximum cannot be less than the default concurrent query limit of 48.
正解：C
質問 6：
What is the host Linux file that must be modified to adjust optimizer settings permanently?
A. /nz/kit/log/sysmgr/sysmgr.log
B. /nz/kit/sys/initTopology.cfg
C. /nz/data/postgresql.conf
D. /nz/data/config/system.cfg
正解：C
When setting up a crontab entry, what must be done on a PureData System for Analytics server?
A. Create an nzcron event.
B. Add entry to active host and standby host.
C. Stop and start the appliance.
D. nzstop/nzstart the database.
正解：B
質問 2：
Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?
A. Use a CTAS (Create Table as Select) SQL statement.
B. Use the COPY command.
C. Use nzbackup and nzrestore commands.
D. Use external tables and UNIX pipes.
正解：A
質問 3：
Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from the system?
A. nzhw
B. sar
C. nzsystem
D. nzinventory
正解：A
質問 4：
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. A 32-bit ODBC driver for the same UNIX environment.
D. A 64-bit ODBC driver for the same UNIX environment.
E. The system does not support 64 bit ODB
正解：B,D
質問 5：
You have created a group GroupA with JOB MAXIMUM of 4, which statement is true?
A. No more than 4 users can be assigned to Group
B. If users in GroupA submit more than 4 queries they will fail.
C. If users in GroupA submit more than 4 queries, then they will queue in order.
D. The job maximum cannot be less than the default concurrent query limit of 48.
正解：C
質問 6：
What is the host Linux file that must be modified to adjust optimizer settings permanently?
A. /nz/kit/log/sysmgr/sysmgr.log
B. /nz/kit/sys/initTopology.cfg
C. /nz/data/postgresql.conf
D. /nz/data/config/system.cfg
正解：C
Uranishi -
P2090-047試験によく出題される、最重要用語や問題傾向を掲載しているから気に入ってます。