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

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: 41 – (Topic 1)

What operating system runs ona PureData System for Analytics host?

  1. AIX

  2. SUSE Linux

  3. Nucleus OS

  4. Redhat Linux

Answer: D

Question No: 42 – (Topic 1)

What PureData System for Analytics component is responsible for controlling table storage?

  1. S-Blade (Snippet-Blade)

  2. SFI (SwitchingFabric Interface)

  3. FPGA (Field Programmable Gate Array)

  4. DRBD (Distributed Replicated Block Device)

Answer: A

Question No: 43 – (Topic 1)

Click on the exhibit.

Latesttests 2017 PDF and VCE

Given the following query: SELECT * FROM TableA, TableB WHERE TableA.c_custkey = TableB.o_custkey;What type of join processing will occur when the query is executed?

  1. Collocation hash join processing

  2. Distributed hash join processing

  3. Broadcast sort merge join processing

  4. Replication sort merge join processing

Answer: A

Question No: 44 – (Topic 1)

Whyshould you avoid using Boolean data types as a distribution key for a table ?

  1. Table will not join.

  2. Table will not broadcast.

  3. Table is likely to be skewed.

  4. Table is likely to be evenly spread across data slices.

Answer: C

Question No: 45 – (Topic 1)

What will prevent a GROOM TABLE command from running on a table named TableA?

  1. If there are any materialized views on the table TableA.

  2. If there are any active selects running against the table TableA.

  3. If there are any active nzloads running againstthe table TableA.

  4. If there are any active updates running against the table TableA.

Answer: A

Question No: 46 – (Topic 1)

What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)

  1. The views on TableA.

  2. The privileges on TableA.

  3. The distribution key of TableB.

  4. The materialized views on TableB.

  5. The order of the data stored in TableB.

Answer: C,E

Question No: 47 – (Topic 1)

When a CREATE TABLE AS (CTAS) is performed on a table creating morethan 1,000,000,000 rows, which statement is true?

  1. Groom will be automatically invoked.

  2. Primary key constraints will be checked.

  3. Statistics will automatically be generated.

  4. Materialized views will be automatically generated.

Answer: C

Question No: 48 – (Topic 1)

What is the host Linux file that must be modified to adjust optimizer settings permanently?

  1. /nz/data/postgresql.conf

  2. /nz/data/config/system.cfg

  3. /nz/kit/sys/initTopology.cfg

  4. /nz/kit/log/sysmgr/sysmgr.log

Answer: A

Question No: 49 – (Topic 1)

Which statement is true about the groom feature?

  1. Groom allows the user to add row level security.

  2. Groom validates primary key constraints on the table.

  3. Groom reorders rows based on the DISTRIBUTE ON clause.

  4. Groom allows the user to reorganizetables based on the ORGANIZE ON clause.

Answer: D

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

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