New Year Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dm70dm

Hot Vendors
  1. Home
  2. IBM
  3. IBM Information Management
  4. P2090-047
  5. IBM PureData System for Transactions Technical Mastery Test v1 Questions and Answers
Note! The P2090-047 Exam is no longer available.

P2090-047 IBM PureData System for Transactions Technical Mastery Test v1 Questions and Answers

Questions 4

Which is NOT a way to check if the database is online?

Options:

A.

nzstate

B.

cat /proc/database

C.

nzsystem showState

D.

nzsql -c "select * from _v_system_info;"

Buy Now
Questions 5

What is the naming convention for system views?

Options:

A.

_v_...

B.

nz_v_...

C.

_$v_...

D.

sys_v_...

Buy Now
Questions 6

What is the maximum number of columns that can participate in a distribution key?

Options:

A.

One

B.

Four

C.

Unlimited

D.

Depends on the number of columns of integer datatype.

Buy Now
Questions 7

Where are the database log files located?

Options:

A.

/var/log

B.

/usr/local

C.

/nz/kit/log

D.

The SYSTEM database

Buy Now
Questions 8

What is required to troubleshoot a query?

Options:

A.

nzevents and the pg.log.

B.

nzsql and the ODBC config.

C.

nzinventory and the dbos.log.

D.

nzdumpschema and the execution plan.

Buy Now
Questions 9

Which nzload operation statement is correct?

Options:

A.

nzload must have a control file.

B.

nzload performs singleton inserts.

C.

nzload user must have CREATE EXTERNAL TABLE privilege.

D.

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

Buy Now
Questions 10

OLE-DB based applications on UNIX requires which PureData System for Analytics software?

Options:

A.

Install the JDBC driver for UNIX.

B.

Install the ODBC driver for UNIX.

C.

Install the OLE-DB driver for UNIX.

D.

OLE-DB is not supported on UNIX.

Buy Now
Questions 11

Why is table skew important to manage?

Options:

A.

Low table skew negatively impacts performance.

B.

High table skew negatively impacts performance.

C.

Low table skew negatively impacts data compression.

D.

Deleted rows consume disk space until they are freed.

Buy Now
Questions 12

Which statement is true?

Options:

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.

Buy Now
Questions 13

If 'admin' user is running a query, what percentage of resources are available when Guaranteed Resource Allocation (GRA) is Enabled?

Options:

A.

The maximum GRA assigned to the ADMIN group.

B.

The maximum GRA assigned to the PUBLIC group.

C.

100% of the resources while other resource groups are active.

D.

Typically half of the resources while other resource groups are active.

Buy Now
Questions 14

Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from the system?

Options:

A.

sar

B.

nzhw

C.

nzsystem

D.

nzinventory

Buy Now
Questions 15

When setting up a crontab entry, what must be done on a PureData System for Analytics server?

Options:

A.

Create an nzcron event.

B.

nzstop/nzstart the database.

C.

Stop and start the appliance.

D.

Add entry to active host and standby host.

Buy Now
Questions 16

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

Options:

A.

If there are any materialized views on the table TableA.

B.

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

C.

If there are any active nzloads running against the table TableA.

D.

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

Buy Now
Questions 17

What is a benefit of Clustered Base Tables?

Options:

A.

Replicates base table data.

B.

An alternate way to order a table's data.

C.

Materializes on disk joins between tables.

D.

Increases the performance of load operations.

Buy Now
Questions 18

Click on the exhibit.

P2090-047 Question 18

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?

Options:

A.

Collocation hash join processing

B.

Distributed hash join processing

C.

Broadcast sort merge join processing

D.

Replication sort merge join processing

Buy Now
Questions 19

An ETL/ODBC application is inserting 1 million records in a single transaction against the PureData System for Analytics. 1 million individual INSERT SQL statements are generated. What can make this faster?

Options:

A.

Use a COPY command.

B.

Use an EXTERNAL TABLE.

C.

Increase the Socket Buffer Size.

D.

Set the COMMIT interval to 10,000.

Buy Now
Exam Code: P2090-047
Exam Name: IBM PureData System for Transactions Technical Mastery Test v1
Last Update: Nov 27, 2023
Questions: 132
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 27 Dec 2024