IBM C2090-600 Free Practice Questions

NEW QUESTION 1
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

• A. Catalog a storage access alias in the DB2 database
• B. Create an FTP account on IBM Softlayer Object Storage
• C. Use the DB2REMOTE parameter of the LOAD command
• D. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
• E. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Answer: AC

NEW QUESTION 2
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

• A. REORG TABLE sales INPLACE RESETDICTIONARY
• B. REORG TABLE sales INPLACE REBUILDDICTIONARY
• C. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
• D. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Answer: C

NEW QUESTION 3
If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?

• A. 1
• B. 2
• C. 3
• D. 4

Answer: D

NEW QUESTION 4
Which of the following statements about compression for BLU MPP tables is TRUE?

• A. Compression must be explicitly enabled for BLU MPP tables
• B. Compression requires decompression to evaluate partition joins
• C. Unique compression dictionaries are generated for each partition
• D. Each table has a single compression dictionary that getsreplicated across all partitions

Answer: D

NEW QUESTION 5
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

• A. The routine cannot contain comments.
• B. The routine must return either an integer or a null.
• C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
• D. The routine cannot contain argument lists or variable arguments (varargs).
• E. The routine must be generated with IBM Database Conversion Workbench (DCW).

Answer: BD

NEW QUESTION 6
Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

• A. Creating, using, or altering thresholds
• B. Granting, altering, or revoking workload privileges
• C. Using or altering the default service classes and workloads
• D. Creating service classes, service subclasses, and workloads
• E. Creating, activating, stopping or dropping workload management event monitors

Answer: BD

NEW QUESTION 7
Which operation can be performed with trusted context privileges that are acquired through a role?

• A. DML operations
• B. DDL operations
• C. Server maintenance operations
• D. Security administration operations

Answer: A

NEW QUESTION 8
Which statement about the db2move command is TRUE?

• A. The LOAD actions can be run from a client machine.
• B. Object ownership cannot be changed after a successful schema copy operation.
• C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
• D. Loading data into tables containing XML columns is only supported for the LOAD actions.

Answer: D

NEW QUESTION 9
Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

• A. It does not apply to table space backups.
• B. It specifies the compression mode to use for DB2 backups.
• C. It only has effect when appliedto a database in which all tables have been compressed.
• D. If set, backup images created with the BACKUP command are automatically compressed.

Answer: D

NEW QUESTION 10
Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

• A. db2val
• B. db2set
• C. db2look
• D. db2greg

Answer: B

NEW QUESTION 11
Which security mechanism is responsible for verifying that users are indeed who the claim to be?

• A. Authentication
• B. Roles and privileges
• C. Mandatory access control
• D. Discretionary access control

Answer: A

NEW QUESTION 12
Which of the following statements about audit policies is TRUE?

• A. Audit policy changes are applied instantly and affect all inflight transactions.
• B. Multiple audit policies can be associated with the same table at the same time.
• C. The audit policy applied to a table is automatically applied to any view based on that table.
• D. If a user is switched within a trusted connection, the applicable audit policies are re- evaluated for the new user without regard to audit policies for the original user.

Answer: D

NEW QUESTION 13
Which of the following are all valid types of trigger?

• A. AFTER, ATOMIC, BEFORE
• B. AFTER, ATOMIC, INSTEAD OF
• C. AFTER, BEFORE, INSTEAD OF
• D. ATOMIC, BEFORE, INSTEAD OF

Answer: C

NEW QUESTION 14
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

• A. XML
• B. BLOB
• C. CLOB
• D. VARCHAR
• E. DATETIME

Answer: DE

NEW QUESTION 15
If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

• A. Set the DB2COMM registry variable to DB2COMM=SSL
• B. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP
• C. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT
• D. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

Answer: B

NEW QUESTION 16
Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

• A. db2cluster –cfs –list –filesystem datafs
• B. db2cluster –cfs –display –filesystem datafs
• C. db2cluster –cfs –listconfig –filesystem datafs
• D. db2cluster –cfs –displayconfig –filesystem datafs

Answer: A

NEW QUESTION 17
The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time “pit”.
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?

• A. The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.
• B. Once the first QUIESCE completes, there are no runningtransactions involving tab1, but there might be running transactions against other tables in TS1.
• C. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE.There might besome uncommitted data in TS1.
• D. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLIN
• E. Thisensures none of the application changes were applied.

Answer: D

NEW QUESTION 18
Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

• A. SELECT tbsp_name, tbsp_utilization_percentFROM TABLE(sysproc.mon_tbsp_utilization()) AS tWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;
• B. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;
• C. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;
• D. SELECT tbsp_name, tbsp_utilization_percentFROM sysibmadm.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;

Answer: C

NEW QUESTION 19
When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

• A. The page size is too small.
• B. The extent size is too small.
• C. Low cardinality of the dimension(s) chosen.
• D. High cardinality of the dimension(s) chosen.

Answer: D

NEW QUESTION 20
Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

• A. Select from the ADMIN_GET_ENCRYPTION_INFO table function
• B. Run the db2ckbkp command and verify the compression settings
• C. Checkthe encrypted database parameter in database configuration
• D. Check ENCROPTS database configuration parameter for encryption options

Answer: D

NEW QUESTION 21
A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and deletes).
Sunday – Delta Monday – Incremental Tuesday – Delta Wednesday – Delta Thursday – Incremental Friday – Delta
Saturday – Full
Which day would you expect a RECOVER DATABASE following that day’s backup to take the longest time to complete?

• A. Friday
• B. Monday
• C. Saturday
• D. Wednesday

Answer: A

NEW QUESTION 22
......