Create Next App

Exam contains 131 questions

Page 8 of 22

Question 43 🔥

Which of the following statements is TRUE for an audit database in use?

Which database solution meets these requirements?

A. If the history data staging area exceeds its STORAGELIMIT value, the system continues to function normally

Highly voted

B. If the history data staging area exceeds its QUERYLIMIT value, the system stops, and the administrator must free up space and restart the system before users can resume activity

Highly voted

C. If the history data staging area exceeds its STORAGELIMIT value, the system stops, and the administrator must free up space and restart the system before users can resume activity

Highly voted

D. If the history data staging area exceeds its STORAGELIMIT value, the system stops, and the database security officer must free up space and restart the

Highly voted

Discussion of the question

Question 44 🔥

Which statement is TRUE regarding the NPS compression engine?

Which database solution meets these requirements?

A. Data automatically gets compressed

Highly voted

B. Columns to be compressed must be defined

Highly voted

C. The nzcompress utility must be run to compress the table

Highly voted

D. The nzcompress utility must be run to compress the database

Highly voted

Discussion of the question

Question 45 🔥

Short Query Bias is enabled by default. Which of the following is NOT an advantage of using Short Query Bias?

Which database solution meets these requirements?

A. It allows for all short queries to run in a guaranteed amount of time

Highly voted

B. The cost threshold is configurable with the hostschedSQBNominalSecs setting

Highly voted

C. When the standard scheduler is full, short queries can take advantage of additional resources reserved for them

Highly voted

D. It allows queries with a cost estimate less than or equal to the defined short query length to run on a busy system

Highly voted

Discussion of the question

Question 46 🔥

Which statement is TRUE about a simple load using external tables?

Which database solution meets these requirements?

A. The load can be configured to automatically create a backup file of the table being loaded

Highly voted

B. The load can be configured to automatically create a duplicate copy of the table being loaded

Highly voted

C. The load can be configured to automatically remove duplicate rows from the table being loaded

Highly voted

D. The load can be configured to automatically continue to load following an S-Blade reset or failure

Highly voted

Discussion of the question

Question 47 🔥

NPS syncs up which two folder structures between the active and passive hosts? (Select two)

Which database solution meets these requirements?

Discussion of the question

Question 48 🔥

Which statement regarding temporary tables is TRUE?

Which database solution meets these requirements?

A. They are limited to 1 terabyte in size

Highly voted

B. They may include a DISTRIBUTE ON clause

Highly voted

C. They are limited to 16 tables per user per database

Highly voted

D. They will be included in any nzbackup of the database

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_560

Exam contains 131 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us