[Free] 2017(Jan) Latesttests Passguide IBM P2090-050 Dumps with VCE and PDF 51-60

Latesttests
2017 Jan IBM Official New Released P2090-050
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/P2090-050.html

IBM PureData System for Analytics Technical Mastery Test v1

Question No: 51 – (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: 52 – (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: 53 – (Topic 1)

You havecreated 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: 54 – (Topic 1)

Which CREATE DATABASE attributes are required?

  1. The database name.

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

  3. Thedatabase name and the table space name.

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

Answer: A

Question No: 55 – (Topic 1)

Which statement is true for database users and groups?

  1. All users must belong to admin group.

  2. Creation of users and groupsis 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: 56 – (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: 57 – (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: 58 – (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 onebase table in the FROM clause.

Answer: D,E

Question No: 59 – (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

Question No: 60 – (Topic 1)

When are zonemaps initially created for a table?

  1. nzbackup

  2. nzreclaim

  3. CREATE TABLE

  4. ALTER TABLE ADD ZONEMAPS

Answer: C

100% Free Download!
Download Free Demo:P2090-050 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests P2090-050 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
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 Latesttests IT Certification PDF and VCE

Leave a Reply