SAS VISUAL ANALYTICS EXAM
PRACTICE
Which statement is TRUE when importing an Excel file with multiple worksheets into
SAS Visual Analytics? - Correct Answers -You CAN choose the worksheet to be
imported.
When importing a Microsoft Excel file using local files, what changes can be made to
the destination table? - Correct Answers -Rename row
The following comma-delimited file is imported into SAS Visual Analytics: - Correct
Answers -Measure
Which option is NOT found in the File Specifications section when importing a delimited
text file? - Correct Answers -Specify the range of imported rows and columns.
Which action creates a new measure that contains and count of the unique values for
any particular company? - Correct Answers -Right click a category data item in the Data
pane and select New Calculation, then select Distinct Count.
How does a report designer determine whether the values of a measure data item are
unique? - Correct Answers -Open the measure details window and compare the total
observations and distinct count statistics.
Refer to this exhibit: assuming that there are data values for each city, how many
different labels will be displayed when using this data item? Enter answer in numeric
value: - Correct Answers -Correct answer: 3
A content developer is working in SAS Visual Analytics. Currently, the data pane only
displays some of the data items in the data source. Why are some of the data items not
displayed? - Correct Answers -The content developer used the Show or Hide Items
window
What is one possible reason why the new geography item is returning 0% mapped
values? - Correct Answers -The wrong NAME or CODE context has been selected for
the data item
What causes this window to display? - Correct Answers -AUTOMOBILE was removed
from the CARS metadata.
PRACTICE
Which statement is TRUE when importing an Excel file with multiple worksheets into
SAS Visual Analytics? - Correct Answers -You CAN choose the worksheet to be
imported.
When importing a Microsoft Excel file using local files, what changes can be made to
the destination table? - Correct Answers -Rename row
The following comma-delimited file is imported into SAS Visual Analytics: - Correct
Answers -Measure
Which option is NOT found in the File Specifications section when importing a delimited
text file? - Correct Answers -Specify the range of imported rows and columns.
Which action creates a new measure that contains and count of the unique values for
any particular company? - Correct Answers -Right click a category data item in the Data
pane and select New Calculation, then select Distinct Count.
How does a report designer determine whether the values of a measure data item are
unique? - Correct Answers -Open the measure details window and compare the total
observations and distinct count statistics.
Refer to this exhibit: assuming that there are data values for each city, how many
different labels will be displayed when using this data item? Enter answer in numeric
value: - Correct Answers -Correct answer: 3
A content developer is working in SAS Visual Analytics. Currently, the data pane only
displays some of the data items in the data source. Why are some of the data items not
displayed? - Correct Answers -The content developer used the Show or Hide Items
window
What is one possible reason why the new geography item is returning 0% mapped
values? - Correct Answers -The wrong NAME or CODE context has been selected for
the data item
What causes this window to display? - Correct Answers -AUTOMOBILE was removed
from the CARS metadata.
