Sas warehouse technology exam -- A00-206

http://www.infopediaonline.com/Which statement is true about OLAP hierarchies defined in SAS OLAP Cube Studio?
A - Hierarchies are always balanced.
B - No levels can have missing values.
C - Missing members affect the drill path.
D - Only a blank space or single period can be used to designate a missing member.
Answer: Chttp://www.infopediaonline.com/
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 - Version, User, Description, Status
C - Repository, Date/Time, Status, Namehttp://www.infopediaonline.com/
D - Repository, Name, Description, Date/Time
Answer: A
Which are functions of the SAS ETL Custom Tree?
I. define custom links between metadata objects
ll. define authorizations according to business requirements
lll. define and structure ETL metadata according to business rules
IV. define table relationships according to their relational constraints
A - l and Ill
B - l and IV
C - II and Ill
D - II and IV
Answer: C
In the SAS SQL Procedure, which SAS LIBNAME option can be set to enable a SAS multi-
threaded RDBMS read?
A - DBMS_SQL
B - PASSTHRUhttp://www.infopediaonline.com/
C - DIRECT_SQL
D - DBSLICEPARMhttp://www.infopediaonline.com/
Answer: D
Which software vendor provides the bridges necessary to import non-standard Common
Warehouse Metamodel (CWM) compliant metadata into SAS ETL Studio?
A - SAS Institute, Inc.http://www.infopediaonline.com/
B - DataFlux Corporation
C - Platform Computing, Inc.
D - Metalntegration Technology, Inc.
Answer: D
In SAS Management Console, what is enabled by the Schedule Manager?
l. ability to start and halt the execution of the scheduled flow
lI. ability to create job flows, which contain one or more jobs for scheduling
Ill. ability to create dependencies for jobs in the flow, which can be based on time, other jobs, or
files
lV. 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 - l and Ill only
B - II and Ill only
C - I, II and Ill
D - II, Ill and IVhttp://www.infopediaonline.com/
Answer: D
Which connection type is used in SAS Management Console to support a load-balanced Stored
Process or Workspace Server?
A - MultiBridge
B - Multi-thread
C - COM/DCOM
D - MP CONNECThttp://www.infopediaonline.com/
Answer: A
Which statement is true about applying a data standardization scheme?
A - It makes data profiling unnecessary.
B - It has no impact on the quality of house holding.http://www.infopediaonline.com/
C - It improves the quality of the match code generation.
D - It must be performed before address verification can be performed.
Answer: Chttp://www.infopediaonline.com/
In SAS ETL Studio, a transformation is exported into which type of file?
A - XML
B - Text
C - Stored Process
D - Compiled program
Answer: A
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 with the ODBC Manager.
B - They can be registered only with dfPower Studio.
C - They can be registered only with the Source Designer in SAS ETL Studio.
D - They can be registered with both Source Designer in SAS ETL Studio and dfPower Studio.
Answer: Chttp://www.infopediaonline.com/
What happens when a job is deployed for scheduling in SAS ETL Studio?
A - The Job Dependencies window opens to allow user input.http://www.infopediaonline.com/
B - The source code is generated and saved as a SAS program.
C - The job appears in the Flow Manager as ready for scheduling.
D - A scheduler system receives information on when to run the job.
Answer: B
In the SAS Data Quality solution, which data quality technique is the most appropriate for
performing house holding?
A - Augmentation
B - Standardization
C - Address Verification
D - Match Code Generationhttp://www.infopediaonline.com/
Answer: D
A connection is made to the SAS Metadata Server.
The following SAS program is submitted:http://www.infopediaonline.com/
Iibname mymeta meta ? repname = ‘Foundation’ metaout = XXXXXXXX;
data mymeta.class;
set sashelp.class;
stop;
run;http://www.infopediaonline.com/
What is the value or the METAOUT = option that specifies to write only the metadata to the SAS
Metadata Server?http://www.infopediaonline.com/
A - Data
B - Meta
C - Metadata
D - Metaserv
Answer: B
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?
l. keys
ll. integrity constraints
lll. schema information
IV. connection information
A - l and Ill only
B - II and IV onlyhttp://www.infopediaonline.com/
C - I, II and Ill
D - ll, lll and lV
Answer: C

What globally activates execution of Application Response Measurement (ARM) macros?
A - %let_armexec = 1;
B - %let_armexec = on;
C - %let _armexec = yes;
D - The _ARMEXEC macro variable is active by default.http://www.infopediaonline.com/
Answer: A
What information does the SAS Metadata Repository contain?
I. user IDs, passwords, server definitions
Il. physical structure and format of the data
IlI. business metadata in non-technical terms
IV. business rules for the extract, transformation and load process
A - l and II only
B - Ill and IV only
C - II, III and IV only
D - l, Il, lIl and lV
Answer: D
In SAS ETL Studio, what is the difference between using the Source Des igner to register SAS
tables and using the appropriate SAS Data Surveyor to register Enterprise Resource Planning
(ERP) system tables?
A - 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.http://www.infopediaonline.com/
B - 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.
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 where registering ERP tables.
Answer: A
Why does SAS ETL Studio need to access a SAS Workspace Server?
A - To schedule temporary jobs
B - To store temporary metadata
C - To access data and execute code
D - To submit SAS code to remote machines
Answer: C
In SAS ETL Studio, how does the SOD Type 2 Loader perform updates?
A - By writing a new value over an old value
B - By moving an old value into a new column
C - By creating a new row when a value changes in an oldhttp://www.infopediaonline.com/ row
D - By writing a new value into the column that contains the most recent value
Answer: C
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 target object
B - The name of the loader object
C - The value of an automatic macro variable
D - The value of a user-defined macro variable
Answer: Chttp://www.infopediaonline.com/
Which dfPower Studio technology allows the data quality steward to edit elements contained
within the Quality Knowledge Base for use within the SAS Data Quality Solution?
A - dfPower Extend
B - dtPower Customize
C - dtPower Standardize
D - dfPower Configurator
Answer: B
In SAS ETL Studio, which are Target Designer wizards?
l. OLAP Cube Wizard
II. Target Table Wizard
Ill. Source Table Wizard
IV. Target Library Wizard
A - l and II only
B - II and Ill only
C - II and IV
D - I, II and Ill
Answer: A
In the SAS ETL Studio Target Designer, metadata can be registered for tables in which formats?
A - SAS data files and views
B - SAS data sets and flat files
C - Any format that SAS can accesshttp://www.infopediaonline.com/
D - SAS data sets and tables for which ODBC drivers are available
Answer: C
In SAS ETL Studio, what is the Function of the Drop Table option in the Loader Transformation
properties?
A - Delete the physical table and re-create it
B - Delete data from a table, but not re-create it
C - Mark all data as deleted and create a new version of the table
D - Mark all data as deleted, keep those rows in physical storage, and append new rows
Answer: A
In SAS ETL Studio, which transformation object from the Process Library is used to load multiplehttp://www.infopediaonline.com/
tables at the same time?
A - SAS Sort
B - SAS Splitter
C - SAS Loader
D - SAS DATA step
Answer: B
What does the Source Designer in SAS ETL Studio allow the user to do?
A - Physically create tables only
B - Create relationships between table objects
C - Register table objects to the SAS Metadata Repository only
D - Register table objects to the SAS Metadata Repository and physically create tables
Answer: C
Which SAS Management Console definitions are required on the source and target servers for
replication and promotion?
A - Source: SAS Metadata Server, SAS\CONNECT Server
Target SAS Metadata Server, SAS Workspace Server, IOM Spawnhttp://www.infopediaonline.com/er
B - Source: SAS Metadata Server, SAS\CONNECT Server, IOM Spawner
Target: SAS Metadata Server, SAS Workspace Server
C - Source: SAS Metadata Server, SAS Workspace Server,
Target SAS Metadata Server, SAS\CONNECT Server, IOM Spawner
D - Source: SAS Metadata Server, SAS Workspace Server, IOM Spawner
Target: SAS Metadata Server, SAS\CONNECT Server
Answer: D
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 - SXLE Library
B - SGML Libraryhttp://www.infopediaonline.com/
C - Generic Library
D - SAS Base Engine Library
Answer: C
In SAS ETL Studio, which error conditions can be identified using the Data Validation
transformation?
l. invalid values
ll. duplicate values
Ill. blank or missing values
IV. custom condition values
A - l and II only
B - II and Ill only
C - I, II and Ill only
D - l, ll, lll and lV
Answer: D
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. Columnshttp://www.infopediaonline.com/
III. Libraries
IV. Transformations
A - l and II only
B - Ill and IV only
C - I, II and IV
D - II, III and IV
Answer: C
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 - Call the %RCSET macro with the return code of the transformation
B - Call the %SYSERR macro with the return code of the transformation
C - Set the JOB_RC macro variable to the return code of the transformation
D - Set the TRANS_PC macro variable to the return code of the transformation
Answer: A
Which table attributes does the SAS ETL Studio Source Designer extract from the source
database and save in the warehouse metadata?http://www.infopediaonline.com/
l. Check key
ll. Foreign key
lll. Not Null key
IV. Unique key
A - l and Ill only
B - l and IV only
C - II and Ill only
D - II and IV only
Answer: D
How does SAS ETL Studio enable changes in the SAS Metadata Repository as the table
structure changes in the source system?http://www.infopediaonline.com/
A - Impact Analysis supports manual synchronization with the table source structure.
B - Impact Analysis supports automatic synchronization with the table source structure.
C - The Update Table Metadata option supports manual synchronization with the table source
structure.
D - The Update Table Metadata option supports automatic synchronization with the table source
structure.
Answer: C
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 - Purge
B - Delete
C - Destroy
D - Remove
Answer: B
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 - Export Job to File
B - Register to Metadata
C - Deploy for Scheduling
D - Publish to Deployment Directoryhttp://www.infopediaonline.com/
Answer: C
In the SAS Intelligence Platform, where is descriptive information about data libraries stored?
A - On the SAS Metadata Server
B - On the SAS Foundation Server
C - On the SAS Information Server
D - On the SAS Workspace Server
Answer: A
In SAS ETL Studio, what does the User Written Code Transformation enable the user to do?
A - Write a SAS program utilizing a Code Wizard
B - Identify an external file in which a SAS program is stored
C - Identify a SOURCE entry in a SAS catalog 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: B
A mail order catalog manager wants to utilize data from two distinct tables. Table A contains datahttp://www.infopediaonline.com/
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 - DQMatchhttp://www.infopediaonline.com/
B - DQScheme
C - DQConform
D - DQCorrelate
Answer: A

In SAS Management Console, which components are required for promotion and replication?
A - Foundation Repository, Custom Repository and Project Repository
B - SAS Administration Server, SAS Source Server and SAS Target Server
C - SAS Replication Server, SAS Administration Server and SAS Workspace Server
D - SAS Workspace Server, SAS Stored Process Server and SAS/CONNECT Server
Answer: B
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.http://www.infopediaonline.com/
B - The QKB facilitates the sharing of source data between dfPower Studio applications and SAS
ETL Studio.
C - The QKB is used to translate data as it is transferred between dfPower Studio applications
and SAS FTL Studio.
D - The QKB facilitates the sharing of data quality rules between dfPower Studio applications and
the SAS Data Quality Server.
Answer: D
Which statement is true about defining target table columns using the Target Designer in SAS
ETL Studio?
A - Column metadata is imported from a data dictionary columns table.
B - Column metadata is linked to columns in the table from which they are selected.
C - Column metadata is independent of columns in the table from which they are selected.
D - Column metadata is synchronized with columns in the table from which they are selected by
the Impact Analysis Wizard.
Answer: C
In SAS ETL Studio, what does a Transformation Template contain?
A - Sources and/or targets
B - The process flow diagram for a job
C - A transformation object and the process flow diagram for a job
D - A transformation object and one or more drop zones for tables and/or transformations
Answer: Dhttp://www.infopediaonline.com/
If the SAS ETL Studio Metadata Import Wizard cannot be used, how can metadata be captured
from legacy systems using the Open Metadata API?
I. use the SAS XML Mapper
Il. use the SAS METADATA procedure
III. us e the SAS METAOPERATE procedure
IV. use a customized Java plug-in to SAS ETL Studio
A - l and III
B - l and IV
C - II and Ill
D - II and IV
Answer: D
Which repository tree can be defined in SAS Management Console?
A - Two Project Repositories depend on a Custom Repository, which depends on the Foundation
Repository.
B - Two Custom Repositories depend on a Project Repository, which depends on the Foundation
Repository.
C - A Project Repository depends on two Custom Repositories, which depend on the Foundation
Repository.
D - A Custom Repository depends on two Project Repositories, which depend on the Foundation
Repository.
Answer: A
In SAS ETL Studio. what is stored as a metadata identity?
A - The location of the SAS Metadata Server
B - The libraries containing the data in the warehouse
C - A user or a group of users of the metadata environment
D - A list of the warehouse server names and port numbers
Answer: C
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 - The selected objects only
C - Grouped objects and their associated objects
D - The selected objects and all associated objects
Answer: A
In SAS ETL Studio, which alert actions can be selected from the Status Handling tab as a
property of the job?
I. Send email.
ll. Abort the process.
lll. Send the entry to a dataset.
IV. Call a macro from a SAS Autocall Library.
A - l and II only
B - Ill and IV only
C - I, II and Ill only
D - I, II, Ill and IV
Answer: D
In SAS ETL Studio, what can be used to register a metadata object in the Process Library?
l. the Metadata Importer
ll. the Metadata Transformer
III. the Transformation Importer
IV. the Transformation Generator
A - II only
B - IV only
C - l and II
D - III and IV
Answer: D
In a SAS data warehouse environment, which SAS servers enable high-performance data
delivery to aid in optimization of queries?
A - SAS Workspace Server and SAS OLAP Server
B - SAS Metadata Server and SAS DATA Step Batch Server
C - SAS OLAP Server and SAS Scalable Performance Data Server
D - SAS DATA Step Batch Server and SAS Scalable Performance Data Server
Answer: C
Which wizards are used by SAS ETL Studio to define and load star schemas in a data
warehouse?
A - Target Designer and Process Designer
B - Source Designer and Process Designer
C - Target Designer and Metadata Designer
D - Metadata Designer and Source Designer
Answer: A
In SAS ETL Studio, which repository type(s) can be dependent on the project repository?
A - Custom only
B - No repositories
C - Foundation only
D - Foundation and Custom
Answer: B
In addition to Read Metadata and WriteMetadata, which metadata layer access control
permission(s) is/are enforced by the SAS Metadata Server?
A - Delete Metadata only
B - Check in Metadata only
C - Check in Metadata and Check out Metadata only
D - Delete Metadata, Check in Metadata, Check out Metadata
Answer: B
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 - _DUTPUT
C - _SYSOUT
D - _TAROUT
Answer: B
In the SAS Data Quality solution, which data cleansing step involves an initial investigation or the
data to identity potential data quality issues, such as missing data, uniqueness, redundant data,
maximum field length and number or distinct data patterns?
A - Data Profiling
B - Data Analysis
C - Data Validation
D - Data Verification
Answer: A
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?
l. Default ACT
II. Access Control Entry
lll. Permission Conditions
IV. Security Rule Schema
A - l only
B - IV only
C - I, II and Ill only
D - l, ll, lll and lV
Answer: A
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, Delete
B - Fetch, Destroy
C - Copy, Delete
D - Copy, Destroy
Answer: A
How can custom transformation objects be integrated into the Process Library within SAS ETL
Studio?
A - Implement as Java plug-ins only
B - Implement as macro calls within a user exit
C - Implement as Java plug-ins or SAS code transformation templates
D - Implement as SAS code transformation templates or macro calls within a user exit
Answer: C
What is stored for a Metadata Profile created in SAS ETL Studio?
A - The authentication domain name
B - The location of the metadata library
C - The port number of the metadata server
D - The name of the default application server
Answer: C
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 - sassrv
B - sasadm
C - sastrust
D - saswbadm
Answer: C
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 - SYSINFO
B - SYSLAST
C - SYSPARM
D - SYSJOBID
Answer: B
Which data sources are supported in SAS ETL Studio?
I. external flat files
lI. Scalable Performance Data Server tables
lIl. relational database management systems
IV. hierarchical database management systems
A - l and II only
B - Ill and IV only
C - I Il, and Ill
D - II, Ill, and IV
Answer: C
In the SAS Management Console Metadata Manager plug-in, from which server is the Replication
Wizard launched?
A - Target Server
B - Source Server
C - Replication Server
D - Administration Server
Answer: D
Which statements are true about the relationship between dimension, hierarchy, level, and
member within SAS OLAP cubes?
l. Members are the values of a level.
II. Hierarchies are navigation paths within a dimension.
lll. Members are groups of variables within a hierarchy.
IV. Levels are stored aggregations within hierarchies of OLAP cubes.
A - l and II
B - l and Ill
C - II and IV
D - III and IV
Answer: A
In the SAS Management Console Metadata Manager plug-in, which repository action
permanently removes all metadata items that have been marked for deletion in the selected
repository?
A - Purge
B - Delete
C - Erasehttp://www.infopediaonline.com/
D - Remove
Answer: A