Table of Contents
Creating Advanced Reports with SAS Visual Analytics Week 1 Quiz Answer
Quiz : Creating Advanced Data Items Review
Q1. What type of data items can be created outside of Visual Analytics (for example, in SAS Data Studio or using SAS code)?
- Parameters
- Geography data items
- Hierarchies
- Calculated items
Q2. In the following calculated item, why does the expression generate an error?
- You cannot name a calculated item the same name as an existing data item.
- Missing is an invalid value.
- The In operator does not work for character data.
- The calculated item type does not match the result from the expression.
Q3. Which date and time operator creates a date value?
- Now
- Month
- DatePart
- DayOfMonth
Q3. Which operator enables a numeric or datetime value to be used as a different type for the calculation?
- Replace
- Parse
- TreatAs
- Update
Q5. Which aggregated (periodic) operator can be used to return aggregated values for next month?
- RelativePeriod
- CumulativePeriod
- Period
- ParallelPeriod
Q6. For aggregated (periodic) operators, which time filters option applies all filters (object filters and interactive filters) AFTER the measure is calculated?
- ApplyAllFilters
- IgnoreInteractiveTimeFrameFilters
- IgnoreAllTimeFrameFilters
- ApplyFiltersLast
Q7. For aggregated (periodic) operators, which scope parameter will aggregate the measure for the entire period (the entire month, quarter, or year)?
- ToDate
- All
- ToToday
- Full
Q8. Which aggregated (periodic) operator can be used to calculate a running total for the fiscal year?
- CumulativePeriod
- Period
- RelativePeriod
- ParallelPeriod
Q9. Which aggregated (advanced) operator will hide values based on a condition?
- HideValues
- SuppressValues
- Suppress
- Hidden
Q10. Which aggregated operator can be used to calculate a running total over a category?
- CumulativeCells
- AggregateCells
- AggregatePeriod
- CumulativePeriod
Creating Advanced Reports with SAS Visual Analytics Week 2 Quiz Answer
Quiz : Using Parameters to Create Advanced Reports Review
Q1. Suppose you want to use parameters in a report. What do you do in the Create step?
- Add the data source to the report.
- Use the parameter in a calculation, a display rule, a filter, or a rank.
- Determine the type of parameter needed for the scenario.
- Add a control object to the canvas so the viewer can update the parameter.
Q2. Suppose you want a viewer to specify the minimum salary. What type of parameter would you create?
- Multiple values
- Date
- Numeric
- Character
Q3. Suppose you want a viewer to enter a string to search for a product. What type of parameter would you create?
- Multiple Values
- Character
- Date
- Numeric
Q4. 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
- Numeric
- Character
- Date
- Multiple values
Q5. Suppose you want to use parameters in a report. What do you do in the Populate step?
- Add the data source to the report.
- Add a control object to the canvas so the viewer can update the parameter.
- Use the parameter in a calculation, a display rule, a filter, or a rank.
- Determine the type of parameter needed for the scenario.
Q6. Which types of controls can be used with numeric parameters?
- Slider, button bar
- Text input, button bar
- Slider, drop-down list
- Text input, slider
Q7. Which types of control CANNOT be used with character parameters?
- Drop-down list
- Text input
- Slider
- Button bar
Q8. Where can a parameter NOT be used?
- A filter
- A custom category
- A display rule
- A calculation
Q9. Suppose you want to use parameters in a report. What do you do in the Apply step?
- Add the data source to the report.
- Add a control object to the canvas so the viewer can update the parameter.
- Determine the type of parameter needed for the scenario.
- Use the parameter in a calculation, a display rule, a filter, or a rank.
Q10. Assume the following scenario:
You create a numeric parameter that ranges from 1-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?
- You specified the incorrect range for the parameter.
- You used the incorrect control object for the parameter type.
- You forgot to apply the parameter to the report.
- You created the incorrect type of parameter.
Get SAS Visual Business Analytics Professional Certificate Quiz Answers
Getting Started with SAS Visual Analytics Coursera Quiz Answers
Data Analysis and Reporting in SAS Visual Analytics Quiz Answers
Using Data for Geographic Mapping and Forecasting in SAS Visual Analytics Quiz Answers
Performing Network, Path, and Text Analyses in SAS Visual Analytics Quiz Answers
Creating Advanced Reports with SAS Visual Analytics Quiz Answers