A00-260 Exam Questions
73 real A00-260 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1
In the following display, can status handling be enabled for both the Extract transformation and the Sort transformation?
- Question #2
When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output...
- Question #3
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?
- Question #4
An identity hierarchy specifies a list of identities and the order of precedence of those identities. Which listing of identities is ranked from highest priority to lowest priority...
- Question #5
Which statement best describes a deployment directory as used in the Schedule Manager in SAS Management Console?
- Question #6
In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs?
- Question #7
Which of the following are SAS Data Integration Studio job deployment types? (Choose two.)
- Question #8
A SAS Data Integration Studio job was successfully scheduled and the appropriate event for triggering it occurred. Which statement describes the situation correctly?
- Question #9
Which statement defines the characteristics of a SAS Stored Process?
- Question #10
Which batch server is queried to retrieve the command needed to run traditional .SAS programs having DATA and PROC steps?
- Question #11
In SAS Data Integration Studio, primary keys, foreign keys and unique keys can be specified/defined in which location?
- Question #12
When using the Table Loader transformation in SAS Data Integration Studio to update an existing table containing indexes or constraints, which statement is true?
- Question #13
In SAS Data Integration Studio, an index can be specified/defined in which location?
- Question #14
Which statement is FALSE regarding foreign keys?
- Question #15
Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regardingAssume that SAS Data In...
- Question #16
Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)
- Question #17
Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding theAssume that SAS Data Int...
- Question #18
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?
- Question #19
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 f...
- Question #20
Which statement is true regarding SAS packages created in SAS Data Integration Studio?
- Question #21
Which action is required for enabling performance statistics on the executing SAS Workspace Server?
- Question #22
Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has defined source columns and defined target columns. One of the source columns, na...
- Question #23
The profile reports generated in dfPower Profile jobs are viewed:
- Question #24
A SAS administrator has performed the "Clear Projects" action to remove the lock on a SAS Data Integration Studio job called "Create Tables" that some user has checked out in their...
- Question #25
Which statement best describes the DataFlux Integration Server?
- Question #26
The purpose of change management in SAS Data Integration Studio is to manage:
- Question #27
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:
- Question #28
A user needs to find out who has the SAS Data Integration Studio job "Create Tables" checked out. What action should the user perform?
- Question #29
Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?
- Question #30
How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?
- Question #31
Within SAS Data Integration Studio, how many inputs and outputs can be defined for a Generated transformation?
- Question #32
How can you make a SAS Data Integration Studio Generated transformation option required?
- Question #33
The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?
- Question #34
In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?
- Question #35
In SAS Data Integration Studio, surrogate and retained key values are:
- Question #36
A fact table is populated by using which transformation in SAS Data Integration Studio?
- Question #37
When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?
- Question #38
In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values?
- Question #39
In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?
- Question #40
In SAS Data Integration Studio, where must the columns included in a business key exist?
- Question #41
Which action is performed by the Lookup transformation in SAS Data Integration Studio?
- Question #42
The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following?
- Question #43
When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?
- Question #44
Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?
- Question #45
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 con...
- Question #46
Registering metadata for an ODBC data source involves registering:
- Question #47
SAS Data Integration Studio is dependent on which administration functions?
- Question #48
The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored Process requires additional set up that is performed in which client application?
- Question #49
Which of the following is NOT defined as part of the New Library Wizard?
- Question #50
Metadata repositories are a collection of files in a physical folder. In what format are the files stored?