Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SAS Viya Certification > SAS Visual Analytics for Viya > Flashcards

SAS Visual Analytics for Viya Flashcards

1
Q

For which type of what-if analysis do you modify future values of the underlying factor to determine the impact on the forecast?
a. scenario analysis
b. goal seeking
c. prediction analysis
d. target seeking

A

a. scenario analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

For which type of what-if analysis do you modify future values of the forecast to determine the change needed for the underlying factor?
a. scenario analysis
b. goal seeking
c. prediction analysis
d. target seekin

A

b. goal seeking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What types of data items are needed to create a forecasting object?
a. date and category
b. time and datetime
c. datetime and measure
d. category and measure

A

c. datetime and measure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are additional measures that improve the accuracy of the forecast?
a. underlying factors
b. additional measures
c. underlying measures
d. additional factors

A

a. underlying factors

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What types of data items are needed to perform what-if analysis?
a. datetime, category, and underlying factor
b. time, datetime, and underlying factor
c. date, measure, and underlying factor
d. category, time, and underlying factor

A

c. date, measure, and underlying factor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which transform in SAS Data Studio enables you to convert character data to uppercase?
a. Change case in the Column Transforms group
b. Manage columns in the Column Transforms group
c. Uppercase data in the Column Transforms group
d. Convert column in the Column Transforms group

A

a. Change case in the Column Transforms group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which transform in SAS Data Studio enables you to convert character data to proper case based on a definition?
a. Change case in the Column Transforms group
b. Casing in the Data Quality Transforms group
c. Propercase data in the Data Quality Transforms group
d. Convert column in the Column Transforms group

A

b. Casing in the Data Quality Transforms group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which type of geo map should be used with very dense data?
a. coordinate with scatter plot
b. coordinate with bubble plot
c. region
d. contour

A

d. contour

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which type of geo map can be used when there is NOT an even distribution of values within each region?
a. coordinate with scatter plot
b. coordinate with bubble plot
c. region
d. choropleth

A

b. coordinate with bubble plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is needed to create a geography data item using geographic name or code lookup?
a. latitude
b. longitude
c. geographic data provider
d. country names or codes

A

d. country names or codes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is needed to create a geography data item using latitude and longitude in data?
a. latitude and longitude
b. geographic data provider
c. country names or codes
d. US postal codes

A

a. latitude and longitude

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is needed to create a geography data item using custom polygonal shapes?
a. latitude and longitude
b. geographic data provider
c. country names or codes
d. US postal codes

A

b. geographic data provider

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which type of geo map enables you to cluster adjacent markers?
a. coordinate with scatter plot
b. coordinate with bubble plot
c. region
d. contour

A

a. coordinate with scatter plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which type of geo map enables you to add a measure to determine the size of the marker?
a. coordinate
b. region
c. contour
d. choropleth

A

a. coordinate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which application enables you to customize the look and feel of the SAS Viya applications and your reports?
a. SAS Studio
b. SAS Graph Builder
c. SAS Theme Designer
d. SAS Lineage

A

c. SAS Theme Designer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which object in SAS Visual Analytics runs several models and chooses a champion model for predicting a specific response using most of the data items in the table?
a. automated explanation
b. factors chart
c. automated prediction
d. response chart

A

c. automated prediction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which object in SAS Visual Analytics determines the most important underlying factors for a response variable by using most of the data items in the table?
a. automated explanation
b. factors chart
c. automated prediction
d. response chart

A

a. automated explanation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What are the 2 types of Network Analysis objects?

A

Hierarchical - shows a parent-child relationship in which each parent node is linked only to its children. Typically, this type of network diagram shows disconnected clusters of nodes.

Ungrouped - creates a series of linked nodes from a source to a target. A node is created for each value of the source data item, and a link is created from each node to the node that corresponds to the value of the target data item. Vertices and links in this type of diagram represent connections between the nodes. Ungrouped network can either be undirected or directed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What are the requirements for a Network Analysis?

A

Data must have one row for each source-target pair

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

How are Ungrouped Network Analyses used?

A

Ungrouped network diagrams can be used to interpret the structure of a network by looking at the clustering of nodes, how densely the nodes are connected, and how the diagram layout is arranged.

E.g. Organizational Structure of a Company or Airline and Airport Connections

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

How can an ugrouped network diagram be overlaid on a geomap?

A

Both the source and target nodes are geographic data items, then the network can be overlaid on a geo map.

Helpful for understanding how location affects the relationships in the network.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Which table is structured appropriately for ungrouped network analysis in SAS Visual Analytics?

A

c.

To create an ungrouped network analysis in SAS Visual Analytics, the table must have at least one row for each source-target pair. In addition, the target values (in this case, EMPLOYEE) must be a subset of the source values (in this case, MANAGER)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Which type of network analysis object shows parent-child relationships?
a. linked
b. hierarchical
c. ungrouped
d. targeted

A

b. hierarchical

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Which type of network analysis object shows a series of linked nodes from a source to a target?
a. linked
b. hierarchical
c. ungrouped
d. targeted

A

c. ungrouped

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What is an example of a directed relationship for an ungrouped network analysis object?
a. transactions between criminals
b. the Friends relationship on Facebook
c. actors in Saturday Night Live episodes
d. the Friends relationship on Snapchat

A

a. transactions between criminals

A directed relationship in an ungrouped network analysis object shows the direction of the relationship between entities using arrows. Transactions between criminals is an example of a directed relationship because one person sends money (source) and another person receives the money (target).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What is an example of an undirected relationship for an ungrouped network analysis object?
a. disease transmission
b. phone calls between family members
c. trash pickup routes
d. connections on LinkedIn

A

d. connections on LinkedIn

An undirected relationship in a network analysis object displays only the connections between entities, meaning that there is no direction to the relationship. Connections on LinkedIn is an example of an undirected relationship because the connection is mutual: Person A is related to person B, which implies that person B is related to person A.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What types of data items are needed to overlay an ungrouped network analysis object on a geo map?
a. two geographies
b. two measures
c. one geography, one measure
d. one category, one measure

A

a. two geographies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What is a Path Analysis and how are they used?

A
  • A Path Analysis shows flows of data from one event to another.
  • Each path consists of linked nodes which are consecutive events in that path
  • Links between the linked nodes can be sized by the frequency of the path or the value of a weight

E.g., tracking website visited by customers who made a purchase.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What can the color of a Link’s Path be configured to indicate?

A
  • Show each path as a different color - good for small number of paths
  • Show each event in a different color - good for comparing the same event
  • Indicate drop-offs - easier to identify where paths frequently end
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

What are the data requirements for a Path Analysis?

A
  • one row for each identifier/event pair
  • each row needs a sequence order (datetime data item or measure) that orders the events for any given identifier.
  • Optionally, you can have a measure that determines the link width for the object - a positive number GT zero

Identifier = a value that uniquely labels each person or object that we would like to analyze. e.g., student, customer, visitor to a website

Event = represents the different nodes in the diagram. E.g., classes a student takes, pages of a website

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Which table is structured appropriately for path analysis in SAS Visual Analytics?

A

b

To create a path analysis object in SAS Visual Analytics, the table must have one row for each event-identifier pair, and a datetime data item or measure that orders the events for any given identifier. In this example, CLASS is the event, NAME is the identifier, and ORDER (numeric) is the ordering data item.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

If you would like to easily view each path separately from start to end, how should you color the links in a path analysis object?
a. by path
b. by event
c. by drop off
d. by weight

A

a. by path

Coloring links by path is useful if you have a small number of paths and you would like to follow each path separately from start to end.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

If you would like to visually compare the same events throughout the path analysis object, how should you color the links?
a. by path
b. by event
c. by drop off
d. by weight

A

b. by event

Coloring links by event makes it easier to visually compare the same event throughout the path analysis object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

If you would like to identify where paths frequently end, how should you color the links in a path analysis object?
a. by path
b. by event
c. by drop off
d. by weight

A

c. by drop off

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

What types of data items are needed to create a path analysis object?
a. three categories
b. two dates, one aggregated measure
c. three measures
d. two categories, one measure

A

d. two categories, one measure

To create a path analysis object in SAS Visual Analytics, you need a category for the Event role, a date or measure for the Sequence order role, and a category or measure for the Transaction identifier role.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

How are the links colored in this path analysis object?
a. by path
b. by event
c. by drop off
d. by weight

A

b. by event

In this example, the links are colored by event. Notice how the path after the Outage event is always a teal color.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

How are the links colored in this path analysis object?
a. by path
b. by event
c. by drop off
d. by weight

A

c. by drop off

In this example, the links are colored by drop off. Notice how all paths are the same color. This indicates that the paths end without additional paths continuing onward.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Which path is most common in this path analysis object?
a. 1
b. 2
c. 3
d. 7

A

a. 1

In this example, the most common path is the teal path (path 1). There are seven identifiers that follow this specific path.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

How are the links colored in this path analysis object?
a. by path
b. by event
c. by drop off
d. by weight

A

b. by event

In this example, the links are colored by event. Notice how the path after The Empire Strikes Back event is always an orange color.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

How are the links colored in this path analysis object?
a. by path
b. by event
c. by drop off
d. by weight

A

a. by path

In this example, the links are colored by path. Notice how each path is a separate color.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

Describe the Text Topics objects.

A
  • Displays a set of words from unstructured text
  • Document Collection - Unstructured text in a text topic object
  • Topics are words that often appear together in a document and are displayed in a bar chart.
  • Word Cloud displays terms for a topic with the size reflecting the terms importance in the topic
  • A table lists all documents that contain a specific term
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

What is sentiment analysis?

A

It is a text topic object that categorizes documents as positive, neutral, or negative

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

What 3 things are required for a text topics object?

A
  • Document Collection - the data item that contains unstructured text
  • Data Language - determines which stop list is used for text analytics
  • Unique ID - the data item that contains a value that is unique for each row of the data source
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

How does Text Analytics work?

A
  • unstructured text is parsed into individual terms
  • terms are compared with a stop list, if available
  • terms found in the stop list are removed from the analysis
  • remaining terms are analyzed to determine topics (terms that tend to show up together in documents)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

What is a stop list?

A

A table of common words that are ignored during text analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

How are terms scored for sentiment analysis?

A

Negative words = 0
Neutral words = 0.5
Positive words = 1

Scores are averaged to determine the overall sentiment of each document

GT .5 is a positive document
EQ .5 is a neutral document
LT .5 is a negative document

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

What are term roles?

A

Identifies terms by their parts of speech (noun, verb, adjective), identifies groups of nouns as single terms, and identifies text entities (names, address, phone numbers).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

What are Stem words?

A

Different forms of a given word. For example, sell is the stem word of the following: sell, sells, selling, sold.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

What are documents?

A

Unstructured text. These are displayed in the documents list table and are a single row in the data source.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

What are terms?

A

Words or phrases. These are displayed in the terms word cloud.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

What are topics?

A

Words that often appear together in documents. These are displayed in the topics bar chart.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

What are Topic Term weights?

A

Indicates the importance of the word in the topic.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

What are Derived Data Items?

A

Derived data items can be created from topics and relevance to further analyze the topics that are generated. They can be created from derived topics and derived relevance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

What are derived topics?

A

The value is either 1 (if the document is included in the topic) or 0 (if the document is not included in the topic).

This derived topic can then be used with other data items in the table to get a better understanding of the subgroup for the topic.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

What are derived relevance?

A

The value represents the relevance of the document in that topic.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

What types of data items are needed to create a text topics object?
a. a unique row identifier, document details, a language
b. a unique row identifier, document details
c. a unique row identifier, a document collection, a language
d. a unique row identifier, a document collection

A

c. a unique row identifier, a document collection, a language

To create a text topics object in SAS Visual Analytics, you need a language, a unique row identifier, and a document collection (unstructured text).

57
Q

Which role enables you to add additional information to text analytics?
a. Document collection
b. Document details
c. Language
d. Unique row identifier

A

The Document details role in a text topics object enables you to add additional information to text analytics.

58
Q

Which table is structured appropriately for text analytics in SAS Visual Analytics?

A

a

To perform text analytics in SAS Visual Analytics, the table must have a data item that contains unstructured text (document collection), and each document must be associated with a unique value (unique row identifier). In this example, REVIEW is the document collection and USER is the unique row identifier.

59
Q

Which choice below correctly orders the steps for text analytics?
a.
Terms are analyzed to determine topics.
Unstructured text is parsed into individual terms.
Terms are compared to the stop list.
Terms found in the stop list are removed from analysis.
b.
Terms are analyzed to determine topics.
Terms are compared to the stop list.
Terms found in the stop list are removed from analysis.
Unstructured text is parsed into individual terms.
c.
Unstructured text is parsed into individual terms.
Terms are compared to the stop list.
Terms found in the stop list are removed from analysis.
Terms are analyzed to determine topics.
d.
Unstructured text is parsed into individual terms.
Terms are analyzed to determine topics.
Terms are compared to the stop list.
Terms found in the stop list are removed from analysis.

A

c.
Unstructured text is parsed into individual terms.
Terms are compared to the stop list.
Terms found in the stop list are removed from analysis.
Terms are analyzed to determine topics.

To perform text analytics in SAS Visual Analytics, the following steps are performed:
(1) Unstructured text is parsed into individual terms,
(2) Terms are compared to the stop list, if available,
(3) Any terms found in the stop list are removed from analysis, and
(4) Remaining terms are analyzed to determine topics.

60
Q

What is displayed in the text topics bar chart?
a. documents
b. terms
c. topics
d. roles

A

c. topics

The text topics bar chart displays the document count for each topic.

61
Q

What is displayed in the text topics word cloud?
a. documents
b. terms
c. topics
d. roles

A

b. terms

The text topics word cloud displays the topic weight for each term.

62
Q

What is displayed in the text topics list table?
a. documents
b. terms
c. topics
d. roles

A

a. documents

The text topics list table displays the topic relevance for each document.

63
Q

In the following bar chart from a text topics object, what does the +drop term represent?
a. Additional terms are included in that topic.
b. The term is used in other topics.
c. The term is used for different parts of speech.
d. The term includes stem words.

A

d. The term includes stem words.

The +drop term indicates that the term includes stem words, or different forms of a given word. In this example, this term could include the words drop, dropped, drops, or dropping.

64
Q

In the following bar chart from a text topics object, which topic contains the greatest number of positive documents?
a. location, customer, city, novelty
b. +drop, risk, supplier, +dissatisfy
c. city, kansas, oklahoma, salt
d. atlanta, gift, neutral, novelty

A

a. location, customer, city, novelty

The location, customer, city, novelty topic contains the greatest number of positive documents (green portion of the bar).

65
Q

In the following details table from a text topics object, why does the term order appear twice?
a. The term appears in documents multiple times.
b. The term includes stem words.
c. The term appears in different topics.
d. The term is used for different parts of speech.

A

d. The term is used for different parts of speech.

The term order is used in the documents for different parts of speech. For example, it can be used as a noun (I placed an order) or a verb (I ordered a product).

66
Q

What are examples of data items that cannot be created ahead of time before/outside of a report in VA?

A

hierarchies, geography data items, aggregated measures, and parameters

67
Q

What data items should not be created ahead of time before/outside of a report in VA?

A

data items that are seldom used or those that you would like to be more dynamic (like customer ages and employee tenure)

68
Q

What are examples of data items that can be created before data is imported to CAS?

A

custom category, a duplicate, and a calculated item

69
Q

What are examples of data items that can be created in SAS VA report?

A

a geography, a hierarchy, parameters, aggregated measures, derived items, and a distinct count

70
Q

Custom category

A

A custom category creates labels for groups of values of category or measure data items. When you create a custom category from a measure data item, you can use intervals or distinct values to group the data.

71
Q

Duplicate

A

Both measures and categories can be duplicated (copied) in Visual Analytics. Duplicating measures enables you to compare the data using different aggregations in a table or graph or change the classification to a category for grouping other values in tables or graphs. Duplicating datetime values enables you to apply different formats to the values for use in tables or graphs. Duplicating calculated items enables you to make variations to a calculation.

72
Q

Calculated

A

Calculated items are created by performing mathematical calculations on numeric values, or by performing operations on datetime data items or categories. All calculations are performed on unaggregated data. That is, the expression is evaluated for each row in the data source.

73
Q

Geography

A

A geography data item is a category whose values are mapped to geographical locations or regions. Geography data items can be used with geo maps and other report objects. Geography data items can be created using predefined roles (for example, country names), by associating latitude and longitude coordinates with the values (custom), or by associating polygon data from a separate data source with map regions (custom).

74
Q

Aggregated measure

A

Aggregated measures enable you to calculate new data items using aggregated values. This means that the calculation changes depending on the other data items available in the graph. For example, you can see the profit margin for each region or by each store.

75
Q

Hierarchy

A

A hierarchy is a defined arrangement of category data items based on a parent-child relationship. In many cases, the levels of the hierarchy are arranged with the more general information at the top (for example, year) and the more specific information at the bottom (for example, month). Hierarchies enable you to add drill-down functionality to graphs and tables. Hierarchies that consist of all geographic data items are considered geographic hierarchies and can be used in geo maps.

Note: You can create a date hierarchy from a date data item. The date hierarchy, by default, has levels for year, quarter, month, and day. A date hierarchy created from a datetime data item has levels, by default, for year, quarter, month, day, hour, minute, and second.

76
Q

Distinct count

A

A distinct count counts the number of distinct values of a category data item as an aggregated measure. This means that the calculation changes depending on the other data items available in the graph. For example, you can see the number of orders placed for each age group or the number of orders placed for each country by creating a distinct count from Order ID.

77
Q

Parameter

A

A parameter is a variable whose value can be changed and that can be referenced by other report objects. Parameters can be used in control objects in Visual Analytics. When the value of the control changes, the parameter is updated with that value, and any report objects that reference that parameter are updated as well. Parameters can be used in calculations, display rules, filters, ranks, URLs, and text objects.

78
Q

Derived items

A

Derived data items are aggregated measures that display values for the measure and the formula type on which the derived item is based.
The following types of derived items can be created from category data items:
* Distinct count Displays the number of distinct values for the selected category. For more information, see the distinct count row above.
* Count Displays the number of nonmissing values for the selected category.
* Number missing Displays the number of missing values for the selected category.

The following types of derived data items can be created from measure data items:
* Cumulative total Displays a running total of all the values for the measure on which it is based.
* Data suppression Obscures aggregated data if individual data values could easily be inferred. Data suppression replaces all values for the measure on which it is based with an asterisk (*) unless a value represents the aggregation of a specified minimum number of values.
* Difference from previous period Displays the difference between the value for the current time period and the value for the previous time period.
* Difference from previous parallel period Displays the difference between the value for the current time period and the value for the previous parallel time period within a longer time interval.
* Moving average Displays a moving average (rolling average) for the measure on which it is based. The moving average calculates the average for each value with the specified number of preceding values.
* Percent difference from previous period Displays the percentage difference between the value for the current time period and the value for the previous time period.
* Percent difference from previous parallel period Displays the percentage difference between the value for the current time period and the value for the previous parallel time period within a longer time interval.
* Percent of subtotals Displays the percentage of the subtotal value for the measure on which it is based. You can create a percentage of subtotal only when the source data item has an aggregation of Sum or Count.

Note: The Percent of subtotals derived item is available only for use in crosstabs.

Note: The Percent of subtotals derived item is relative to the subset of data that is selected by your filters and ranks.
Percent of total – sum Displays the percentage of the total value for the measure on which it is based. You can create a percentage of total only when the source data item has an aggregation of Sum or Count.

Note: The Percent of total – sum derived item is relative to the subset of data that is selected by your filters and ranks.
Period to date Displays the aggregated value for the current time period and all of the previous time periods within a larger time interval.
Year to date Displays the aggregated value for the current time period and all of the previous time periods within the year. The year-to-date calculation subsets the data for each year using today’s date (where today is evaluated each time you view the report).
Year to date growth Displays the percentage difference between the year-to-date value for the current time period and the year-to-date value for the same time period of the previous year. The year-to-date calculation subsets the data for each year using today’s date (where today is evaluated each time you view the report).
Year over year growth Displays the percentage difference between the current time period and an equivalent time period from the previous year. The year-over-year calculation subsets the data for each year using today’s date (where today is evaluated each time you view the report).

79
Q

What is a vector plot?

A
  • Shows the relative performance between two measures from one point in time to another.
    *Shows the changes in the values by using directed line segments (or vectors).
  • The vectors show both the direction and magnitude of the change between the starting point and the ending point.
  • Vector object requires 2 groups of measures - one set for the origin x and y axes and one set for end x and y axes
80
Q

What is a Butterfly Chart used for?

A

Also known as a tornado chart

Is useful for displaying summary information for two opposing groups. It displays two sets of bars with a shared category axis, where the baselines for the two bar charts are in the center of the chart.

81
Q

What is a Needle Plott used for?

A

A needle plot is useful for spotting trends and outliers. It uses vertical line segments (or needles) connected to a horizontal baseline. The baseline can be at zero, or it can be at some other value. Values above the baseline signal improvement and values below the baseline signal decline.

82
Q

What is a Dot Plot used for?

A

A dot plot is a great way to compare summarized data when the values are relatively close. It displays data for each value of a category data item using dots. The position of each dot on the response axis represents the summarized value of the measure.

83
Q

What are the 2 types of calculated items can you create in VA?

A
  • Calculated Data Items - created by performing mathematical calculations on numeric values or by performing operations on datetime data items or categories. All calculations are performed on unaggregated data.
  • Aggregated Measures - enable you to use aggregated values to calculate new data items. These data items are created by first aggregating values and then performing the operation. With aggregated measures, the calculation changes depending on other data items that are available in the graph.
84
Q

What is aggregation context?

A

Required for simple aggregated operators

It is the extent to which the aggregation is calculated. The ByGroup context aggregates the values for each group (the ones created in the report object), whereas the ForAll context aggregates the values for the entire set of data.

85
Q

What is the Relative Period operator?

A

A Period Operator that returns aggregated values for a period of time relative to the current period.

86
Q

What is the aggregation type parameter for period operatpors?

A

the aggregation type parameter specifies the aggregation that is applied to the measure data item (like average, count, distinct count, max, min, or sum).

87
Q

What is the measure parameter for period operators?

A

the measure parameter specifies the measure data item used for the expression

88
Q

What are time filter parameters for period operators?

A

time filters parameter specifies when filters are applied to the expression.
* The ApplyAllFilters option applies all filters (object filters and interactive filters) before the measure is calculated.
* The IgnoreInteractiveTimeFrameFilters option applies object filters before the measure is calculated but applies interactive filters after the measure is calculated.
* The IgnoreAllTimeFrameFilters option applies all filters (object filters and interactive filters) after the measure is calculated. This is the best option if you would like the expression to use all your data to calculate the aggregated measure.

89
Q

What are date parameters for period operators?

A

Date parameter specifies the date data item for the expression. All periodic operators require dates that include a year value.

90
Q

What are aggregation interval parameters for period operators?

A

The aggregation interval parameter specifies the interval over which the measure values are aggregated.

You can choose ByMonth, ByQuarter, ByYear, or Inferred.

The Inferred option automatically selects an interval based on the format of the date data item used in the object.

For example, if the date data item is formatted to show months and years, Inferred aggregates over months. Conversely, if the date data item is formatted to show years, Inferred aggregates over years.

91
Q

What are offset interval parameters for period operators?

A

The offset interval parameter specifies the number of intervals to offset from the current period, where the interval (months, quarters, or years) is determined by the selection for the aggregation interval parameter. Negative values refer to periods in the past, whereas positive values refer to periods in the future.

92
Q

What are scope parameters for period operators?

A

The scope parameter specifies whether the period is measured using full intervals (full months, quarters, or years) or only partial intervals.

For partial intervals, you can select ToDate to aggregate to a specific day in the interval or ToToday to aggregate to the position of today’s date in the interval (where today’s date is updated dynamically every time that the report is viewed).

93
Q

What are subset day parameters for period operators?

A

The subset day parameter specifies the chosen date when the ToDate scope parameter is selected.

94
Q

What does the suppress operator do?

A

An aggregated (Advanced) operator that
* Hides aggregated values if the specified condition is true.
* Hidden values are displayed as an asterisk within objects
* Suppressed data is commonly used to protect the identity of individuals in aggregated data when some aggregations are sparse

95
Q

What are the Suppress operator parameters?

A
  • Suppres Condition - determines which rows to hide
  • Suppressed value - determines which values to hide
  • Suppression application - specifies whether additional values are hidden when a single value is hidden for a group or subgroup.
    • The withoutComplement option specifies that only values that meet the suppression condition are hidden, whereas
    • The withComplement option specifies that additional values might be hidden if hidden values can be inferred by totals, subtotals, or other cell values
96
Q

What type of data items can be created outside of SAS Visual Analytics (for example, in SAS Data Studio or using SAS code)?
a. hierarchies
b. geography data items
c. calculated items
d. parameters

A

c. calculated items

Custom categories, duplicates, and calculated items can be created outside of SAS Visual Analytics, before data is loaded to CAS.

97
Q

In the following calculated item, why does the expression generate an error?
a. You cannot name a calculated item the same name as an existing data item.
b. The In operator does not work for character data.
c. The calculated item type does not match the result from the expression.
d. Missing is an invalid value.

A

c. The calculated item type does not match the result from the expression.

The calculated item, Sales, is specified with a result type of Character. However, the expression generates a numeric value.

98
Q

Which date and time operator creates a date value?
a. DatePart
b. DayOfMonth
c. Month
d. Now

A

a. DatePart

The DatePart operator returns a date from a datetime expression. The DayOfMonth and Month operators return a numeric value (between 1 and 31 for DayOfMonth and between 1 and 12 for Month), and the Now operator returns the datetime value of today’s date.

99
Q

Which aggregated (periodic) operator can be used to return aggregated values for next month?
a. CumulativePeriod
b. ParallelPeriod
c. Period
d. RelativePeriod

A

d. RelativePeriod

The RelativePeriod operator returns aggregated values for a period of time that is relative to the current period (for example, next month).

100
Q

For aggregated (periodic) operators, which time filters option applies all filters (object filters and interactive filters) AFTER the measure is calculated?
a. ApplyAllFilters
b. ApplyFiltersLast
c. IgnoreAllTimeFrameFilters
d. IgnoreInteractiveTimeFrameFilters

A

c. IgnoreAllTimeFrameFilters

The IgnoreAllTimeFrameFilters option for periodic operators applies all filters (object filters and interactive filters) after the measure is calculated.

101
Q

For aggregated (periodic) operators, which scope parameter aggregates the measure for the entire period (the entire month, quarter, or year)?
a. All
b. Full
c. ToDate
d. ToToday

A

b. Full

The Full option for periodic operators calculates the aggregated measure using full intervals (full months, quarters, or years).

102
Q

Which aggregated (periodic) operator can be used to calculate a running total for the fiscal year?
a. CumulativePeriod
b. ParallelPeriod
c. Period
d. RelativePeriod

A

a. CumulativePeriod

103
Q

Which aggregated (advanced) operator hides values based on a condition?
a. HideValues
b. Hidden
c. Suppress
d. SuppressValues

A

c. Suppress

104
Q

Which aggregated operator can be used to calculate a running total over a category?
a. CumulativePeriod
b. CumulativeCells
c. AggregateCells
d. AggregatePeriod

A

c. AggregateCells

The AggregateCells operator applies an aggregate operation to a range of items in a group (for example, calculate a running total from the first row to the current row for a category data item).

105
Q

What are the 2 types of filters?

A

Static Filters that can only be modified by the report designer

Interactive Filters that can be modified by the report designer and user.

106
Q

What are the 2 types of Static Filters?

A
  • Detail Report Filters - filters that look at individual values for data items and are applied at a global level and those that are applied at a local level.
  • Summary report filters look at the aggregated, or total, values
107
Q

What are Global Level filters?

A

A data filter can be added to subset the entire report. This filter is applied to every object that uses the data source.

108
Q

What are Local Level filters?

A

At the local level, basic and advanced report filters can be added to subset individual report objects.

109
Q

What are post-aggregate report filters?

A

Subsets the report object using aggregated values, not individual values. These aggregated values are evaluated in the report object and are used to specify the minimum and maximum values in the selectable range.

110
Q

In what order are filters applied?

A
  • Data source filters would be applied first,
  • Then any basic or advanced filters,
  • Lastly post-aggregate filters
111
Q

What are the 3 types of interactive filters?

A
  • Prompts - enable you to subset all data in the report or on a page. If you need to subset specific objects, you can use actions.
  • Actions - subsets the data in specific objects on the page, based on selections in a source object. The linked selection action highlights the data in specific objects on the page, based on selections in a source object. In addition, you can add automatic actions to all objects on a page.
  • Links - subset another report, another page in the same report, or an external URL based on selections in a source object.
112
Q

What are the 2 types of prompts?

A
  • Report Prompts
  • Page Prompts
113
Q

What is Automatic Linked Selection Action?

A

An action that simultaneously shows the same data in multiple objects. The data has the same appearance in each object, which makes it easy for report viewers to determine the relationship between the data.

114
Q

What is Automatic One-Way Filters Action?

A
  • Enables viewers to apply filters between objects in any order.
  • The filters are applied in the order in which the data is selected on the page.
  • This enables viewers to filter the data however they like without the designer having to account for every possible filtering scenario.
  • Once a data item is selected in an object, that object cannot be filtered further by selecting a data item on a different object.
115
Q

What is Automatic Two-Way Filters Action?

A
  • Enables viewers to apply filters between all objects on a page, even previously selected objects.
  • This enables viewers to see the impact of filters on previously filtered objects as well.
116
Q

What is mapping data sources?

A

Mapping is a way to treat a value in one data source as another value in the second data source so that you can add actions between objects that use different data sources

117
Q

Which type of static filter subsets data based on individual values for data items?
a. detail report filters
b. post-aggregate report filters
c. prompts
d. actions

A

a. detail report filters

118
Q

Which type of static filter subsets data based on total, or summarized, values for data items?
a. detail report filters
b. post-aggregate report filters
c. prompts
d. actions

A

b. post-aggregate report filters

119
Q

Which type of static filter can subset an object using any number of data items and operators in the same expression?
a. data source filter
b. basic filter
c. advanced filter
d. post-aggregate filter

A

c. advanced filter

120
Q

Which type of interactive filter subsets all the objects in a report or on a page?
a. detail report filters
b. post-aggregate report filters
c. prompts
d. actions

A

c. prompts

121
Q

Which type of interactive filter subsets specific objects on a page?
a. detail report filters
b. post-aggregate report filters
c. prompts
d. actions

A

d. actions

122
Q

What type of links can be added to an object?
a. report, page, data
b. report, page, URL
c. report, data, URL
d. report, prompt, data

A

b. report, page, URL

123
Q

Which type of automatic action simultaneously shows the same data in multiple objects on a page?
a. automatic linked selection
b. automatic prompt value
c. automatic one-way filter
d. automatic two-way filter

A

a. automatic linked selection

124
Q

Which type of automatic action subsets data between all objects on the page, even previously selected objects?
a. automatic linked selection
b. automatic prompt value
c. automatic one-way filter
d. automatic two-way filter

A

d. automatic two-way filter

125
Q

Consider the following information about the report shown below:

  • The button bar and the drop-down list controls are page prompts.
  • The drop-down list control and the treemap use the PRODUCTS_CLEAN table.
  • The other objects use the EMPLOYEES_CLEAN table.
  • The bar chart filters the list table.
  • No data source mappings have been established.

Suppose you chose Sales on the button bar. Which objects are filtered?
a. the drop-down list control and the treemap
b. the bar chart and the list table
c. the treemap and the list table
d. the drop-down list control and the bar chart

A

b. the bar chart and the list table

126
Q

You use the two tables shown below in a report. Consider this scenario:

  • TABLE B is used in a treemap to show the budget per quarter.
  • TABLE A is used in a list table to show a list of people.
  • The treemap filters the list table.
  • How should the two tables be mapped?
       a.  PERSON in TABLE A should be mapped to QUARTER in TABLE B.    b.  QUARTER in TABLE A should be mapped to QUARTER in TABLE B.    c.  The tables cannot be mapped because the list table doesn’t contain enough columns.    d.  The tables cannot be mapped because the treemap doesn’t use the BIRTH MONTH column.
A

b. QUARTER in TABLE A should be mapped to QUARTER in TABLE B

127
Q

What are parameters?

A

Parameters are a special type of data item whose value can be changed by viewers of the report. When the value is modified, objects that use that parameter (like calculated items, display rules, filters, and ranks) are updated automatically to reflect the change. Parameters enable viewers to see what they want, when they want to see it, without having to ask a report designer to change the report for them.

128
Q

What are the 3 steps for using parameters?

A
  1. create the parameter using the Data pane
  2. populate the parameter by adding a control object to the canvas that enables the report viewer to modify the value of the parameter.
  3. apply the parameter to a calculation, a display rule, a filter, or a rank
129
Q

Where can parameters be applied?

A

Parameters can be applied to a calculation, a display rule, a filter, or a rank.

130
Q

Suppose you want to use parameters in a report. What do you do in the Create step?
a. determine the type of parameter needed for the scenario
b. add a control object to the canvas so the viewer can update the parameter
c. use the parameter in a calculation, a display rule, a filter, or a rank
d. add the data source to the report

A

a. determine the type of parameter needed for the scenario

131
Q

Suppose you want a viewer to specify the minimum salary. What type of parameter would you create?
a. numeric
b. character
c. date
d. multiple values

A

a. numeric

132
Q

Suppose you want a viewer to enter a string to search for a product. What type of parameter would you create?
a. numeric
b. character
c. date
d. multiple values

A

b. character

133
Q

Suppose you want a viewer to enter the number of years to view in a time series plot. What type of parameter would you create?
a. numeric
b. character
c. date
d. multiple values

A

a. numeric

If you want the viewer to enter the number of years (a number), you need to create a numeric parameter.

134
Q

Suppose you want to use parameters in a report. What do you do in the Populate step?
a. determine the type of parameter needed for the scenario
b. add a control object to the canvas so the viewer can update the parameter
c. use the parameter in a calculation, a display rule, a filter, or a rank
d. add the data source to the report

A

b. add a control object to the canvas so the viewer can update the parameter

135
Q

Which types of controls can be used with numeric parameters?
a. text input or button bar
b. text input or slider
c. slider or drop-down list
d. slider or button bar

A

b. text input or slider

136
Q

Which type of control CANNOT be used with character parameters?
a. button bar
b. drop-down list
c. text input
d. slider

A

d. slider

137
Q

Where can a parameter NOT be used?
a. a calculation
b. a display rule
c. a custom category
d. a filter

A

c. a custom category

Parameters can be applied to a calculation, a display rule, a filter, or a rank.

138
Q

Suppose you want to use parameters in a report. What do you do in the Apply step?
a. determine the type of parameter needed for the scenario
b. add a control object to the canvas so the viewer can update the parameter
c. use the parameter in a calculation, a display rule, a filter, or a rank
d. add the data source to the report

A

c. use the parameter in a calculation, a display rule, a filter, or a rank

139
Q

Assume the following scenario:

  • You create a numeric parameter that ranges from 1 through 10 with a default value of 5.
  • You add a slider control to the report and assign the parameter to the control.
  • When you modify the value of the parameter, the report doesn’t change.

Why is the report not updating when the parameter is modified?
a. You forgot to apply the parameter to the report.
b. You created the incorrect type of parameter.
c. You used the incorrect control object for the parameter type.
d. You specified the incorrect range for the parameter.

A

a. You forgot to apply the parameter to the report.

SAS Viya Certification (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions