SAS Certification Exams

Testking A00-206 Exam :SAS Warehouse Technology Exam

Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcamp

SAS Warehouse Technology Examtk sas a00-206 Interactive Testing Engine Included!
65 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Add to Cart
SAS Institute A00-206 Exam

Exam A00-206: SAS Warehouse Technology

If you work as an IT person for a corporation or large business, and you have experience with designing, managing, and deploying a data warehouse, using SAS technologies, including the ability to set up a warehouse environment, build the warehouse, and deploy as well as maintain the warehouse; you would do well to get certified. This way you will be qualified to work on such a system. To get certified, you will have to pass the A00-206: SAS Warehouse Technology exam.
By taking and passing the A00-206 exam, you provide proof that you have experience to perform standard transformations which will include resolving data quality issues using the SAS Data Quality Solution. You also must prove you know how to extract and load data using the SAS/ACCESS interfaces, SAS Data Surveyors, and other SAS technologies.

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 12
Which software vendor provides the bridges necessary to import non-standard Common
Warehouse Metamodel (CWM) compliant metadata into SAS ETL Studio?

A. Platform Computing, Inc.
B. DataFlux Corporation
C. SAS Institute, Inc.
D. MetaIntegration Technology, Inc.

Answer: D

QUESTION 13
Which statement is true about the Quality Knowledge Base (QKB) in the SAS Data
Quality Solution?

A. The QKB is required by dfPower Studio applications, but not by the SAS Data
Quality Server.
B. The QKB is used to translate data as it is transferred between dfPower Studio
applications and SAS ETL Studio.
C. The QKB facilitates the sharing of source data between dfPower Studio applications
and SAS ETL Studio.
D. The QKB facilitates the sharing of data quality rules between dfPower Studio
applications and the SAS Data Quality Server.

Answer: D

QUESTION 16
In a SAS data warehouse environment, which SAS servers enable high-performance data
delivery to aid in optimization of queries?

A. SAS Metadata Server and SAS DATA Step Batch Server
B. SAS OLAP Server and SAS Scalable Performance Data Server
C. SAS Workspace Server and SAS OLAP Server
D. SAS DATA Step Batch Server and SAS Scalable Performance Data Server

Answer: B

QUESTION 17
In the SAS SQL Procedure, which SAS LIBNAME option can be set to enable a SAS
multi-threaded RDBMS read?

A. DIRECT_SQL
B. DBMS_SQL
C. PASSTHRU
D. DBSLICEPARM

Answer: D

QUESTION 18
In SAS ETL Studio, which Library Resource Template in the New Library Wizard
creates a library reference to access one or more tables defined in an XML file?

A. SAS Base Engine Library
B. SXLE Library
C. SGML Library
D. Generic Library

Answer: D
Free down:Pass4suer a00-206
Free down:Testking a00-206

Related Posts

• Testinside Sas A00-206
• Pass4sure SAS Institute Exam a00-206

Related Posts

• Testinside Sas A00-206
• Pass4sure SAS Institute Exam a00-206

Tags: a00-206