Review Quiz - SAS Data Management Tools and Applications Flashcards
Which of the following tiers of the SAS platform contains SAS applications for data management, analytics, and reporting? Select all that apply.
Select one or more:
a. client tier
b. data tier
c. middle tier
d. server tier
a. client tier
c. middle tier
What components of the SAS Data Integration Studio interface provide information about who is logged on, as well as what connection profile was used? Select all that apply.
Select one or more:
a. title bar
b. menu bar
c. tool bar
d. status bar
a. title bar
d. status bar
In SAS Data Integration Studio, which External File wizard should be used to read data from the file shown below?
Select one:
a. New Delimited External File Wizard
b. New Fixed Width External File Wizard
c. New User-Written Exernal File Wizard
a. New Delimited External File Wizard
In SAS Data Integration Studio, which External File wizard should be used to read data from the file shown below:
Select one:
a. New Delimited External File Wizard
b. New Fixed Width External File Wizard
c. New User-Written External File Wizard
b. New Fixed Width External File Wizard
How many transformations are shown in the job flow diagram? Enter a numeric value.
5
How many table objects are in the job? Enter a numeric value.
6
How many tables (not temporary tables) are being populated in the job? Enter a numeric value.
3
How many types of table objects are shown in the job flow diagram?
2
Recall that a demonstration in SAS Data Integration Studio used a work table to create a registered table.
In SAS Data Integration Studio, which of the following wizards could have created the same metadata for the target table?
Select one:
a. Register Tables Wizard
b. New Table Wizard
c. Create new Table Wizard
d. Create Target Table Wizard
b. New Table Wizard
In Data Management Studio, where do you click to navigate to the main interface, where you can see the navigation riser bars of Information, Data, Folders, Data Management Servers, and Administration?
Select one:
a. Home tab
b. Data Flow tab
c. Settings tab
d. Variables tab
a. Home tab
Where do you register Quality Knowledge Bases and reference sources in Data Management Studio?
Select one:
a. Information riser bar
b. Folders riser bar
c. Data riser bar
d. Administration riser bar
d. Administration riser bar
In Data Management Studio, where do you view, create, and manage data collections?
Select one:
a. Administration riser bar
b. Information riser bar
c. Data riser bar
d. Folders riser bar
c. Data riser bar
In Data Management Studio, which type of data analysis enables you to analyze a certain number of data rows in order to determine the contents of a field?
Select one:
a. field name analysis
b. data row analysis
c. sample data analysis
d. field match analysis
c. sample data analysis
In a profile from Data Management Studio, on which tab do you specify the metrics to be calculated for the profile?
Select one:
a. Report tab
b. Metric tab
c. Properties tab
d. Custom metrics tab
c. Properties tab
In Data Management Studio, in addition to data connections, what other types of input are available for loading data into a profile? Select all that apply.
Select one or more:
a. test files
b. filters on data
c. SQL queries
d. data collections
a. test files
b. filters on data
c. SQL queries
d. data collections
In a Data Management Studio data job, what is the purpose of the Field Layout node? Select all that apply.
Select one or more:
a. control the order of fields
b. subset the number of fields passing through to the next node
c. rename the output fields
a. control the order of fields
b. subset the number of fields passing through to the next node
c. rename the output fields
What is the purpose of parsing data?
Select one:
a. to separate a text string into words
b. to divide a text string into individual tokens
c. to determine the type of data that is represented by a string
d. none of the above
b. to divide a text string into individual tokens
Data values that are already parsed into individual tokens must first be concatenated before you generate match codes on the data value.
Select one:
True
False
False
There is a Match Codes (Parsed) node available to deal with data that are already parsed.
You can cluster only records that are based on match codes that were generated on the input data.
Select one:
True
False
False
Which of the following is a valid method for applying a standardization scheme to a data value using the DQSCHEMEAPPLY function? Select all that apply.
Select one or more:
a. EXACT
b. IGNORE_CASE
c. USE_MATCHDEF
a. EXACT
b. IGNORE_CASE
c. USE_MATCHDEF
What is the purpose of the DQMATCH function?
Select one:
a. to generate match codes from the data values
b. to group matching records
c. to match fields with the same data values
d. to match fields with the same name
a. to generate match codes from the data values
The six types of component files that comprise the QKB are schemes, chop tables, phonetics libraries, regular expression libraries, vocabularies, and grammars.
Select one:
True
False
True