[Free] 2018(Jan) EnsurePass Dumpsleader IBM P2090-047 Dumps with VCE and PDF 51-60

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-047
100% Free Download! 100% Pass Guaranteed!

IBM PureData System for Transactions Technical Mastery Test v1

Question No: 51 – (Topic 1)

Why is generating statistics on a table important to query performance?

  1. The table statistics are used to facilitate disk space reclamation of deleted rows.

  2. The optimizer uses statistics to determine the optimal execution plan for queries.

  3. The Zone Map information cross references the table statistics for each column to avoid scanning.

  4. The Field Programmable Gate Array (FPGA) utilizes the statistics to identify which row/columns to filter.

Answer: B

Question No: 52 – (Topic 1)

Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?

  1. Queries on the table will invoke compression.

  2. Queries on date range may involve processing skew.

  3. Queries on date range will utilize only host processing.

  4. Queries on the table will invoke compression on the date columns.

Answer: B

Question No: 53 – (Topic 1)

Which statement is true?

  1. All user space is available for database expansion.

  2. Each database is assigned it#39;s own section of disk space.

  3. When creating the database you can specify which disks to use.

  4. When you create a database you can set the maximum space it is allowed to use.

Answer: A

Question No: 54 – (Topic 1)

You have created a group GroupA with JOB MAXIMUM of 4, which statement is true?

  1. No more than 4 users can be assigned to GroupA.

  2. If users in GroupA submit more than 4 queries they will fail.

  3. If users in GroupA submit more than 4 queries, then they will queue in order.

  4. The job maximum cannot be less than the default concurrent query limit of 48.

Answer: C

Question No: 55 – (Topic 1)

Which CREATE DATABASE attributes are required?

  1. The database name.

  2. The database name and the redo log file name.

  3. The database name and the table space name.

  4. The database name and the temporary table space name.

Answer: A

Question No: 56 – (Topic 1)

Which statement is true for database users and groups?

  1. All users must belong to admin group.

  2. Creation of users and groups is not allowed.

  3. Users and groups are local and tied to a particular database.

  4. Users and groups are global and not tied to a particular database.

Answer: D

Question No: 57 – (Topic 1)

When creating a table, you can specify a column constraint for each individual column of either quot;NULLquot; or quot;NOT NULLquot;. When column values are later evaluated within a query statement, which of these is true?

  1. 0 is equal to null, the empty string ( #39;#39; ) is equal to null.

  2. 0 is equal to null, the empty string ( #39;#39; ) is not equal to null.

  3. 0 is not equal to null, the empty string ( #39;#39; ) is equal to null.

  4. 0 is not equal to null, the empty string ( #39;#39; ) is not equal to null.

Answer: D

Question No: 58 – (Topic 1)

To create a database table, at a minimum, what must be specified?

  1. column name and data type.

  2. column name, data type and primary key.

  3. column name, data type and default constraint.

  4. column name, data type and distribute on clause.

Answer: A

Question No: 59 – (Topic 1)

Which two characteristics describe materialized views. (Choose two.)

  1. Materialized views can contain aggregates.

  2. Materialized views can contain a HAVING clause.

  3. Materialized views can contain a WHERE clause.

  4. Materialized views can contain an ORDER BY clause.

  5. Materialized views can reference only one base table in the FROM clause.

Answer: D,E

Question No: 60 – (Topic 1)

What is a benefit of Clustered Base Tables?

  1. Replicates base table data.

  2. An alternate way to order a table#39;s data.

  3. Materializes on disk joins between tables.

  4. Increases the performance of load operations.

Answer: B

100% Ensurepass Free Download!
Download Free Demo:P2090-047 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-047 Dumps

EnsurePass 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

This entry was posted in P2090-047 Latest Exam (Jan 2018) and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.