Pass4sure SAS Institute Exam a00-206
Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcampsas warehouse technology exam : a00-206 Exam
Exam Number/Code: a00-206
Exam Name: sas warehouse technology exam
Questions Type: Single choice,
“sas warehouse technology exam”, also known as a00-206 exam, is a SAS Institute certification.
Preparing for the a00-206 exam? Searching a00-206 Test Questions, a00-206 Practice Exam, a00-206 Dumps?
QUESTION 19
In SAS ETL Studio, which fields are included in the information recorded in the Change
Management history record?
A. Version, Name, User, Date/Time
B. Repository, Name, Description, Date/Time
C. Repository, Date/Time, Status, Name
D. Version, User, Description, Status
Answer: A
QUESTION 20
Which SAS-recommended default account is used to impersonate clients already
authenticated on the metadata server and prevent having user accounts on multiple
back-end servers?
A. sastrust
B. sassrv
C. saswbadm
D. sasadm
Answer: A
QUESTION 21
In SAS ETL Studio, what does the User Written Code Transformation enable the user to
do?
A. identify a SOURCE entry in a SAS catalog in which a SAS program is stored
B. write a SAS program utilizing a Code Wizard
C. identify an external file in which a SAS program is stored
D. identify an external file or a SOURCE entry in a SAS catalog in which a SAS program
is stored
Answer: C
QUESTION 22
When creating an extract, transform, and load process flow in SAS ETL Studio, which
macro variable is needed to pass the name of the output data set to other steps in the
process flow?
A. SYSLAST
B. SYSINFO
C. SYSJOBID
D. SYSPARM
Answer: A
QUESTION 23
In SAS ETL Studio, what is the function of the Drop Table option in the Loader
Transformation properties?
A. mark all data as deleted, keep those rows in physical storage, and append new rows
B. mark all data as deleted and create a new version of the table
C. delete the physical table and re-create it
D. delete data from a table, but not re-create it
Answer: C
QUESTION 24
An ETL developer needs to duplicate an object from a change-managed repository in a
project repository without checking out the object. The developer then needs to remove
this object from the project repository. Which actions are required in SAS ETL Studio to
achieve this?
A. Fetch, Destroy
B. Copy, Destroy
C. Fetch, Delete
D. Copy, Delete
Answer: C
QUESTION 25
In SAS ETL Studio, what can be used to register a metadata object in the Process
Library?
I.the Metadata Importer
II.the Metadata Transformer
III.the Transformation Importer
IV.the Transformation Generator
A. I and II
B. III and IV
C. IV only
D. II only
Answer: B
QUESTION 26
In SAS ETL Studio, Impact Analysis or Reverse Impact Analysis provides a diagram and
report. What is identified as having been affected?
I.Tables
II.Columns
III.Libraries
IV.Transformations
A. I, II and IV
B. I and II only
C. II, III and IV
D. III and IV only
Answer: A
QUESTION 27
Which macro variable contains the name of the target data set in custom transformations
used by the SAS ETL Studio Process Designer?
A. _TARGET
B. _SYSOUT
C. _OUTPUT
D. _TAROUT
Answer: C
QUESTION 28
In SAS ETL Studio, a transformation is exported into which type of file?
A. Stored Process
B. text
C. compiled program
D. XML
Answer: D
QUESTION 29
In SAS Management Console, which components are required for promotion and
replication?
A. SAS Replication Server, SAS Administration Server and SAS Workspace Server
B. Foundation Repository, Custom Repository and Project Repository
C. SAS Workspace Server, SAS Stored Process Server and SAS/CONNECT Server
D. SAS Administration Server, SAS Source Server and SAS Target Server
Answer: D
QUESTION 30
A connection is made to the SAS Metadata Server.
The following SAS program is submitted:
libname mymeta meta ? repname = ‘Foundation’ metaout = XXXXXXXX;
data mymeta.class;
set sashelp.class;
stop;
run;
What is the value of the METAOUT = option that specifies to write only the metadata to
the SAS Metadata Server?
A. metaserv
B. data
C. meta
D. metadata
Answer: C
QUESTION 31
Which statement is true about applying a data standardization scheme?
A. It has no impact on the quality of householding.
B. It must be performed before address verification can be performed.
C. It makes data profiling unnecessary.
D. It improves the quality of the match code generation.
Answer: D
QUESTION 32
In SAS ETL Studio, what is the difference between using the Source Designer to register
SAS tables and using the appropriate SAS Data Surveyor to register Enterprise Resource
Planning (ERP) system tables?
A. The SAS system metadata can be searched by several criteria to find the relevant SAS
table prior to registering it, which is not an option when registering ERP tables.
B. The ERP system metadata can be searched by several criteria to find the relevant ERP
table prior to registering it, which is not an option when registering SAS tables.
C. The ERP system lookup tables can be searched by several criteria to find the relevant
ERP table prior to registering it, which is not an option when registering SAS tables.
D. The SAS system dictionary tables can be searched by several criteria to find the
relevant SAS table prior to registering it, which is not an option when registering ERP
tables.
Answer: B
With the complete collection of questions and answers, Pass4sure has assembled to take you through 65 questions to your a00-206 Exam preparation. In the a00-206 exam resources, you will cover every field and category in SAS Institute Systems helping to ready you for your successful SAS Institute Certification.
Questions and Answers : 65 questions
Updated: May 12th , 2008
Market Price: $159.99
Member Price: $125.99
Free down:Pass4suer a00-206
Free down:Testking a00-206
Related Posts
Related Posts
Tags: a00-206
Leave a Reply