Online Access Free 000-303 Practice Test

How must the input data set be organized for input into the Join stage? (Choose two.)

• A.Key partitioned
• B.Sorted by Join key
• C.Hash partitioned
• D.Entire partitioned
• E.Unsorted

You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What option will enable jobs with a parallel transformer to execute in the customers production machines?

• A.Add $APT_COMPILE_OPT=-portable
• B.Create a package with Information Server Manager and select the option to include executables.
• C.Set $APT_COPY_TRANSFORM_OPERATOR
• D.Use protected projects in the production environment.

What role must a user have to delete shared metadata assets from the repository?

• A.DataStage Administrator
• B.Common Metadata Administrator
• C.Business Glossary Administrator
• D.Information Analyzer Administrator

Which two commands start a DataStage job named procRows in a project named DSProject. It also passes the value 200 to the numRows parameter. (Choose two.)

• A.dsjob -run -queue HighPriority -param numRows=200 DSProject procRows
• B.dsjob -run -mode validate -param numRows=200 DSProject procRows
• C.dsjob -run -paramfile numRows=200 DSProject procRows
• D.dsjob -run -mode normal -param numRows=200 DSProject procRows
• E.dsjob -run -mode normal -paramfile numRows=200 DSProject procRows

Which Oracle data type conversion is correct?

• A.Oracle data type NUMBER(6,0) converts to INT32 in Oracle Connector stage.
• B.Oracle data type NUMBER(15,0) converts to INT32 in Oracle Connector stage.
• C.Oracle data type RAW converts to RAW in Oracle Connector stage.
• D.Oracle data type NUMBER converts to DECIMAL(38,0) in Oracle Connector stage.