IBM Information Management P2090-047시험은 IT인증시험과목중 가장 인기있는 시험입니다. Pass4Test에서는 IBM Information Management P2090-047시험에 대비한 공부가이드를 발췌하여 IT인사들의 시험공부 고민을 덜어드립니다. Pass4Test에서 발췌한 IBM Information Management P2090-047덤프는 실제시험의 모든 범위를 커버하고 있고 모든 시험유형이 포함되어 있어 시험준비 공부의 완벽한 선택입니다.

NO.1 TableA is currently being accessed in a number of long running queries.
Which of the following

operations is NOT blocked, thus allowing the operation
to immediately proceed?

A. DROP TABLE TableA

B. ALTER TABLE TableA

C.
TRUNCATE TABLE TableA

D. GRANT SELECT ON TableA TO UserA

Answer:
D



NO.2 Which is NOT a way to check if the database is online?

A.
nzstate

B. cat /proc/database

C. nzsystem showState

D. nzsql -c "select
* from _v_system_info;"

Answer: B



NO.3 Using a date column as a
distribution key may distribute rows evenly across dataslices, why is

this a
poor choice of a distribution key?

A. Queries on the table will invoke
compression.

B. Queries on date range may involve processing skew.

C.
Queries on date range will utilize only host processing.

D. Queries on the
table will invoke compression on the date columns.

Answer: B



NO.4 Why
is generating statistics on a table important to query performance?

A. The
table statistics are used to facilitate disk space reclamation of deleted
rows.

B. The optimizer uses statistics to determine the optimal execution
plan for queries.

C. The Zone Map information cross references the table
statistics for each column to avoid scanning.

D. The Field Programmable Gate
Array (FPGA) utilizes the statistics to identify which row/columns
to

filter.

Answer: B



NO.5 When setting up a crontab entry, what
must be done on a PureData System for Analytics

server?

A. Create an
nzcron event.

B. nzstop/nzstart the database.

C. Stop and start the
appliance.

D. Add entry to active host and standby host.

Answer:
D



NO.6 The PureData System for Analytics implements which level of
transaction isolation?

A. Serializable

B. Committed read

C. Repeatable
read

D. Uncommitted read

Answer: A



NO.7 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



NO.8 Which statement is true regarding the compress
engine?

A. Data automatically gets compressed.

B. Columns to be compressed
must be defined.

C. The nzcompress utility must be run to compress the
table.

D. The nzcompress utility must be run to compress the
database.

Answer: A