Ensurepass

QUESTION 71

If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?

 

A.

A maximum of 20%of resources when other users are on the system.

B.

A maximum of 50% of resources when other users are on the system.

C.

A maximum of 80% of resources when no other users are on the system.

D.

A maximum of 100% of resources when no other users are on thesystem.

 

Correct Answer: C

 

 

QUESTION 72

Which statement is true about optimizer settings?

 

A.

They can be set system wide only.

B.

They can be set at the database level only.

C.

They can be set at the session and at the group level.

D.

They can be set system wide and at the session level.

 

Correct Answer: D

 

 

QUESTION 73

What is a characteristic of a column that is based on the TIMESTAMP datatype?

 

A.

It includes a date portion.

B.

It includes a timezone offset.

C.

The value is reevaluated each time the row is selected.

D.

The value is initially assigned when the row is first created.

 

Correct Answer: A

 

 

QUESTION 74

In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)

 

A.

nzsql

B.

An ODBC driver manager.

C.

The system does not support 64 bit ODBC.

D.

A 64-bit ODBC driverfor the same UNIX environment.

E.

A 32-bit ODBC driver for the same UNIX environment.

 

Correct Answer: BD

 

 

QUESTION 75

A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)

 

A.

Using the EXECUTE command.

B.

Using the SELECT statementwithin a FROM clause.

C.

Using the SELECT statement within a HAVING clause.

D.

Using the SELECT statement without a FROM clause.

E.

Using the SELECT statement with tables in the FROM clause.

 

Correct Answer: AD

 

 

QUESTION 76

The primary copy of a dataslice is spread across how many disks?

< b> 

A.

1.

B.

2.

C.

4.

D.

12.

 

Correct Answer: A

 

 

QUESTION 77

When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query history NOT collect data?

 

A.

Plans

B.

Disks

C.

Tables

D.

Queries

 

Correct Answer: B

 

 

QUESTION 78

nzload is invoked with the “allowReplay” option enabled. While the PureData System for Analytics Appliance changes state from online to pausing then to online, which statement is true about the nzload process on the Appliance?

 

A.

nzload will fail.

B.

nzload automatically continues without user intervention.

C.

nzload must be stopped and resumed by the user from the last check point.

D.

nzload automatically restarts but the user must remove the allowReplay option.

 

Correct Answer: B

 

 

QUESTION 79

Zone Maps provide what information about a table?

 

A.

The list of unique columnvalues found within an extent.

B.

An index pointer to each row’s exact location in the base table.

C.

The minimum and maximum column values found within an extent.

D.

The connection between the map and reduce stages when using MapReduce.

 

Correct Answer: C

 

 

QUESTION 80

What is required to troubleshoot a query?

 

A.

nzevents and the pg.log.

B.

nzsql andthe OD
BC config.

C.

nzinventory and the dbos.log.

D.

nzdumpschema and the execution plan.

 

Correct Answer: D

 

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.