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

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

A SELECT statement spends all its time returning 1 billion rows.What can be done to make this faster?

  1. Use a CURSOR.

  2. Use an EXTERNAL table.

  3. Use the COPY command.

  4. Increase the PreFetch Count.

Answer: B

Question No: 2 – (Topic 1)

What function can nzbackup perform?

  1. Back up pg.log files.

  2. Back up TEMP tables.

  3. Back up host data (catalog metadata).

  4. Back up the data using the specified number of streams.

Answer: D

Question No: 3 – (Topic 1)

nzbackup/nzrestore with the -user option has been replaced with which option to allow multi-level security (MLS) information, suchas categories, cohorts, and levels to be backed up/restored?

  1. -all

  2. -mls

  3. -users

  4. -globals

Answer: D

Question No: 4 – (Topic 1)

When loading a local ASCII file into table via an external table, where can the SQL be submitted?

  1. From a User Defined Function.

  2. From a JDBC application networked to the system.

  3. From nzsql on an AIX machine networked to the system.

  4. From nzsql on Microsoft Windows networked to the system.

Answer: B

Question No: 5 – (Topic 1)

Which is NOT a function that can be performed bynzbackup?

  1. Backup data

  2. Backup schemas

  3. Backup users/groups

  4. Backup the /nz/data directory

Answer: D

Question No: 6 – (Topic 1)

Which nzload operation statement is correct?

  1. nzload must have a control file.

  2. nzload performs singleton inserts.

  3. nzload user must have CREATE EXTERNAL TABLE privilege.

  4. nzload must be run from the PureData System for Analytics host.

Answer: C

Question No: 7 – (Topic 1)

Name the CLI application that allows you to load data from ASCII files to database tables?

  1. nzload

  2. loadmgr

  3. nzimport

  4. nzrestore

Answer: A

Question No: 8 – (Topic 1)

You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

  1. Delete from PROD..TableA

  2. Select * from PROD..TableA

  3. Truncate table PROD..TableA

  4. Insert into PROD..TableA select * from DEV..TableB

Answer: B

Question No: 9 – (Topic 1)

Which statement is true?

  1. MATERIALIZED VIEWS can be run against EXTERNAL tables.

  2. GENERATE STATISTICS can be run against EXTERNAL tables.

  3. EXTERNAL table data is deleted using the SQL DELETE command.

  4. EXTERNAL tables can be used to unload data to a Microsoft Windows directory.

Answer: D

Question No: 10 – (Topic 1)

What is required to troubleshoot a query?

  1. nzevents and the pg.log.

  2. nzsql and the ODBC config.

  3. nzinventory and the dbos.log.

  4. nzdumpschema and the execution plan.

Answer: D

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

Your email address will not be published. Required fields are marked *

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