Question 1.
Which SAS Management Console definitions are required on the source and target servers for replication and promotion?

A. Source: SAS Metadata Server, SAS Workspace Server,
    Target: SAS Metadata Server, SAS\CONNECT Server, IOM Spawner
B. Source: SAS Metadata Server, SAS\CONNECT Server 
    Target: SAS Metadata Server, SAS Workspace Server, IOM Spawner
C. Source: SAS Metadata Server, SAS Workspace Server, IOM Spawner
    Target: SAS Metadata Server, SAS\CONNECT Server
D. Source: SAS Metadata Server, SAS\CONNECT Server, IOM Spawner
    Target: SAS Metadata Server, SAS Workspace Server

Answer: C

Question 2.
How can custom transformation objects be integrated into the Process Library within SAS ETL Studio?

A. implement as Java plug-ins or SAS code transformation templates
B. implement as macro calls within a user exit
C. implement as Java plug-ins only
D. implement as SAS code transformation templates or macro calls within a user exit

Answer: A

Question 3.
In SAS ETL Studio, what is stored as a metadata identity?

A. a user or a group of users of the metadata environment
B. a list of the warehouse server names and port numbers
C. the libraries containing the data in the warehouse
D. the location of the SAS Metadata Server

Answer: A

Question 4.
In SAS ETL Studio, which alert actions can be selected from the Status Handling tab as a property of the job?
I.Send email.
II.Abort the process.
III.Send the entry to a dataset.
IV.Call a macro from a SAS Autocall Library.

A. I, II, III and IV
B. I and II only
C. III and IV only
D. I, II and III only

Answer: A

Question 5.
In SAS ETL Studio, what does a Transformation Template contain?

A. a transformation object and one or more drop zones for tables and/or transformations
B. sources and/or targets
C. the process flow diagram for a job
D. a transformation object and the process flow diagram for a job

Answer: A

Question 6.
Which wizards are used by SAS ETL Studio to define and load star schemas in a data warehouse?

A. Metadata Designer and Source Designer
B. Source Designer and Process Designer
C. Target Designer and Metadata Designer
D. Target Designer and Process Designer

Answer: D

Question 7.
What happens when a job is deployed for scheduling in SAS ETL Studio?

A. The job appears in the Flow Manager as ready for scheduling.
B. The source code is generated and saved as a SAS program.
C. The Job Dependencies window opens to allow user input.
D. A scheduler system receives information on when to run the job.

Answer: B

Question 8.
In SAS ETL Studio, which action generates and stores code to a file, which allows the job to be included in a job flow in SAS Management Console?

A. Register to Metadata
B. Publish to Deployment Directory
C. Export Job to File
D. Deploy for Scheduling

Answer: D

Question 9.
Click the Exhibit button to view a table that was created as a result of performing an Integration action from within dfPower Studio. 

What is represented by the column labeled "???" in the exhibit?
 

A. Match Code
B. Name Encryption
C. Merge Identifier
D. Cluster Group

Answer: A

Question 10.
When using SAS ETL Studio to import metadata with a MITI model bridge plug-in,

which metadata are captured from the model file in addition to column type and column length?
I.keys
II.integrity constraints
III.schema information
IV.connection information

A. II and IV only
B. I, II and III
C. I and III only
D. II, III and IV

Answer: B

	Web www.certsbraindumps.com