A00-260 Exam Questions
73 real A00-260 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1Work with jobs
In the following display, can status handling be enabled for both the Extract transformation and the Sort transformation?
Return Code Check transformationStatus handlingJob flow designError handling - Question #2Create and work with metadata for SAS Data Integration Studio
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...
SAS Macro VariablesTranspose TransformationPrecode/PostcodeData Integration Studio - Question #3Create and work with metadata for SAS Data Integration Studio
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?
stored processesSAS Data Integration Studiotesting/executionSAS Enterprise Guide - Question #4Create and work with metadata for SAS Data Integration Studio
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...
Identity hierarchyAccess controlSecurity precedenceSAS authorization - Question #5Work with jobs
Which statement best describes a deployment directory as used in the Schedule Manager in SAS Management Console?
deployment directorySchedule ManagerSAS Management Consolejob deployment - Question #6Work with jobs
In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs?
job schedulingjob flow dependenciesScheduling ManagerSAS Management Console - Question #7Work with jobs
Which of the following are SAS Data Integration Studio job deployment types? (Choose two.)
SAS Data Integration StudioJob Deployment TypesStored ProcessInformation Map - Question #8Work with jobs
A SAS Data Integration Studio job was successfully scheduled and the appropriate event for triggering it occurred. Which statement describes the situation correctly?
Job schedulingScheduling serverSAS Data Step BatchJob execution - Question #9Create and work with metadata for SAS Data Integration Studio
Which statement defines the characteristics of a SAS Stored Process?
SAS Stored ProcessMetadataServer-based ProgramsSAS Programming - Question #10Work with jobs
Which batch server is queried to retrieve the command needed to run traditional .SAS programs having DATA and PROC steps?
Batch serversDATA StepPROC stepsSAS Data Integration - Question #11Create and work with metadata for SAS Data Integration Studio
In SAS Data Integration Studio, primary keys, foreign keys and unique keys can be specified/defined in which location?
Database KeysTable MetadataSAS DIS PropertiesData Modeling - Question #12Create and work with metadata for SAS Data Integration Studio
When using the Table Loader transformation in SAS Data Integration Studio to update an existing table containing indexes or constraints, which statement is true?
Table Loader transformationIndexes and constraintsLoad stylesTarget table metadata - Question #13Create and work with metadata for SAS Data Integration Studio
In SAS Data Integration Studio, an index can be specified/defined in which location?
SAS Data Integration Studioindexestable metadatametadata properties - Question #14Create and work with metadata for SAS Data Integration Studio
Which statement is FALSE regarding foreign keys?
Foreign KeysDatabase ConstraintsRelational DesignPrimary Keys - Question #15Work with jobs
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...
Table LoaderAppend to ExistingLoad StylesSAS Code Generation - Question #16Create and work with metadata for SAS Data Integration Studio
Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)
Table LoaderSAS DI StudioConstraintsPermanent tables - Question #17Work with jobs
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...
Table LoaderUpdate/InsertLoad StylesConfiguration Options - Question #18Work with jobs
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?
Table LoaderIndexesConfiguration OptionsLoad Process - Question #19Create and work with metadata for SAS Data Integration Studio
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...
Table indexesMetadata viewingUI navigationTable properties - Question #20Create and work with metadata for SAS Data Integration Studio
Which statement is true regarding SAS packages created in SAS Data Integration Studio?
SAS packagesmetadata managementimport/exportData Integration Studio - Question #21Work with jobs
Which action is required for enabling performance statistics on the executing SAS Workspace Server?
Performance StatisticsWorkspace Server ConfigurationLogging FacilityDiagnostics - Question #22Work with jobs
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...
column mappingdata typeslength mismatchtruncation warnings - Question #23Work with jobs
The profile reports generated in dfPower Profile jobs are viewed:
dfPower ProfileProfile ReportsReport ViewerJobs - Question #24Work with jobs
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...
Clear Projects actionChecked out metadataProject repository lockDI job state management - Question #25Create and work with metadata for SAS Data Integration Studio
Which statement best describes the DataFlux Integration Server?
DataFlux Integration ServerSOAP protocolApplication serverService architecture - Question #26Implement change management
The purpose of change management in SAS Data Integration Studio is to manage:
change managementmetadata objectsSAS DISmetadata server - Question #27Create and work with metadata for SAS Data Integration Studio
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:
SAS Information Delivery PortalContent DistributionWeb Browser AccessMetadata Objects - Question #28Work with jobs
A user needs to find out who has the SAS Data Integration Studio job "Create Tables" checked out. What action should the user perform?
Checkout statusJob managementHistory menuSAS DIS - Question #29Create and work with metadata for SAS Data Integration Studio
Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?
SAS Code transformationMacro variablesDIS optionsTransformation configuration - Question #30Create and work with metadata for SAS Data Integration Studio
How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?
transformationstesting optionsinteractive validationSAS DIS workflow - Question #31Create and work with metadata for SAS Data Integration Studio
Within SAS Data Integration Studio, how many inputs and outputs can be defined for a Generated transformation?
Generated TransformationsInput/Output ConstraintsMetadata ConfigurationData Integration Studio - Question #32Create and work with metadata for SAS Data Integration Studio
How can you make a SAS Data Integration Studio Generated transformation option required?
Transformation OptionsRequired ValuesConfigurationMetadata - Question #33Implement change management
The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?
SCD Type 2Dimension TablesSlowly Changing DimensionsData Warehouse - Question #34Work with jobs
In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?
Lookup transformationDimension tablesSAS DIS transformationsData joining - Question #35Implement change management
In SAS Data Integration Studio, surrogate and retained key values are:
SCD Type 2Surrogate keysRetained keysDimension tables - Question #36Create and work with metadata for SAS Data Integration Studio
A fact table is populated by using which transformation in SAS Data Integration Studio?
Lookup transformationFact tablesSAS DISData warehouse ETL - Question #37Implement change management
When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?
SCD Type 2Slowly Changing DimensionsChange DetectionDimension Versioning - Question #38Create and work with metadata for SAS Data Integration Studio
In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values?
surrogate keysretained keyskey generationData Integration Studio - Question #39Implement change management
In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?
SCD Type 2business keyrow matchingdimensional modeling - Question #40Create and work with metadata for SAS Data Integration Studio
In SAS Data Integration Studio, where must the columns included in a business key exist?
business keydimension tablessource tablesmetadata - Question #41Create and work with metadata for SAS Data Integration Studio
Which action is performed by the Lookup transformation in SAS Data Integration Studio?
Lookup transformationTable joinsData consolidationSAS Data Integration Studio - Question #42Implement change management
The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following?
SCD Type 2Datetime trackingSlowly Changing DimensionsHistorical records - Question #43Implement change management
When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?
SCD Type 2Change DetectionDimension LoadingNon-key Columns - Question #44Create and work with metadata for SAS Data Integration Studio
Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?
Register Tables wizardMetadata storageSAS FoldersMetadata registration - Question #45Create and work with metadata for SAS Data Integration Studio
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...
external filesfile registrationmetadata creationfile formats - Question #46Create and work with metadata for SAS Data Integration Studio
Registering metadata for an ODBC data source involves registering:
ODBC metadata registrationServer definitionsSAS librariesData source configuration - Question #47Create and work with metadata for SAS Data Integration Studio
SAS Data Integration Studio is dependent on which administration functions?
SAS Data Integration StudioApplication ServersInfrastructure DependenciesAdministration - Question #48Work with jobs
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?
Job deploymentSAS Management ConsoleWeb Service configurationStored Process - Question #49Create and work with metadata for SAS Data Integration Studio
Which of the following is NOT defined as part of the New Library Wizard?
SAS DISNew Library WizardLibrary metadataLibrary configuration - Question #50Create and work with metadata for SAS Data Integration Studio
Metadata repositories are a collection of files in a physical folder. In what format are the files stored?
metadata repositoriesSAS data setsfile formatstorage structure