P2090-047 Test Dumps

P2090-047 Study Guide PDF:

Question No : 1

Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?
A. Bypasses the host.
B. Flows through the host.
C. Compressed on the host.
D. Uncompressed on the host.

Answer: B

Question No : 2

A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
A. Use a CURSOR.
B. Use an EXTERNAL table.
C. Use the COPY command.
D. Increase the PreFetch Count.

Answer: B

Question No : 3

You have created a group GroupA with JOB MAXIMUM of 4, which statement is true?
A. No more than 4 users can be assigned to GroupA.
B. If users in GroupA submit more than 4 queries they will fail.
C. If users in GroupA submit more than 4 queries, then they will queue in order.
D. The job maximum cannot be less than the default concurrent query limit of 48.

Answer: C

Question No : 4

Which statement is true?
A. All user space is available for database expansion.
B. Each database is assigned it's own section of disk space.
C. When creating the database you can specify which disks to use.
D. When you create a database you can set the maximum space it is allowed to use.

Answer: A

Question No : 5

What function can nzbackup perform?
A. Back up pg.log files.
B. Back up TEMP tables.
C. Back up host data (catalog metadata).
D. Back up the data using the specified number of streams.

Answer: D



Category: P2090-047 Exam

you are at P2090-047 Test Dumps

For more questions you can browse P2090-047 Exam.

Recent Post