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

2017 Jan IBM Official New Released P2090-047
100% Free Download! 100% Pass Guaranteed!

IBM PureData System for Transactions Technical Mastery Test v1

Question No: 41 – (Topic 1)

What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

  1. root

  2. public

  3. admin

  4. system

Answer: C

Question No: 42 – (Topic 1)

What operating system runs on a PureData System for Analytics host?

  1. AIX

  2. SUSE Linux

  3. Nucleus OS

  4. Redhat Linux

Answer: D

Question No: 43 – (Topic 1)

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

  1. S-Blade (Snippet-Blade)

  2. SFI (Switching Fabric Interface)

  3. FPGA (Field Programmable Gate Array)

  4. DRBD (Distributed Replicated Block Device)

Answer: A

Question No: 44 – (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: 45 – (Topic 1)

Why should 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: 46 – (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 against the table TableA.

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

Answer: A

Question No: 47 – (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: 48 – (Topic 1)

When a CREATE TABLE AS (CTAS) is performed on a table creating more than 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: 49 – (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: 50 – (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 reorganize tables based on the ORGANIZE ON clause.

Answer: D

100% Free Download!
Download Free Demo:P2090-047 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests P2090-047 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

Leave a Reply