Latest C100DBA Practice Tests with Actual Questions

Get Complete pool of questions with Premium PDF and Test Engine

Exam Code : C100DBA
Exam Name : MongoDB Certified DBA Associate
Vendor Name : "MongoDB"







C2090-424 Dumps

C2090-424 Braindumps C2090-424 Real Questions C2090-424 Practice Test C2090-424 Actual Questions


killexams.com


IBM


C2090-424


InfoSphere DataStage v11.3


https://killexams.com/pass4sure/exam-detail/C2090-424



Question: 58

Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance?


  1. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Reports,

    Custom attributes for InfoSphere Information Covernance Catalog

  2. Common metadata, Users and groups,

    Custom attributes for InfoSphere Information Governance Catalog, InfoSphere DataStageand QualityStage assets, Reports

  3. Common metadata, Users and groups, Custom attributes for InfoSphere Information Governance Catalog, InfoSphere

    Data Stage and QualityStage assets

  4. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets,

Custom attributes for InfoSphere Information Governance Catalog, Reports




Answer: A



Question: 59

In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported?


  1. Select top level sequencer job and click on "Export" option

  2. Select top level sequencer job and click on "Find dependencies" option

  3. Select top level sequencer job and click on "Find dependencies (deep)" option

  4. Select top level sequencer job and click on "Edit->Job Properties -> Dependencies"




Answer: D



Question: 60

For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully:


  1. $APT_MONITOR_SIZE

  2. $APT_RECORD_COUNTS

  3. $APT_DISABLE_COMBINATION

  4. $APT_DEFAULT_TRANSPORT_BLOCK_SIZE




Answer: D



Question: 61

Which of the following is TRUE?


  1. The Modify stage can keep or drop records

  2. The DB2 Connector stage can have, at most, one input link

  3. The Copy stage can be used for implicit data type conversions

  4. When runtime column propagation is enabled, you can use output mapping on a stage to rename or drop columns




Answer: D


Reference:

https://www- 01.ibm.com/support/knowledgecenter/SSZJPZ_9.1.0/com.ibm.swg.im.iis.conn.oracon.usage.doc/t opics/r_runtime_column_propagation.html(Useage).



Question: 62

Which Connector Stage doesn't support reject Link


  1. DB2 Connector

  2. ODBC Connector

  3. Oracle Connector

  4. Netezza Connector




Answer: B



Explanation:

Reject links are not supported by any connectivity source stage. This includes the Px Sybase, Px ODBC, Px DB2Z, Px Classic Federation stages,Px DB2and Px Oracle stages.



Question: 63

Select the correct command to reset a password to Info1234 for user srv_etl in the Information Server internal registry, in the Unix environment.


  1. iisAdmin.sh -user srv_etl -password Info1234

  2. iisAdmin.sh -user -userid srv_etl -password Info1234

  3. SessionAdmin.sh -user -userid srv_etl -password Info1234

  4. DirectoryAdmin.sh -user -userid srv_etl -password Info1234




Answer: C



Question: 64

Which of the following statements about real time job design is TRUE?


  1. DSJobInvocationId is not required for the target sequential file.

  2. A non-Multiple Instance DataStage job can be activated for ISD service.

  3. A DataStage job must have an ISD Input stage, but an ISD Output stage is not required.

  4. The Information Services Director server starts job instances on one or more DataStage servers for load balancing and scalability.




Answer: D


Reference:

https://www- 01.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.infoservdir.user.doc/topi cs/c_isd_user_ds_qs_job_topologies.html(See 2nd paragraph).