C2090-311 Real Exam Questions and Verified Answers

Question 1 Single choice

What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?

A
A warning is returned and no statistics are collected.
B
An error is returned and the table is placed in "load pending" state.
C
A statistics profile is automatically generated before the load is allowed to continue.
D
The Load utility uses the same RUNSTATS command options as those used during an automatic runstats operation.

Show answer and explanation

Correct answer: C

Question 2 Single choice

Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?

A
Row compression
B
Index compression
C
Backup compression
D
Temporary table compression

Show answer and explanation

Correct answer: C

Question 3 Single choice

Which statement about column-organized tables is true?

A
Databases with column-organized tables can be federated.
B
Schemas that include column-organized tables can be transported.
C
Sort memory can be automatically tuned in environments containing column-organized tables.
D
Queries that use the Currently Committed semantics can be used with column-organized tables.

Show answer and explanation

Correct answer: A

Question 4 Single choice

An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE.

If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:

RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET
PROFILE ONLY

Which command will create a statistics profile on the EMPLOYEE table?

A
RUNSTATS ON TABLE employee USE PROFILE
B
RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1
C
RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL
D
RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1
GENERATE PROFILE

Show answer and explanation

Correct answer: C

Question 5 Multiple choice

Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?

A
SYNC
B
ASYNC
C
NEARSYNC
D
SUPERSYNC
E
SUPERASYNC

Show answer and explanation

Correct answers: B, C

Question 6 Single choice

If the following commands are executed successfully:

Which SQL statement will fail?

A
Option A
B
Option B
C
Option C
D
Option D

Show answer and explanation

Correct answer: C

Question 7 Single choice

By default, the Optim Workload Table Organization Advisor will recommend converting row-organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?

A
15 percent
B
20 percent
C
25 percent
D
30 percent

Show answer and explanation

Correct answer: B

Question 8 Single choice

In which type of database are column-organized tables supported?

A
Partitioned databases.
B
DB2 pureScale databases.
C
Databases whose code set is Unicode.
D
Databases whose code set is Non-Unicode.

Show answer and explanation

Correct answer: A

Question 9 Single choice

What type of table can be converted into a column-organized table with the db2convert command?

A
A range partitioned table
B
A materialized query table
C
A row-organized user table
D
A declared global temporary table

Show answer and explanation

Correct answer: A

Question 10 Single choice

What will cause the creation of a column-organized table to fail?

A
Setting the database code set to UNICODE.
B
Setting the DFT_DEGREE database configuration parameter to ANY.
C
Setting the AUTO_RUNSTATS database configuration parameter to ON.
D
Setting the UTILJHEAP_SZ database configuration parameter to at least 1.000,000 pages.

Show answer and explanation

Correct answer: C