[Free] 2018(Jan) EnsurePass Pass4sure IBM P2090-050 Dumps with VCE and PDF 41-50

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

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.

Ensurepass 2018 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% Ensurepass Free Download!
Download Free Demo:P2090-050 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-050 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

Leave a Reply

