ExamTopics Logo
Mail Us[email protected]
Menu
 

C2090-560 Actual Exam Questions

Last updated on Dec. 15, 2024.
Vendor:IBM
Exam Code:C2090-560
Exam Name:PureData System for Analytics v7.1
Exam Questions:134
97% Passed the exam with this material
 

Topic 1 - Single Topic

Question #1 Topic 1

Which statement regarding temporary tables is TRUE?

  • A. They are limited to 1 terabyte in size
  • B. They may include a DISTRIBUTE ON clause
  • C. They are limited to 16 tables per user per database
  • D. They will be included in any nzbackup of the database
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #2 Topic 1

Which procedural logic is NOT supported by NZPLSQL?

  • A. Scrollable cursors
  • B. Looping (while, for)
  • C. Conditionals (if, else)
  • D. Returning a scalar result or result set
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #3 Topic 1

Which of the following properties about the rowid column is FALSE?

  • A. At installation the initial rowid value is 100,000
  • B. Rowid values are sequential across each table
  • C. The system automatically assigns values for the column
  • D. The host assigns a range of sequential rowids to each SPU
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #4 Topic 1

Columns in a table may be zone mapped. How are those columns chosen?

  • A. They are automatically selected by the system
  • B. They are always based on the samecolumns as the table's distribution key
  • C. They are added via the ALTER TABLE ADD INDEX(column_name) statement
  • D. They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

file Viewing page 1 out of 34 pages.
Viewing questions 1-4 out of 134 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