Ensurepass

QUESTION 11

In order for an ODBC application running on Microsoft Windows to connect to PureData System for Analytics, which two steps must be performed? (Choose two.)

 

A.

Install nzsql forWindows.

B.

Install nzAdmin for Windows.

C.

Install an ODBC driver for Windows.

D.

Install an ODBC Driver Manager for Windows.

E.

Create or modify a Data Source Name (DSN) for a connection to a database.

 

Correct Answer: CE

 

 

QUESTION 12

What CANNOT be measured and managed by system views?

 

A.

Temperature values on S-blade.

B.

Status of the host attached storage.

C.

Power supply status for each frame.

D.

Resource group utilization and history.

 

Correct Answer: B

 

 

QUESTION 13

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

 

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 againstthe table TableA.

D.

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

 

Correct Answer: A

 

 

 

 

 

QUESTION 14

Which command is used to abort a user’s SQL transaction?

 

A.

kill

B.

abort

C.

nzstop

D.

nzsession

 

Correct Answer: D

 

 

QUESTION 15

What function can n
zbackup 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.

 

Correct Answer: D

 

 

QUESTION 16

A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource groupeach execute 1 job at the same time, which statement is correct?

 

A.

Each job gets 25% and both run at the same time.

B.

Each job gets 50% but only one job runs at a time.

C.

Each job gets 50% and both run at the same time.

D.

You cannot set the job maximum per resource group.

 

Correct Answer: B

 

 

QUESTION 17

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

 

A.

nzload

B.

loadmgr

C.

nzimport

D.

nzrestore

 

Correct Answer: A

 

 

QUESTION 18

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

 

A.

Delete from PROD..TableA

B.

Select * from PROD..TableA

C.

Truncate table PROD..TableA

D.

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

Correct Answer: B

 

 

QUESTION 19

To create a database table, at a minimum, what must be specified?

 

A.

column name and data type.

B.

column name, data type and primary key.

C.

column name, data type and default constraint.

D.

column name, data type and distribute on clause.

 

Correct Answer: A

 

 

QUESTION 20

Where are the database log files located?

 

A.

/var/log

B.

/usr/local

C.

/nz/kit/log

D.

The SYSTEM database

 

Correct Answer: C

 

Free VCE & PDF File for IBM P2090-050 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

Comments are closed.