Weekend Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

Examstrust Logo
examstrust mcafee
  1. Home
  2. SAS Institute
  3. Data Integration Developer
  4. A00-260 - SAS Data Integration Development

SAS Institute A00-260 SAS Data Integration Development Exam Practice Test

Page: 1 / 7
Total 70 questions
Get A00-260 Full Access Download A00-260 PDF

SAS Data Integration Development Questions and Answers

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$59.5  $169.99
Add to Cart

Testing Engine

  • Product Type: Testing Engine
$42  $119.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Add to Cart
Question 1

In SAS Data Integration Studio, an index can be specified/defined in which location?

Options:

A.

the Indexes tab in the properties of a Table Loader transformation

B.

the Indexes tab in the properties of a table metadata object

C.

the Indexes tab in the properties for any transformation

D.

the Indexes tab in the properties of a job metadata object

Question 2

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

Question 3

Within SAS Data Integration Studio, how many inputs and outputs can be defined for a Generated transformation?

Options:

A.

A transformation can have zero or more inputs and exactly one output.

B.

A transformation needs at least one input and at least one output.

C.

A transformation can have zero or more inputs and zero or more outputs.

D.

A transformation needs at least one input and exactly one output.

Question 4

Which definition cannot be imported using a SAS Metadata Bridge?

Options:

A.

Server definition

B.

Library definition

C.

Table definition

D.

Column Definition

Question 5

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

Question 6

Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?

Options:

A.

The physical table(s) selected are copied to the application server specified in the library.

B.

The physical table(s) selected are copied to the SAS Folders location specified in the wizard.

C.

Metadata for the physical table(s) selected is stored on the application server specified in the library.

D.

Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.

Question 7

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

Question 8

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.

Question 9

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.

Question 10

A fact table is populated by using which transformation in SAS Data Integration Studio?

Options:

A.

SCD Type 2 Loader

B.

Data Validation

C.

Lookup

D.

DataFlux IS Job

Load More A00-260 Questions
Page: 1 / 7
Total 70 questions
Get A00-260 Full Access Download A00-260 PDF