What will prevent a GROOM TABLE command from running on a table named TableA?
A. If there are any materialized views on the table Table
B. If there are any active selects running against the table TableA.
C. If there are any active nzloads running against the table TableA.
D. If there are any active updates running against the table TableA.
正解:A
質問 2:
Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?
A. Uncompressed on the host.
B. Flows through the host.
C. Bypasses the host.
D. Compressed on the host.
正解:B
質問 3:
What is required to troubleshoot a query?
A. nzdumpschema and the execution plan.
B. nzinventory and the dbos.log.
C. nzevents and the pg.log.
D. nzsql and the ODBC config.
正解:A
質問 4:
Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?
A. Linux-HA
B. Solaris-HA
C. AIX-HA
D. SuSE-HA
正解:A
質問 5:
What must the Linux administrator ensure when creating a Linux user on the host?
A. The user account exists in the LDAP authentication server.
B. The user account password is at least 8 characters in length.
C. The user account is created on the active and standby server.
D. The user account is provided super-user privileges.
正解:C
質問 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:
When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)
A. UNIQUE
B. DEFAULT value
C. PRIMARY KEY
D. NULL
E. NOT NULL
正解:A,C
井原** -
問題集P2090-047を使って試験に合格しました。これで受かる気がしたっと思って受験して本当に受かりました。安心感もありますし、知識もしっかりと身につくと思います。