最新なIBM P2090-050問題集（131題）、真実試験の問題を全部にカバー！

質問 1：
Which command is used to abort a user's SQL transaction?
A. kill
B. nzsession
C. abort
D. nzstop
正解：B

質問 2：
Which User Defined Function (UDF)statement is true?
A. It accepts exactly one input value and produces exactly one output value.
B. It accepts zero or more input values and produces one or more output values.
C. It accepts zero or more input values but produces one output value.
D. it accepts exactly one input value and produces one or more output values.
正解：C

質問 3：
When is the ToplogyImbalance event triggered?
A. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).
B. When a disk enclosure's voltage sensor is reading outside the nominal range.
C. When a SAS switch has failed.
D. When the path the path between an S-Blade and its disks has failed.
正解：A

質問 4：
Which condition will interrupt a query running on a fully operational PureDataSystem for Analytics?
A. One disk fails.
B. One power supply fails.
C. Active host fails.
D. One fan fails.
正解：C

質問 5：
If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?
A. An nzbackup of the database in which TableA resides
B. A SELECT from TableA
C. A DELETE from TableA
D. A TRUNCATE of TableA
正解：D

質問 6：
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

質問 7：
What are two considerations for usage of materialized views? (Choose two)
A. Materialized views may improve query performance.
B. Materialized views are logical entities.
C. Materialized views are the same as database views.
D. Materialized views are not supported.
E. Materialized views are considered for usage by the Optimizer.
正解：A,E

質問 8：
When setting up a crontab entry, what must be done on a PureData Systemfor 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

質問 9：
In order to set a runaway query event totrigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)
A. The pg.log file was configured for two minutes.
B. The nzsystem command was used to set the QUERYTIMEOUT to two minutes.
C. The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.
D. The runaway query event was enabled.
E. The runaway query event was configured for two minutes.
正解：C,D