Independence Day - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65percent

Welcome To DumpsPedia

A00-260 Sample Questions Answers

Questions 4

The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE regarding the Platform Process Manager server?

Options:

A.

The server enables you to schedule jobs using a variety of recurrence criteria and dependencies on other jobs,

time events, or file events.

B.

The server enables you to schedule jobs using a variety of recurrence criteria but does NOT allow you to

specify any type of dependencies.

C.

The Flow Manager application (part of the Platform Suite for SAS) can be used to manage already scheduled

jobs.

D.

Metadata for the Platform Process Manager server must be defined and must include the network address or host

name of a machine as well as the port number for the server.

Buy Now
Questions 5

When using the Table Loader transformation to load an existing target table that contains one or more indexes in SAS Data Integration Studio, which statement is true?

Options:

A.

Indexes are removed when the Table Loader executes and must be re-created using the Table Structure

transformation.

B.

Indexes are automatically preserved when the Table Loader executes.

C.

Indexes are removed at the beginning of the load process and must be re-created in a subsequent job step.

D.

Indexes can be removed or preserved at the beginning of the process depending on options chosen. Additional

table loader options specify whether to re-create the index at the end of the process.

Buy Now
Questions 6

A user needs to find out who has the SAS Data Integration Studio job "Create Tables" checked out. What action should the user perform?

Options:

A.

They need to select the "Properties" menu option and then the "Advanced" tab for the SAS Data Integration

Studio job "Create Tables" within Data Integration studio.

B.

They need to select the History menu option for the SAS Data Integration Studio job "Create Tables" once it

has been checked in.

C.

They need to select the History menu option for the SAS Data Integration Studio job "Create Tables".

D.

They are not able to find out who has the SAS Data Integration Studio job "Create Tables" in checked out

status because they are not an administrator.

Buy Now
Questions 7

You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Studio transformation that will help you perform the task easily.

Options:

A.

Append

B.

Extract

C.

Lookup

D.

Mining Results

Buy Now
Questions 8

Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?

Options:

A.

The Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value.

B.

The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.

C.

The Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window.

D.

If the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window.

Buy Now
Questions 9

Which action is performed by the Lookup transformation in SAS Data Integration Studio?

Options:

A.

combines rows from multiple tables into a single row

B.

combines rows from multiple tables into multiple rows

C.

validates that values are unique

D.

validates that values are not null

Buy Now
Questions 10

You want to register an external file with the following structure: first line contains Customer First and Last Name second line is address1 third line is address 2 fourth line contains the phone number What action should you take to read this file?

Options:

A.

Use the New User Written External File wizard.

B.

Use the New Fixed Width External File wizard.

C.

Use the New Delimited External File wizard.

D.

Use the New COBOL Copybook wizard.

Buy Now
Questions 11

After creating a stored process from a SAS Data Integration Studio job, how can you test the stored process to make sure it runs correctly?

Options:

A.

Execute the stored process in SAS Data Integration Studio.

B.

Execute the stored process in SAS Management Console.

C.

Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.

D.

Execute the stored process using SAS Display Manager's Stored Process Test window.

Buy Now
Questions 12

Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)

Options:

A.

Create and replace permanent tables.

B.

Maintain access privileges to permanent tables.

C.

Apply and maintain constraints on permanent tables.

D.

Delete and remove permanent tables.

Buy Now
Questions 13

In SAS Data Integration Studio, surrogate and retained key values are:

Options:

A.

generated by the Lookup transformation

B.

copied from source tables into dimension tables

C.

generated by the SCD Type 2 Loader transformation

D.

copied from dimension tables into source tables

Buy Now
Questions 14

Which statement best describes the DataFlux Integration Server?

Options:

A.

An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call

dfPower Architect or dfPower Profile jobs.

B.

A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing

operations.

C.

An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for

data cleansing operations.

D.

A third party server defined in the SAS metadata repository that allows you to build flows integrating

multiple jobs and establishing job dependencies within the flow.

Buy Now
Questions 15

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

Options:

A.

the old record is deleted and the changed record is added

B.

the old record is updated with the new values from the changed record

C.

the old record is flagged and the changed record is added

D.

the old record is merged with the changed record

Buy Now
Questions 16

When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?

Options:

A.

business key columns

B.

Type 1 columns

C.

generated columns

D.

non-key columns

Buy Now
Questions 17

Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns are indexed?

Options:

A.

the Load Technique tab in the Table Loader transformation properties window

B.

the Indexes tab in the table properties window

C.

the Columns tab in the table properties window

D.

the Columns tab in the Details panel of the open job, with the table selected in the job flow

Buy Now
Questions 18

The SAS platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:

Options:

A.

SAS Information Delivery Portal

B.

SAS Information Map Studio

C.

SAS Web Report Studio

D.

SAS OLAP Cube Studio

Buy Now
Questions 19

Which action is required for enabling performance statistics on the executing SAS Workspace Server?

Options:

A.

Define a logfile for output.

B.

Define Collect Diagnostics for the SAS Data Integration Studio job.

C.

Define Collect Runtime statistics for the SAS Data Integration Studio job.

D.

Enable the logging facility of the SAS Workspace Server.

Buy Now
Questions 20

The profile reports generated in dfPower Profile jobs are viewed:

Options:

A.

in dfPower Profile (Viewer)

B.

in the Reports tab of dfPower Profile (Configurator)

C.

in any HTML viewer

D.

in any text viewer

Buy Now
Questions 21

In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?

Options:

A.

Data Validation

B.

Lookup

C.

DataFlux IS Job

D.

Table Loader

Buy Now
Exam Code: A00-260
Exam Name: SAS Data Integration Development
Last Update: Jul 10, 2024
Questions: 70
$56  $159.99
$42  $119.99
$35  $99.99
buy now A00-260