A00-260 Exam Questions
73 real A00-260 exam questions with expert-verified answers and explanations. Page 2 of 2.
- Question #51Create and work with metadata for SAS Data Integration Studio
Which statement correctly defines a System DSN?
System DSNData Source NameAccess PermissionsData Connectivity - Question #52Implement change management
When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?
SAS package exportfile storageDIS configuration - Question #53Work with jobs
In SAS Data Integration Studio, which output format is supported for the default "out-of-the-box" job report?
Job reportsOutput formatsSAS Data Integration StudioHTML output - Question #54Create and work with metadata for SAS Data Integration Studio
Which statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard? 1. You can access metadata for any column from any table already registered...
metadata managementNew Tables wizardcolumn overrideSAS DIS - Question #55Work with jobs
Consider the job flow diagram in the display. Which of these objects has parameters defined for it?
job flow diagramparametersinner jobobject configuration - Question #56Work with jobs
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 Stud...
Extract transformationData filteringRow subsettingSAS DIS - Question #57Work with jobs
In the following display, can status handling be enabled for the Extract transformation?
Status HandlingExtract TransformationReturn Code CheckJob Flow Design - Question #58Work with jobs
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 da...
Data ValidationError DetectionData Quality ChecksPre-load Validation - Question #59Work with jobs
When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?
SQL joinsImplicit vs explicit joinsSAS DIS transformationsInner join syntax - Question #60Work with jobs
How do you enable performance statistics for a SAS Data Integration Studio job?
Performance StatisticsJob ConfigurationRuntime MonitoringSAS DI Studio - Question #61Work with jobs
Which statement regarding propagation is FALSE?
PropagationJob FlowAutomatic PropagationSAS DIS - Question #62Create and work with metadata for SAS Data Integration Studio
Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located in:
SQL Join transformationExpression BuilderExpression validationData Integration Studio - Question #63Create and work with metadata for SAS Data Integration Studio
Which definition cannot be imported using a SAS Metadata Bridge?
Metadata BridgeMetadata importsServer definitionsMetadata objects - Question #64Create and work with metadata for SAS Data Integration Studio
Given the table below as a source table for the Transpose transformation in SAS Data Integration Studio: In the Options tab in the Properties window for the Transpose transformatio...
PROC TRANSPOSETranspose transformationVAR/ID/BY statementsData reshaping - Question #65Create and work with metadata for SAS Data Integration Studio
Within SAS Data Integration Studio, which type of expression can be created using the Expression Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression...
Expression BuilderWhere clauseExtract transformationExpression types - Question #66Work with jobs
Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?
job parametersloop structuresjob executionparameter mapping - Question #67Work with jobs
Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?
Data Validation transformationde-duplicationdata quality detectionerror handling - Question #68Create and work with metadata for SAS Data Integration Studio
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...
Data Integration StudioLookup StandardizationScheme Repository TypesData Quality - Question #69Work with jobs
In SAS Data Integration Studio, which statement is FALSE regarding status handling?
status handlingcondition/action pairsjob executionerror management - Question #70Work with jobs
The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE regarding the Platform Process Manager server?
Process schedulingJob managementPlatform SuiteServer capabilities - Question #71Work with jobs
Which statement regarding scheduling SAS Data Integration Studio jobs is true?
Job schedulingDeployment workflowSAS Management ConsoleSAS Data Integration Studio - Question #72Create and work with metadata for SAS Data Integration Studio
A platform administrator wants to physically segregate the physical storage for metadata in a single environment. What should the platform administrator create?
metadata repositoriescustom repositoriesstorage segregationplatform administration - Question #73Create and work with metadata for SAS Data Integration Studio
Within SAS Data Integration Studio, which one of the following is NOT an option available from the File-> New menu choice under External File grouping?
external file typesSAS Data Integration StudioFile menumetadata