SAS Certification Exams

Testinside Sas A00-206

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

sas warehouse technology exam : A00-206 ExamExam Number/Code: A00-206
Exam Name: sas warehouse technology exam
Questions and Answers: 65 Q&As
Price: $125.00
Update Time: 2008-6-21

“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?

Free A00-206 Demo Download
QUESTION 34
Which connection type is used in SAS Management Console to support a load-balanced
Stored Process or Workspace Server?

A. MP CONNECT
B. Multi-thread
C. COM/DCOM
D. MultiBridge

Answer: D

QUESTION 35
Why does SAS ETL Studio need to access a SAS Workspace Server?

A. to submit SAS code to remote machines
B. to store temporary metadata
C. to access data and execute code
D. to schedule temporary jobs

Answer: C

QUESTION 36
Which table attributes does the SAS ETL Studio Source Designer extract from the source
database and save in the warehouse metadata?
I.Check key
II.Foreign key
III.Not Null key
IV.Unique key

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

Answer: D

QUESTION 37
When creating user-written transformations in SAS ETL Studio, what must be done to
ensure the automatic status-handling macro variables are assigned the correct values?

A. set the TRANS_RC macro variable to the return code of the transformation
B. set the JOB_RC macro variable to the return code of the transformation
C. call the %RCSET macro with the return code of the transformation
D. call the %SYSERR macro with the return code of the transformation

Answer: C

QUESTION 38
In SAS ETL Studio, when checking in objects from a project repository to a
change-managed repository, which objects are checked in?

A. all objects
B. grouped objects and their associated objects
C. the selected objects only
D. the selected objects and all associated objects

Answer: A

QUESTION 39
In the SAS Intelligence Platform, where is descriptive information about data libraries
stored?

A. on the SAS Workspace Server
B. on the SAS Information Server
C. on the SAS Foundation Server
D. on the SAS Metadata Server

Answer: D

QUESTION 40
In SAS Management Console, what is enabled by the Schedule Manager?
I.ability to start and halt the execution of the scheduled flow
II.ability to create job flows, which contain one or more jobs for scheduling
III.ability to create dependencies for jobs in the flow, which can be based on time, other
jobs, or files
IV.ability to schedule a flow to run, based on specified conditions; such as run once, run
manually, or run whenever a dependency is met

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

Answer: B

QUESTION 41
In the SAS Management Console Metadata Manager plug-in, which repository action
erases the selected repository, the repository contents, and all metadata that defines the

repository?

A. Remove
B. Delete
C. Destroy
D. Purge

Answer: B

QUESTION 42
In the SAS ETL Studio Target Designer, metadata can be registered for tables in which
formats?

A. SAS data sets and tables for which ODBC drivers are available
B. any format that SAS can access
C. SAS data files and views
D. SAS data sets and flat files

Answer: B
QUESTION 43
Which object(s) is/are evaluated by the SAS Management Console Metadata
Authorization Facility when making an authorization decision for an object in a project
repository?
I.Default ACT
II.Access Control Entry
III.Permission Conditions
IV.Security Rule Schema

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

Answer: A

QUESTION 44
How does SAS ETL Studio enable changes in the SAS Metadata Repository as the table
structure changes in the source system?

A. The Update Table Metadata option supports manual synchronization with the table
source structure.
B. Impact Analysis supports manual synchronization with the table source structure.
C. Impact Analysis supports automatic synchronization with the table source structure.
D. The Update Table Metadata option supports automatic synchronization with the table
source structure.
QUESTION 45
Which statements are true about the relationship between dimension, hierarchy, level,
and member within SAS OLAP cubes?
I.Members are the values of a level.
II.Hierarchies are navigation paths within a dimension.
III.Members are groups of variables within a hierarchy.
IV.Levels are stored aggregations within hierarchies of OLAP cubes.

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

Answer: A

QUESTION 46
What is stored for a Metadata Profile created in SAS ETL Studio?

A. the location of the metadata library
B. the name of the default application server
C. the port number of the metadata server
D. the authentication domain name

Answer: C

QUESTION 47
A mail order catalog manager wants to utilize data from two distinct tables. Table A
contains data that have been systematically cleansed. Table B contains data purchased
from a third-party vendor that have not been systematically cleansed. Which SAS
procedure joins the records in the two tables, when the key values are not equal?

A. DQCorrelate
B. DQConform
C. DQMatch
D. DQScheme

Answer: C

QUESTION 48
Which repository tree can be defined in SAS Management Console?

A. A Project Repository depends on two Custom Repositories, which depend on the
Foundation Repository.
B. Two Project Repositories depend on a Custom Repository, which depends on the
Foundation Repository.
C. A Custom Repository depends on two Project Repositories, which depend on the
Foundation Repository.
D. Two Custom Repositories depend on a Project Repository, which depends on the
Foundation Repository.

Answer: B

QUESTION 49
In SAS ETL Studio, user-written code is used in the transformation portion of the ETL
process. To ensure the creation of the Process Target Table is in compliance with its
metadata specifications, what should be the name of the output object?

A. the name of the loader object
B. the name of the target object
C. the value of an automatic macro variable
D. the value of a user-defined macro variable

Answer: C

QUESTION 50
Which statement is true about defining target table columns using the Target Designer in
SAS ETL Studio?

A. Column metadata is synchronized with columns in the table from which they are
selected by the Impact Analysis Wizard.
B. Column metadata is independent of columns in the table from which they are selected.
C. Column metadata is imported from a data dictionary columns table.
D. Column metadata is linked to columns in the table from which they are selected.

Answer: B

QUESTION 51
In addition to ReadMetadata and WriteMetadata, which metadata layer access control
permission(s) is/are enforced by the SAS Metadata Server?

A. DeleteMetadata, CheckinMetadata, CheckoutMetadata
B. CheckinMetadata and CheckoutMetadata only
C. DeleteMetadata only
D. CheckinMetadata only

Answer: D

QUESTION 52
In SAS ETL Studio, how are data sources that will be used with the DQSCHEME and

DQMATCH procedures registered to the SAS metadata?

A. They can be registered only with the Source Designer in SAS ETL Studio.
B. They can be registered with the ODBC Manager.
C. They can be registered only with dfPower Studio.
D. They can be registered with both Source Designer in SAS ETL Studio and dfPower
Studio.

Answer: A

QUESTION 53
What information does the SAS Metadata Repository contain?
I.user IDs, passwords, server definitions
II.physical structure and format of the data
III.business metadata in non-technical terms
IV.business rules for the extract, transformation and load process

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

Answer: D

QUESTION 54
In the SAS Data Quality solution, which data quality technique is the most appropriate
for performing householding?

A. Address Verification
B. Match Code Generation
C. Augmentation
D. Standardization

Answer: B

QUESTION 55
In the SAS Data Quality solution, which data cleansing step involves an initial
investigation of the data to identify potential data quality issues, such as missing data,
uniqueness, redundant data, maximum field length and number of distinct data patterns?

A. Data Verification
B. Data Profiling
C. Data Validation
D. Data Analysis

Answer: B

TestInside offers free demo for A00-206 exam ( sas warehouse technology exam). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Free down:Pass4suer a00-206
Free down:Testking a00-206

Related Posts

• Testking A00-206 Exam :SAS Warehouse Technology Exam
• Pass4sure SAS Institute Exam a00-206

Related Posts

• Testking A00-206 Exam :SAS Warehouse Technology Exam
• Pass4sure SAS Institute Exam a00-206

Tags: a00-206