Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
A00-260 Examination questions (September)

Achieve New Updated (September) SAS A00-260 Examination questions 1-10

September 25, 2015

Ensurepass

QUESTION 1

A SAS Data Integration Studio job was successfully scheduled and the appropriate event for triggering it occurred. Which statement describes the situation correctly?

 

A.

The scheduling server calls the SAS DATA Step Batch Server over the SAS Object Server which spawns the job,

getting its source code from the deployment directory, and sends the results directly to the Schedule Manager

plug-in of the SAS Management Console.

B.

The scheduling server uses the command obtained from the SAS DATA Step Batch Server and the source code from

the deployment directory to run the job. The results from the executing command are directly sent to the

scheduling server.

C.

The scheduling server uses the command from the deployed job in the deployment directory and executes it with

the SAS DATA Step Batch Server which gets the source code from the Metadata Server.

The results are sent back

to the deployment directory.

D.

The scheduling server uses the command obtained from the Schedule Manager, the source code from SAS DATA Step

Batch Server and executes it. The results are directly sent to the scheduling server.

 

Answer: B

 

 

QUESTION 2

In order to use the SAS Data Integration Studio’s Apply Lookup Standardization transformation, Data Quality options must be setup. Select the valid Scheme Repository Types. (Choose two.)

 

A.

A comma delimited flat file that contains the field names in the first row.

B.

Power scheme that is generated by Data Flux.

C.

A SAS table scheme that is generated by SAS.

D.

A third party RDBMS table that has been generated by the SAS system.

 

Answer: AC

 

 

QUESTION 3

 

How can you make a SAS Data Integration Studio Generated transformation option required?

 

A.

The name of the option has to start with _REQUIRED.

B.

The type of the column has to be defined as Required Data source column.

C.

The option can be marked as Requires a non-blank value.

D.

It is not possible to make an option required.

 

Answer: C

 

 

QUESTION 4

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

 

A.

business key columns

B.

Type 1 columns

C.

generated columns

D.

non-key columns

 

Answer: D

 

 

QUESTION 5

Which statement correctly defines a System DSN?

 

A.

Not specific to an individual user. Anyone with permission to access the data source can use it.

B.

Specific to an individual user. It is available only to the user who creates it.

C.

Not specific to an individual user. It can be shared among users even though it is created locally.

D.

Specific to an individual user. But it can be shared among users.

 

Answer: A

 

 

QUESTION 6

 

Which statement best describes a deployment directory as used in the Schedule Manager in SAS Management Console?

 

A.

A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored.

B.

A location in the metadata repository where job flows are deployed.

C.

A location in the SAS Management console job directory storing the metadata for jobs that can be added to job flows.

D.

A SAS Folder in the Schedule Manager plug-in within SAS Management Console containing listings of all flows organized by server type.

 

Answer: A

 

 

QUESTION 7

You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions such as missing data or duplicate data and take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation should you use?

 

A.

Data Transfer

B.

Data Validation

C.

Data Quality

D.

Data Extract

 

Answer: B

 

 

QUESTION 8

In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs?

 

A.

the deployment wizard of SAS Data Integration Studio

B.

the Scheduling Manager plug-in in SAS Management Console

C.

the Scheduling Server

D.

the SAS DATA Step Batch Server

 

Answer: B

 

 

 

QUESTION 9

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?

 

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.

 

Answer: A

 

 

QUESTION 10

The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following?

 

A.

generate cpu statistics

B.

generate a datetime value

C.

generates cluster numbers

D.

generates standardization values

 

Answer: B

 

Free VCE & PDF File for SAS A00-260 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …