100% Pass Your C2090-600 Exam Dumps at First Attempt with Prep4King [Q28-Q52]

100% Pass Your C2090-600 Exam Dumps at First Attempt with Prep4King

Penetration testers simulate C2090-600 exam PDF

NEW QUESTION 28
Which statement regarding event monitors is TRUE?

• A. Event monitors are used to obtain information about how a database system looks at a specific point in time
• B. Event monitors must always be started manually after activating a database
• C. Event monitor data can be reviewed while the event monitor is active
• D. Event monitors must write data to .EVT files before the data can be loaded into database tables

Answer: B

Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/ doc/r0000915.html

 

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

• A. 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.
• B. Audit policy changes are applied instantly and affect all inflight transactions.
• C. Multiple audit policies can be associated with the same table at the same time.
• D. The audit policy applied to a table is automatically applied to any view based on that table.

Answer: A

Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSPT3X_4.2.0/
com.ibm.swg.im.infosphere.biginsights.commsql.doc/doc/r0050609.html (note, 6th bullet)

 

NEW QUESTION 30
What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?

• A. NONE
• B. LOCAL
• C. GLOBAL
• D. DOMAIN

Answer: C

Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/t0006033.html

 

NEW QUESTION 31
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 be generated with IBM Database Conversion Workbench (DCW).
• C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
• D. The routine must return either an integer or a null.
• E. The routine cannot contain argument lists or variable arguments (varargs).

Answer: D,E

 

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

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

Answer: A

Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/
com.ibm.db2.luw.admin.sec.doc/doc/c0050517.html (see note, second bullet)

 

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

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

Answer: B

 

NEW QUESTION 34
Where does the DB2 Problem Determination tool (db2pd) get information from?

• A. DB2memory sets
• B. Monitoring table functions
• C. the db2diag.log file
• D. A set of pre-defined event monitors

Answer: A

 

NEW QUESTION 35
What is the result of the following scenario?

• A. The row is updated to (2, NULL)
• B. The row is updated to (2, 110.00)
• C. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL
• D. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed

Answer: B

 

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

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

Answer: A,E

 

NEW QUESTION 37
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?

• A. db2advis
• B. db21ook
• C. db2exfmt
• D. db2expln

Answer: D

 

NEW QUESTION 38
Which statement about Data Server Manager (DSM) is TRUE?

• A. DSM cannot be used for database administration
• B. DSM can be used for configuration management of DB2 Data Server drivers
• C. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue
• D. DSM can be used for reviewing audit trails

Answer: C

Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1503db2-data-server/ index.html (conclusion)

 

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

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

Answer: A

 

NEW QUESTION 40
Which of the following enables the user to connect to the HADR standby database and execute select statements?

• A. HADR_SPOOL_LIMIT
• B. DB2_HADR_ROS
• C. DB2_HADR_PEER_WAIT_LIMIT
• D. DB2_HADR_SOSNDBUF

Answer: B

Explanation:
Explanation/Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1205hadrstandby/

 

NEW QUESTION 41
On Linux and Unix systems, which of the following will set the DB2_FMP COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

• A. As the db2 instance owner (db2inst1) execute the command:
  db2set -i DB2_FMP COMM_HEAPSZ=256000
• B. As the db2 instance owner (db2inst1) execute the command:
  exportDB2_FMP COMM_HEAPSZ=256000
• C. Add to the following line to the user profile (db2inst1): DB2_FMP COMM_HEAPSZ=256000
• D. As the db2 instance owner (db2inst1) execute the command:
  db2set -i db2inst1 DB2_FMP COMM_HEAPSZ=256000

Answer: A

 

NEW QUESTION 42
A table named MYTABLE contains an XML column and an XML storage object dictionary already exists.
What is the effect of enabling compression and then running the command REORG TABLE mytable
KEEPDICTIONARY?

• A. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.
• B. All data, both new and existing, will be compressed.
• C. Only new or updated data for XML columns will be compressed.
• D. New and existing XML columns will be compressed but other columns remain unchanged.

Answer: A

 

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

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

Answer: B

Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.sec.doc/doc/c0005435.html

 

NEW QUESTION 44
If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?

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

Answer: C

 

NEW QUESTION 45
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. High cardinality of the dimension(s) chosen.
• C. The extent size is too small.
• D. Low cardinality of the dimension(s) chosen.

Answer: B

 

NEW QUESTION 46
An HADR environment has two standby databases - one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?

• A. NEARSYNC
• B. ASYNC
• C. SUPERASYNC
• D. SYNC

Answer: C

Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/
com.ibm.db2.luw.admin.ha.doc/doc/c0059994.html

 

NEW QUESTION 47
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. Saturday
• B. Friday
• C. Monday
• D. Wednesday

Answer: B

 

NEW QUESTION 48
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

• A. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
• B. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
• C. After termination all the back-end processes using TERMINATE command
• D. When the registry variableDB2_AUTORECLAIMSPACE=YES

Answer: A

 

NEW QUESTION 49
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sgl ON '/datal';
CREATE STOGROUP ibmstogroup ON '/data2';
CREATE STOGROUP sg2 ON '/data3';
Which storage group is the default storage group for the TESTDB database?

• A. SG2
• B. IBM STOGROUP
• C. IBM DEFAULTISG
• D. SG1

Answer: B

 

NEW QUESTION 50
What is an advantage of using range partitioned tables?

• A. Table data is automatically and continuously clustered, requiring minimal reorganization
• B. Ability to run utilities against the partitions in parallel
• C. Increased query performance through data partition elimination
• D. Block indexes are much smaller than RID indexes, providing better performance

Answer: C

Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0605ahuja2/#query

 

NEW QUESTION 51
What levels of authority are needed to create a storage group? (Choose two.)

• A. SQLADM
• B. SYSMAINT
• C. SYSADM
• D. SYSCTRL
• E. DBADM

Answer: C,D

Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/ doc/r0058606.html

 

NEW QUESTION 52
......

All C2090-600 Dumps and Training Courses: https://www.prep4king.com/C2090-600-exam-prep-material.html