ExamTopics Logo
Mail Us[email protected]
Menu
 

C2090-600 Actual Exam Questions

Last updated on Nov. 25, 2024.
Vendor:IBM
Exam Code:C2090-600
Exam Name:IBM DB2 11.1 DBA for LUW
Exam Questions:60
97% Passed the exam with this material
 

Topic 1 - Single Topic

Question #1 Topic 1

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named
SAMPLE to AUTOMATIC?

  • A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
  • B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
  • C. CONNECT TO sample; UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC IMMEDIATE; CONNECT RESET;
  • D. ATTACH TO db2inst1; UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;
Reveal Solution Hide Solution   Discussion   5

Correct Answer: C 🗳️

Question #2 Topic 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
Reveal Solution Hide Solution   Discussion   1

Correct Answer: AC 🗳️

Question #3 Topic 1

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 gets replicated across all partitions
Reveal Solution Hide Solution   Discussion   2

Correct Answer: D 🗳️
Reference:
http://www.idug.org/p/bl/et/blogaid=503

Question #4 Topic 1

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 days backup to take the longest time to complete?

  • A. Friday
  • B. Monday
  • C. Saturday
  • D. Wednesday
Reveal Solution Hide Solution   Discussion   3

Correct Answer: A 🗳️

file Viewing page 1 out of 15 pages.
Viewing questions 1-4 out of 60 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago