P2070-071 Online Practice Questions and Answers

An OnDemand system is being configured to use Tivoli StorageManager (TSM) to archive documents. What task must be performed to make TSM storage available to the OnDemand system?

A. Install TSM on the object server and configure it to provide an archive storage pool for the OnDemand database

B. Install TSM on thelibrary server and configure it to provide a backup storage pool for the OnDemand database

C. Configure a client (storage) node in each TSM storage pool that will be used to store OnDemand data

D. Install and configure an HTTP server on the object server to handle storage requests between OnDemand and TSM

Which of the following is used to limit the number of documents displayed in the document list?

A. maximum hits

B. named query

C. query restriction

D. none of the above

Which OnDemand utility program is used to expire index data and documents in cache storage?

A. arsmaint

B. arsadmin

C. arsdoc

D. arsload

In the OnDemand client, the wildcardcharacters (single/zero or more) are:

A. ?/* (question mark and asterisk)

B. ./# (period and pound sign)

C. depends on the database serve

D. _/% (underscore and percent sign)

Which of the following database servers is not supported by OnDemand?

A. Oracle

B. MySql

C. SQL Server

D. DB2

Which OnDemand command line utility program is used to unload data?

A. arsload

B. arsmaint

C. arsadmin

D. arsdb

E. none of the above

InOnDemand, a database field may be any one of the following data types except:

A. boolean

B. integer

C. string

D. decimal

E. all of the above are supported data types

Which ofthe following is NOT a function of the OnDemand library server?

A. user authentication

B. logging

C. searching

D. data loading

Company policy requires thatapplication development and testing be isolated from production systems. With respect to OnDemand, which of the following options best satisfies this policy?

A. Use separate application groups, applications, folders and user accounts for development and testing

B. Install another copy of OnDemand on a different server for development and testing

C. Create a second object server for development and testing

D. Create a second OnDemand instance for development and testing

An SSN (Social SecurityNumber) is a common database field for many applications, but the format of the SSN on different documents can vary. For example, one document uses a 9 digit SSN without dashes or spaces (xxxxxxxxx), another includes spaces (xxx xx xxxx), and a third includes dashes (xxx-xx-xxxx).

Which one of the following methods is used to store the SSN from all applications in a single format?

A. Specify a default format option for the SSN field in each application

B. Remove embedded dash and space characters from theSSN field in each application

C. Remove embedded dash and space characters from the SSN field in the application group

D. Use the MASK option in the FIELD index parameter statement to ignore dashes and spaces in the SSN field