Latest Certified Success Dumps Download

P2090-018 Latest Exam (Nov 2017)

[Free] 2017(Nov) Latesttests Examcollection IBM P2090-018 Dumps with VCE and PDF 1-10

December 2, 2017

2017 Nov IBM Official New Released P2090-018
100% Free Download! 100% Pass Guaranteed!

IBM Information Management DB2 10 Technical Mastery Test v3

Question No: 1

What is the DB2 Design Advisor?

  1. The DB2 Design Advisor is a tool that automatically analyzes your running database and continuously makes changes to your database to give it peak performance.

  2. The DB2 Design Advisor is a help desk facility that is available to all licensed DB2 owners that have paid their maintenance agreements with IBM. The tool is a web site that guides you through the design of your database, with the DBA responding to a series of questions. It produces a database schema that allows for quick database creation.

  3. The DB2 Design Advisor is a tool that can help you improve your database workload performance. Given a set of SQL statements in a workload, the Design Advisor can generate recommendations to improve the performance of SQL execution.

  4. The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.

Answer: C

Question No: 2

Which of the following options best describes the differences between Label Based Access Control (LBAC) and Row and Column Access Control (RCAC)?

  1. RCAC is a fixed label security model designed for the US government while LBAC is a general purpose security model best suited for commercial customers.

  2. RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

  3. LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and columns.

  4. With RCAC users do not get an error when accessing protected data, while with LBAC users can get an error if they don#39;t have the necessary credentials to access a LBAC protected column.

Answer: D

Question No: 3

Which of the following options best defines the Label-Based Access Control (LBAC) feature?

  1. DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.

  2. DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by comparing the security labels between database objects and users.

  3. DB2 LBAC monitors table data access and tables modifications made by database users.

  4. DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.

Answer: B

Question No: 4

Which of the following is TRUE about PL/SQL support in DB2?

  1. The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.

  2. DB2 requires third party software to execute PL/SQL statements.

  3. You can only execute PL/SQL statements using the CLPPIus interface.

  4. PL/SQL support is only enabled when using federation to access other vendor databases.

Answer: A

Question No: 5

Which one of the following options is correct about the differences between the IMPORT and INGEST utilities?

  1. The IMPORT utility is now deprecated and INGEST is the recommended alternative.

  2. The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.

  3. The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.

  4. The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.

Answer: C

Question No: 6

What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?

  1. This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.

  2. The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.

  3. This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.

  4. STMM allows DBAs to inspect the current memory allocation by buffer pools.

Answer: A

Question No: 7

Which one of the following statements is TRUE about DB2 Workload Management (WLM)?

  1. DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.

  2. DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.

  3. DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.

  4. DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.

Answer: D

Question No: 8

Which one of the following options is FALSE about DB2#39;s Multi-Temperature Data Storage capability?

  1. You can use storage groups to implement multi-temperature data management in DB2.

  2. Multi-temperature data management reduces the total cost of ownership by allowing

    efficient deployment of storage hardware with minimal administrative overhead.

  3. Multi-temperature data management integrates with DB2#39;s Workload Manager feature to let you prioritize your workloads based on the data being accessed.

  4. Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.

Answer: D

Question No: 9

Which one of the following options contains a benefit of the Java Generic Table Functions?

  1. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.

  2. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.

  3. Java Generic Table Functions must run on a separate server, thus they don#39;t consume DB2 resources.

  4. Java Generic Table Functions can be implemented in any programming language.

Answer: B

Question No: 10

Which one of the following options is CORRECT about DB2 pureScale feature?

  1. DB2 pureScale is only available for DB2 Express-C and DB2 Advanced Enterprise Edition.

  2. DB2 pureScale uses the same concept of HADR where the data is replicated from a primary database to a standby database.

  3. DB2 pureScale persists data in the cluster caching facilities (CFs).

  4. DB2 pureScale reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.

Answer: D

100% Free Download!
Download Free Demo:P2090-018 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests P2090-018 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 Latesttests IT Certification PDF and VCE