IBM Information Management P2090-047 시험준비를 하고 계시다면 Pass4Test에서 출시한  IBM Information Management P2090-047 덤프를 제일 먼저 추천해드리고 싶습니다. Pass4Test제품은 여러분들이 제일 간편한 방법으로 시험에서 고득점을 받을수 있도록 도와드리는 시험동반자입니다. IBM Information Management P2090-047 시험패스는Pass4Test제품으로 고고고!

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

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 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.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 GroupA.
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.
Answer: C

NO.6 To create a database table, at a minimum, what must be specified?
A. column name and data type.
B. column name, data type and primary key.
C. column name, data type and default constraint.
D. column name, data type and distribute on clause.
Answer: A

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