|
Question 1.
Which three stages support the dynamic (runtime) definition of the physical column metadata? (Choose three.)
A. the Sequential stage
B. the Column Export stage
C. the CFF stage
D. the DRS stage
E. the Column Import stage
Answer: A, B, E
Question 2.
A Varchar (10) field named Source Column is mapped to a Char(25) field named Target Column in a Transformer stage. The APT_STRING_PADCHAR environment variable is set in Administrator to its default value.
Which technique describes how to write the derivation so that values in Source Column are padded with spaces in Target Column?
A. Include APT_STRING_PADCHAR in your job as a job parameter. Specify the C/C++ end of
string character (0x0) as its value.
B. Map Source Column to Target Column. The Transformer stage will automatically pad with
spaces.
C. Include APT_STRING_PADCHAR in your job as a job parameter. Specify a space as its value.
D. Concatenate a string of 25 spaces to Source Column in the derivation for Target Column.
Answer: C
Question 3.
Which three privileges must the user possess when running a parallel job? (Choose three.)
A. read access to APT_ORCHHOME
B. execute permissions on local copies of programs and scripts
C. read/write permissions to the UNIX/etc directory
D. read/write permissions to APT_ORCHHOME
E. read/write access to disk and scratch disk resources
Answer: A, B, E
Question 4.
In a Teradata environment, which stage invokes Teradata supplied utilities?
A. Teradata API
B. DRS Teradata
C. Teradata Enterprise
D. Teradata Multi load
Answer: D
Question 5.
When importing a COBOL file definition, which two are required? (Choose two.)
A. The file you are importing is accessible from your client workstation.
B. The file you are importing contains level 01 items.
C. The column definitions are in a COBOL copybook file and not, for example, in a COBOL
source file.
D. The file does not contain any OCCURS DEPENDING ON clauses.
Answer: A, B
Question 6.
Which two tasks will create Data Stage projects? (Choose two.)
A. Export and import a Data Stage project from Data Stage Manager.
B. Add new projects from Data Stage Administrator.
C. Install the Data Stage engine.
D. Copy a project in Data Stage Administrator.
Answer: B, C
Question 7.
Which three defaults are set in Data Stage Administrator? (Choose three.)
A. default prompting options, such as Auto save job before compile
B. default SMTP mail server name
C. project level default for Runtime Column Propagation
D. project level defaults for environment variables
E. project level default for Auto-purge of job log entries
Answer: C, D, E
Question 8.
Which three are keyless partitioning methods? (Choose three.)
A. Entire
B. Modulus
C. Round Robin
D. Random
E. Hash
Answer: A, C, D
Question 9.
Which two must be specified to manage Runtime Column Propagation? (Choose two.)
A. enabled in Data Stage Administrator
B. attached to a table definition in Data Stage Manager
C. enabled at the stage level
D. enabled with environmental parameters set at runtime
Answer: A, C
Question 10.
Which three are valid ways within a Job Sequence to pass parameters to Activity stages?
(Choose three.)
A. Exec Command Activity stage
B. User Variables Activity stage
C. Sequencer Activity stage
D. Routine Activity stage
E. Nested Condition Activity stage
Answer: A, B, D
Question 11.
A client requires that a database table be done using two jobs. The first job writes to a dataset. The second job reads the dataset and loads the table. The two jobs are connected in a Job Sequence.
What are three benefits of this approach? (Choose three.)
A. The time it takes to load the table is reduced.
B. The database table can be reloaded after a failure without re-reading the source data.
C. The dataset can be used by other jobs even if the database load fails.
D. The dataset can be read if the database is not available.
E. The data in the dataset can be archived and shared with other external applications.
Answer: B, C, D
Question 12.
You are reading customer data using a Sequential File stage and transforming it using the Transformer stage. The Transformer is used to cleanse the data by trimming spaces from character fields in the input. The cleansed data is to be written to a target DB2 table.
Which partitioning method would yield optimal performance without violating the business requirements?
A. Hash on the customer ID field
B. Round Robin
C. Random
D. Entire
Answer: B
Question 13.
Which three are valid trigger expressions in a stage in a Job Sequence? (Choose three.)
A. Equality (Conditional)
B. Unconditional
C. Return Value (Conditional)
D. Difference (Conditional)
E. Custom (Conditional)
Answer: B, C, E
Question 14.
An Aggregator stage using a Hash technique processes a very large number of rows during month end processing. The job occasionally aborts during these large runs with an obscure memory error. When the job is rerun, processing the data in smaller amounts corrects the problem.
Which change would correct the problem?
A. Set the Combinability option on the Stage Advanced tab to Combinable allowing the
Aggregator to use the memory associated with other operators.
B. Change the partitioning keys to produce more data partitions.
C. Add a Sort stage prior to the Aggregator and change to a sort technique on the Stage
Properties tab of the Aggregator stage.
D. Set the environment variable APT_AGG_MAXMEMORY to a larger value.
Answer: C
Question 15.
Which three actions are performed using stage variables in a parallel Transformer stage?
(Choose three.)
A. A function can be executed once per record.
B. A function can be executed once per run.
C. Identify the first row of an input group.
D. Identify the last row of an input group.
E. Lookup up a value from a reference dataset.
Answer: A, B, C
Question 16.
The source stream contains customer records. Each record is identified by a CUSTID field. It is known that the stream contains duplicate records, that is, multiple records with the same CUSTID value. The business requirement is to add a field named NUMDUPS to each record that contains the number of duplicates and write the results to a target DB2 table.
Which job design would accomplish this?
A. Send the incoming records to a Transformer stage. Use a Hash partitioning method with
CUSTID as the key and sort by CUSTID. Use stage variables to keep a running count of the
number of each new CUSTID. Add this count to a new output field named NUMDUPS then
load the results into the DB2 table.
B. Use a Modify stage to add the NUMDUPS field to the input stream then process the data via
an Aggregator stage Group and Count Rows options on CUSTID with the result of the sum
operation sent to the NUMDUPS column in the Mapping tab for load into the DB2 table.
C. Use a Copy stage to split the incoming records into two streams. One stream goes to an
Aggregator stage that groups the records by CUSTID and counts the number of records in
each group and outputs the results to the NUMDUPS field. The output from the Aggregator
stage is then joined to the other stream using a Join stage on CUSTID and the results are then
loaded into the DB2 table.
D. Use an Aggregator stage to group the incoming records by CUSTID and to count the number
of records in each group then load the results into the DB2 table.
Answer: C
|
Question 1.
Personal Data Keeper and Project Time and Expense for Business Portal are designed for users to enter which types of transactions?
A. Timesheets only
B. Timesheets and Employee Expenses
C. Any Project Accounting transaction
D. Timesheets and any purchasing type transaction
Answer: B
Question 2.
What are the user types available in the Personal Data Keeper User Setup window?
A. Employee, Supervisor and Administrator
B. Employee, Administrator and Manager
C. Employee, Manager and Supervisor
D. Employee, Administrator, Manager and Supervisor
Answer: C
Question 3.
Which of the following statements accurately represents a difference between Personal Data Keeper and Project Time and Expense for Business Portal?
A. Only Personal Data Keeper uses web services to interlace with SQL server.
B. Project Time & Expense for Business Portal may be used to approve expenses but Personal
Data Keeper cannot.
C. Only Personal Data Keeper timesheets can be entered in a week based format.
D. In Time & Expense for Business Portal employees must be assigned to a project before they
can enter a timesheet for it.
Answer: D
Question 4.
An employee assigned as a delegate in the Timesheet Settings window has which of the following capabilities?
A. They can enter a timesheet on behalf of the employee identified.
B. They can approve a timesheet for the employee identified.
C. They can enter a timesheet for any other employee.
D. They can log into Personal Data Keeper as the user identified.
Answer: A
Question 5.
What is the maximum number of delegates that may be assigned to a single employee?
A. Two
B. As many as are in the class assigned to the user.
C. One
D. Unlimited
Answer: D
Question 6.
How is the user count defined in Personal Data Keeper?
A. It is determined by the database server license.
B. Each User ID is considered one license.
C. Personal Data Keeper licenses are concurrent, not based on specific users.
D. Dynamics GP user licenses transfer to Personal Data Keeper licenses.
Answer: B
Question 7.
In order to install Project Time and Expense for Business Portal, which of the following must be true?
A. The installer must be a user in Microsoft Dynamics GP.
B. The installer must have administrator rights to the SQL server being used.
C. The system must have registered Payroll applications.
D. The installer must be a Microsoft master certified Dynamics GP technician.
Answer: B
Question 8.
Which of the following describes system security in Personal Data Keeper?
A. You must have a system password and it must be access?
B. A system password is optional in Personal Data Keeper.
C. You must have a system password, but it does not have to be ‘access’.
D. There is no system password capability in Personal Data Keeper.
Answer: C
Question 9.
Which role is necessary in order to add or remove users in business Portal for use with Project Time and Expense?
A. Employee
B. Manager
C. Administrator
D. Back Office user
Answer: C
Question 10.
Whether a transaction appears in the approvals window is determined primarily by which table field?
A. PDK Document Status field of the transaction header table.
B. The Employee ID field of the transaction header table.
C. The Transaction Quantity field of the transaction line table.
D. The User Type field of the PDK User Master table.
Answer: A
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.