SAS Visual Analytics for Viya Flashcards
(139 cards)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
19
Q
What are the requirements for a Network Analysis?
A
Data must have one row for each source-target pair
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
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.
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)
23
Q
Which type of network analysis object shows parent-child relationships?
a. linked
b. hierarchical
c. ungrouped
d. targeted
A
b. hierarchical
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
25
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. 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).
26
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
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.
27
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. two geographies
28
What is a Path Analysis and how are they used?
* 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.
29
What can the color of a Link's Path be configured to indicate?
* 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
30
What are the data requirements for a Path Analysis?
* 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
31
Which table is structured appropriately for path analysis in SAS Visual Analytics?
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.
32
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. 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.
33
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
b. by event
Coloring links by event makes it easier to visually compare the same event throughout the path analysis object.
34
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
c. by drop off
35
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
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.
36
How are the links colored in this path analysis object?
a. by path
b. by event
c. by drop off
d. by weight
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.
37
How are the links colored in this path analysis object?
a. by path
b. by event
c. by drop off
d. by weight
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.
38
Which path is most common in this path analysis object?
a. 1
b. 2
c. 3
d. 7
a. 1
In this example, the most common path is the teal path (path 1). There are seven identifiers that follow this specific path.
39
How are the links colored in this path analysis object?
a. by path
b. by event
c. by drop off
d. by weight
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.
40
How are the links colored in this path analysis object?
a. by path
b. by event
c. by drop off
d. by weight
a. by path
In this example, the links are colored by path. Notice how each path is a separate color.
41
Describe the Text Topics objects.
* 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
42
What is sentiment analysis?
It is a text topic object that categorizes documents as positive, neutral, or negative
43
What 3 things are required for a text topics object?
* 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
44
How does Text Analytics work?
* 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)
45
What is a stop list?
A table of common words that are ignored during text analytics
46
How are terms scored for sentiment analysis?
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
47
What are term roles?
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).
48
What are Stem words?
Different forms of a given word. For example, sell is the stem word of the following: sell, sells, selling, sold.
49
What are documents?
Unstructured text. These are displayed in the documents list table and are a single row in the data source.
50
What are terms?
Words or phrases. These are displayed in the terms word cloud.
51
What are topics?
Words that often appear together in documents. These are displayed in the topics bar chart.
52
What are Topic Term weights?
Indicates the importance of the word in the topic.
53
What are Derived Data Items?
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.
54
What are derived topics?
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.
55
What are derived relevance?
The value represents the relevance of the document in that topic.
56
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
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
Which role enables you to add additional information to text analytics?
a. Document collection
b. Document details
c. Language
d. Unique row identifier
The Document details role in a text topics object enables you to add additional information to text analytics.
58
Which table is structured appropriately for text analytics in SAS Visual Analytics?
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
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.
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
What is displayed in the text topics bar chart?
a. documents
b. terms
c. topics
d. roles
c. topics
The text topics bar chart displays the document count for each topic.
61
What is displayed in the text topics word cloud?
a. documents
b. terms
c. topics
d. roles
b. terms
The text topics word cloud displays the topic weight for each term.
62
What is displayed in the text topics list table?
a. documents
b. terms
c. topics
d. roles
a. documents
The text topics list table displays the topic relevance for each document.
63
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.
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
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. location, customer, city, novelty
The location, customer, city, novelty topic contains the greatest number of positive documents (green portion of the bar).
65
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.
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
What are examples of data items that cannot be created ahead of time before/outside of a report in VA?
hierarchies, geography data items, aggregated measures, and parameters
67
What data items should not be created ahead of time before/outside of a report in VA?
data items that are seldom used or those that you would like to be more dynamic (like customer ages and employee tenure)
68
What are examples of data items that can be created before data is imported to CAS?
custom category, a duplicate, and a calculated item
69
What are examples of data items that can be created in SAS VA report?
a geography, a hierarchy, parameters, aggregated measures, derived items, and a distinct count
70
Custom category
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
Duplicate
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
Calculated
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
Geography
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
Aggregated measure
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
Hierarchy
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
Distinct count
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
Parameter
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
Derived items
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
What is a vector plot?
* 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
What is a Butterfly Chart used for?
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
What is a Needle Plott used for?
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
What is a Dot Plot used for?
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
What are the 2 types of calculated items can you create in VA?
* 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
What is aggregation context?
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
What is the Relative Period operator?
A Period Operator that returns aggregated values for a period of time relative to the current period.
86
What is the aggregation type parameter for period operatpors?
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
What is the measure parameter for period operators?
the measure parameter specifies the measure data item used for the expression
88
What are time filter parameters for period operators?
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
What are date parameters for period operators?
Date parameter specifies the date data item for the expression. All periodic operators require dates that include a year value.
90
What are aggregation interval parameters for period operators?
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
What are offset interval parameters for period operators?
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
What are scope parameters for period operators?
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
What are subset day parameters for period operators?
The subset day parameter specifies the chosen date when the ToDate scope parameter is selected.
94
What does the suppress operator do?
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
What are the Suppress operator parameters?
* 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
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
c. calculated items
Custom categories, duplicates, and calculated items can be created outside of SAS Visual Analytics, before data is loaded to CAS.
97
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.
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
Which date and time operator creates a date value?
a. DatePart
b. DayOfMonth
c. Month
d. Now
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
Which aggregated (periodic) operator can be used to return aggregated values for next month?
a. CumulativePeriod
b. ParallelPeriod
c. Period
d. RelativePeriod
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
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
c. IgnoreAllTimeFrameFilters
The IgnoreAllTimeFrameFilters option for periodic operators applies all filters (object filters and interactive filters) after the measure is calculated.
101
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
b. Full
The Full option for periodic operators calculates the aggregated measure using full intervals (full months, quarters, or years).
102
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. CumulativePeriod
103
Which aggregated (advanced) operator hides values based on a condition?
a. HideValues
b. Hidden
c. Suppress
d. SuppressValues
c. Suppress
104
Which aggregated operator can be used to calculate a running total over a category?
a. CumulativePeriod
b. CumulativeCells
c. AggregateCells
d. AggregatePeriod
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
What are the 2 types of filters?
Static Filters that can only be modified by the report designer
Interactive Filters that can be modified by the report designer and user.
106
What are the 2 types of Static Filters?
* 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
What are Global Level filters?
A data filter can be added to subset the entire report. This filter is applied to every object that uses the data source.
108
What are Local Level filters?
At the local level, basic and advanced report filters can be added to subset individual report objects.
109
What are post-aggregate report filters?
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
In what order are filters applied?
* Data source filters would be applied first,
* Then any basic or advanced filters,
* Lastly post-aggregate filters
111
What are the 3 types of interactive filters?
* 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
What are the 2 types of prompts?
* Report Prompts
* Page Prompts
113
What is Automatic Linked Selection Action?
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
What is Automatic One-Way Filters Action?
* 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
What is Automatic Two-Way Filters Action?
* 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
What is mapping data sources?
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
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. detail report filters
118
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
b. post-aggregate report filters
119
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
c. advanced filter
120
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
c. prompts
121
Which type of interactive filter subsets specific objects on a page?
a. detail report filters
b. post-aggregate report filters
c. prompts
d. actions
d. actions
122
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
b. report, page, URL
123
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. automatic linked selection
124
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
d. automatic two-way filter
125
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
b. the bar chart and the list table
126
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.
b. QUARTER in TABLE A should be mapped to QUARTER in TABLE B
127
What are parameters?
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
What are the 3 steps for using parameters?
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
Where can parameters be applied?
Parameters can be applied to a calculation, a display rule, a filter, or a rank.
130
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. determine the type of parameter needed for the scenario
131
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. numeric
132
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
b. character
133
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. numeric
If you want the viewer to enter the number of years (a number), you need to create a numeric parameter.
134
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
b. add a control object to the canvas so the viewer can update the parameter
135
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
b. text input or slider
136
Which type of control CANNOT be used with character parameters?
a. button bar
b. drop-down list
c. text input
d. slider
d. slider
137
Where can a parameter NOT be used?
a. a calculation
b. a display rule
c. a custom category
d. a filter
c. a custom category
Parameters can be applied to a calculation, a display rule, a filter, or a rank.
138
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
c. use the parameter in a calculation, a display rule, a filter, or a rank
139
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. You forgot to apply the parameter to the report.
