Review Quiz - SAS Data Management Tools and Applications

Question 1

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

Answer 1

a. client tier
c. middle tier

Question 2

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

Answer 2

a. title bar
d. status bar

Question 3

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

Answer 3

a. New Delimited External File Wizard

Question 4

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

Answer 4

b. New Fixed Width External File Wizard

Question 5

How many transformations are shown in the job flow diagram? Enter a numeric value.

Answer 5

5

Question 6

How many table objects are in the job? Enter a numeric value.

Answer 6

6

Question 7

How many tables (not temporary tables) are being populated in the job? Enter a numeric value.

Answer 7

3

Question 8

How many types of table objects are shown in the job flow diagram?

Answer 8

2

Question 9

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

Answer 9

b. New Table Wizard

Question 10

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

Answer 10

a. Home tab

Question 11

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

Answer 11

d. Administration riser bar

Question 12

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

Answer 12

c. Data riser bar

Question 13

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

Answer 13

c. sample data analysis

Question 14

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

Answer 14

c. Properties tab

Question 15

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

Answer 15

a. test files
b. filters on data
c. SQL queries
d. data collections

Question 16

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

Answer 16

a. control the order of fields
b. subset the number of fields passing through to the next node
c. rename the output fields

Question 17

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

Answer 17

b. to divide a text string into individual tokens

Question 18

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

Answer 18

False

There is a Match Codes (Parsed) node available to deal with data that are already parsed.

Question 19

You can cluster only records that are based on match codes that were generated on the input data.

Select one:
True
False

Answer 19

False

Question 20

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

Answer 20

a. EXACT
b. IGNORE_CASE
c. USE_MATCHDEF

Question 21

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

Answer 21

a. to generate match codes from the data values

Question 22

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

Answer 22

True