IBM IBM Certifications C2090-616 Questions & Answers

• Question 21:

  Which of the following is TRUE about DB2 OLAP functions?

  A. They return scalar values and not array values

  B. There are no DB2 monitor elements specific to OLAP functions

  C. OLAP functions are not supported in a common table expression (CTE)

  D. OLAP aggregation functions are not supported with column organized tables

  Correct Answer: C

• Question 22:

  Which method for restricting data access relies on security labels and security policies to control what data a user can access?

  A. Authentication

  B. Authorities and privileges

  C. Label-based access control

  D. Row and column access control

  Correct Answer: C

• Question 23:

  Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?

  A. Cloudant

  B. DB2 on Cloud

  C. dashDB for analytics

  D. dashDB for transactions

  Correct Answer: B

• Question 24:

  DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

  A. Oracle

  B. Sybase

  C. Netezza

  D. MongoDB

  E. Microsoft SQL Server

  Correct Answer: AB

• Question 25:

  Consider the following SQL statement:

  SELECT workdept, empno, lastname, salary,

  RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary

  FROM employee

  ORDER BY workdept, lastname

  What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?

  A. It ranks the rows in each WORKDEPT by SALARY.

  B. It groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY.

  C. It generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY.

  D. It tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY.

  Correct Answer: B

• Question 26:

  Which of the following features can provide significant benefits in storage savings, performance of analytic workloads, and time to value?

  A. pureScale

  B. auto reorg

  C. BLU acceleration

  D. Self tuning memory manager

  Correct Answer: C

• Question 27:

  Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?

  A. DB2 HADR

  B. DB2 pureScale

  C. DB2 Express-C

  D. DS2 Database Partitioning Feature

  Correct Answer: B

• Question 28:

  Consider the following sequence of events:

  Eddie grants SELECT WITH GRANT OPTION privilege to Mike.

  Mike grants SELECT privilege to Jeff.

  Eddie revokes SELECT privilege from Mike.

  What will happen to Jeff's SELECT privilege?

  A. Jeff's SELECT privilege will be revoked

  B. Jeff's SELECT privilege will be retained

  C. Jeff's SELECT privilege will be retained only if he has ACCESSCTRL authority

  D. Jeff's SELECT privilege will be retained only if Eddie has ACCESSCTRL authority

  Correct Answer: A

• Question 29:

  Which of the following statements regarding locking is TRUE?

  A. The same lock modes apply to tables, rows, or blocks

  B. Lock conversion can take place implicitly as a query executes

  C. Changing the mode of a lock that is already held is called lock escalation

  D. Lock conversion is not necessary if an X lock is required and an S or U lock is currently held

  Correct Answer: B

• Question 30:

  BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

  A. Direct Standard Edition

  B. Enterprise Server Edition

  C. Workgroup Server Edition

  D. DB2 Direct Advanced Edition

  E. Advanced Enterprise Server Edition

  Correct Answer: BC