IBM Certification IBM Db2 Database Administration 3

Question 1

What is the purpose of IBM Db2's 'Federation' capability?

Accepted Answer

Allowing Db2 to query data from remote, heterogeneous data sources as if they were local Db2 tables

Answer

Federating user identity across multiple LDAP systems

Answer

Combining multiple Db2 instances into a cluster

Answer

Federating backups across multiple storage tiers

Question 2

Which Db2 isolation level prevents dirty reads but allows non-repeatable reads and phantom rows?

Accepted Answer

Cursor Stability (CS)

Answer

Repeatable Read (RR)

Answer

Read Stability (RS)

Answer

Uncommitted Read (UR)

Question 3

What does the IBM Db2 'LOAD' utility offer that makes it faster than the 'IMPORT' utility?

Accepted Answer

LOAD writes data directly to database pages, bypassing SQL processing and logging for faster bulk data ingestion

Answer

LOAD uses SQL INSERT statements for compatibility

Answer

LOAD automatically creates indexes during loading

Answer

LOAD compresses data before writing it to disk

Question 4

In Db2, what is a 'schema' used for?

Accepted Answer

Providing a namespace to logically organize and group database objects like tables, views, and procedures

Answer

Defining the network topology for Db2 replication

Answer

Configuring buffer pool memory allocations

Answer

Defining physical storage containers for tablespaces

Question 5

Which IBM certification exam is designed for Db2 11.5 Database Administrators?

Accepted Answer

C1000-112 IBM Db2 11.5 DBA

Answer

C1000-010 IBM Security QRadar

Answer

C1000-085 IBM Watson Assistant

Answer

C1000-056 IBM Sterling Order Management

Question 6

What is the purpose of Db2's 'AUTOCONFIGURE' command?

Accepted Answer

To recommend and optionally apply optimal database and instance configuration parameter values based on system resources and workload

Answer

To automatically install Db2 patches

Answer

To automatically create missing indexes

Answer

To autoconfigure network port settings for Db2