GoConqr has a new look! Let us know what you think.

Sign up free

Flashcards

SAS Viya practice exam

Abigail Bustamante Big Data English 76 cards

Which is TRUE when the Measure heading placement is changed? a. Frequency is moved to the rows b. Origin and Frequency are…

Cards in this deck (76)

  1. 1When sorting a list table object, which statement is TRUE? a. List tables Can be sorted by multiple hierarchies b. List tables CAN be sorted by multiple columns c. List tables CANNOT be sorted by custom category d. List tables are automatically sorted in descending order by the first columnANSWER
    b. List tables CAN be sorted by multiple columns
  2. 2Which action will cause a list table object to display rows of detail data instead of aggregated data? a. Add a new display rule and select Detail Rows for the Applies to value b. Select Detail data in the Options pane c. Include a hierarchy data item in the table and expand the hierarchy to the lowest level d. Include only data items that have an aggregation of “None”ANSWER
    Select Detail data in the Options pane
  3. 3What types of data items can be added to the Rows role in a crosstab object? (Choose two) a. Category b. Single Hierarchy c. Measure d. Multiple hierarchiesANSWER
  4. 4Which is TRUE when the Measure heading placement is changed? a. Frequency is moved to the rows b. Origin and Frequency are moved to the rows c. The rows and columns are transposed d. Frequency is left justified on the columnANSWER
    a. Frequency is moved to the rows    Which is TRUE when the Measure heading placement is changed? a. Frequency is moved to the rows b. Origin and Frequency are moved to the r...
  5. 5In a bar chart, what is the effect of setting the Group scale option to Normalize groups to 100%? a. Bar charts that group a data item are adjusted so that measures are totaled to 100% across the entire chart b. Bar charts that group a data item are adjusted so that measures in each separate group total 100% c. Bar charts that use lattice column data items are adjusted so that measures in each separate lattice column total 100% d. Bar chart use lattice column data items are adjusted so that measures are totaled to 100% across the entire chartANSWER
    b. Bar charts that group a data item are adjusted so that measures in each separate
    group total 100%
  6. 6The bar chart object has a rank based on the top ten car makes by Frequency. What is the effect of selecting the New parameter option from the Count menu? a. The value of the parameter will update the number of bars shown in the bar chart b. A filter will be created using the value of the parameter to subset the number of bars shown in the bar chart c. The parameter will allow you to change the by group from Frequency to another measure d. The parameter will allow you to change Top Count to either Bottom Count, Top Percent, of Bottom PercentANSWER
    a. The value of the parameter will update the number of bars shown in the bar chart
  7. 7When adding a display rule to a dual axis line chart, which statement is TRUE? a. A display rule cannot be added to a dual axis line chart b. An expression for a display rule can only be specified on a measure c. Images can be used to represent the markers based on the display rule. d. An expression for a display rule can be applied to categoriesANSWER
    b. An expression for a display rule can only be specified on a measure
  8. 8To which role is the data item “Smoking Status” assigned? a. Y axis b. Filter c. Lattice rows d. Lattice columnsANSWER
    c. Lattice rows
  9. 9A report designer wants to add animation to a bar chart. Which data item type should be added to the Animation role? a. Date b. Category c. Measure d. GeographyANSWER
    a. Date
  10. 10Which statement is NOT true about text objects? a. Able to define a link to a target report b. Able to define an action to a target object c. Able to define display rules d. Able to define dynamic textANSWER
    b. Able to define an action to a target object
  11. 11Which control object CANNOT be used in the page prompt area unless it is part of a prompt container? a. Button Bar b. List c. Text Input d. SliderANSWER
    b. List
  12. 12Which statement is TRUE about the Image object? a. Scale for the image cannot be adjusted b. Links cannot be added to images c. Images can be loaded from a URL d. An image can be placed in the report prompt areaANSWER
    c. Images can be loaded from a URL
  13. 13This button is available for the text object. When selected, what will display in the text object? a. Report created time b. Analytic server start time c. Table modified time d. Page modified timeANSWER
    c. Table modified time
  14. 14How did the report designer include information (which is highlighted in the red box) about interactive filters? a. Using the Interactive Filter check box in the Options pane for the report b. Using the Automatic Filters Options in the Filters pane c. Using a Text Object with the Interactive Filters option d. Using the Text input Control objectANSWER
    c. Using a Text Object with the Interactive Filters option
  15. 15What happens when a report page is duplicated? a. All objects, interactions, and prompts are duplicated b. All page prompts are moved to the report prompt area c. The duplicate page is converted to a hidden page d. Interactions used in the page are NOT duplicatedANSWER
    a. All objects, interactions, and prompts are duplicated
  16. 16A report designer added a link from the bar chart to another report that uses the dame data source. Information about the link definition is found in the images. This is the only link from this bar chart. What happens when a user double-clicks the “Asia” bar in Exhibit A? a. The target report opens in a new window. No filter is applied b. The target report opens and is filtered by Origin = Asia c. The target report is imported into this report. No filter is applied d. A hidden page opens and is filtered by Origin = AsiaANSWER
    b. The target report opens and is filtered by Origin = Asia
  17. 17Which is NOT a technique to move an object to a different page? a. Select the object in the Outline pane and drag to an existing page b. Click on the object, select Move to, and then select New page c. Click on the object, select Duplicate, and then select New page d. Select the object. Click and hold then drag to a different page tabANSWER
    c. Click on the object, select Duplicate, and then select New page
  18. 18How do you change the report in Exhibit A to look like Exhibit B? a. Right-click the canvas, select White space, and then enter a number b. Select the report in the Options pane, select Padding, and then enter a number c. Select the report in the Options pane, select Margins, and enter a number d. Right-Click the report name, select Padding, and then enter a numberANSWER
    b. Select the report in the Options pane, select Padding, and then enter a number
  19. 19If Set prompt bar values of target page is selected in the Actions pane, what happens when you double click the pie chart to link to Page 2? a. The selected Product Line value is automatically displayed in the Page 2 title b. A control object based on Product Line is automatically added to Page 2 prompt area c. The bar chart Facility Region values are also linked to Page 2 d. You are given the chance to select a different Product Line while in Page 2ANSWER
    d. You are given the chance to select a different Product Line while in Page 2
  20. 20Which object can be the source of an action? a. Scatter plot b. Crosstab c. Time series plot d. ForecastingANSWER
    b. Crosstab
  21. 21A report designer needs to take a value from a control object and use it in a calculated item. Which component should the designer use? a. A parameter b. An action c. A custom expression d. An object linkANSWER
    a. A parameter
  22. 22Assume a single data source. A report designer creates the report. The report contains a report prompt, where year is set you 2019, and a page prompt on Page 1 where region is set to EAST. How will this report be filtered based on these prompt values? a. Page 1 and Page 2 will be filtered for a year = 2019 AND region= East b. Page 1 will be filtered for year = 2019 AND region = EAST. Page 2 will be filtered for year= 2019 c. Page 1 will be filtered for year= 2019 AND region EAST. Page 2 will not be filtered d. Page 1 and Page 2 will be filtered for region = EASTANSWER
    b. Page 1 will be filtered for year = 2019 AND region = EAST. Page 2 will be filtered
    for year= 2019
  23. 2324. A report designer configurates a list control to filter another list control using actions. The designer should add the two list controls to which area of the report? a. Report controls b. Page controls c. Report canvas d. Page propertiesANSWER
    c. Report canvas
  24. 24Assume Exhibit B is the only object in the report. What feature was used to achieve Exhibit B? a. Add a rank b. Create display rules c. Create a hierarchy d. Filter aggregated valuesANSWER
    d. Filter aggregated values
  25. 25In a report with report prompts of page prompts, how are prompt values displayed when it is printed? a. Only the filtered report is displayed in the PDF b. The prompt values are displayed in the report header in the PDF c. The prompt values are displayed in the appendix in the PDF d. You can choose where the prompt values are displayed in the PDFANSWER
    c. The prompt values are displayed in the appendix in the PDF
  26. 26Which statement is true about the Share Report>Link option? a. The link generated can be customized with parameters b. The link generated opens the report in edit mode when clicked c. The link downloads a PDF file of the entire report d. The link is automatically emailed to any specified userANSWER
    a. The link generated can be customized with parameters
  27. 27What can you share in SAS Visual Analytics? (Choose two) a. Pages b. Objects c. Sections d. ReportsANSWER
    b. Objects
    d. Reports
  28. 28Which statement is TRUE when importing an Excel file with multiple worksheets into SAS Visual Analytics? a. All selected worksheets are imported and concatenated b. You CAN choose the worksheet to be imported c. You CANNOT import Excel files with multiple worksheets d. All selected worksheets are imported and joinedANSWER
    b. You CAN choose the worksheet to be imported
  29. 29When importing a Microsoft Excel file, what changes can be made to the destination table? a. Rename table b. Hide columns c. Format columns d. Filter rowsANSWER
    a. Rename table
  30. 30The following comma-delimited file is imported into SAS Visual Analytics Assume the first row contains column names, and the number of rows scanned on import is 2. What type of data item will SKU be? a. Category b. Measure c. Datetime d. ParameterANSWER
    Todo lo que tenga número es
    b. measure
  31. 31Which option is NOT found in the File Specifications section when importing a delimited text file? a. Specify the input file delimiter b. Specify the number of scanned rows c. Specify the range of imported rows and columns d. Specify the source encodingANSWER
    c. Specify the range of imported rows and columns
  32. 32Which action creates a new measure that contains a count of the unique values for any particular category? a. Right-Click a category data item in the Data pane and select New calculation, then select Distinct count b. Right-click a category data item in the Data pane and select Create unique values c. Expand the properties of the data item in the Data pane and change the Aggregation to countANSWER
    a. Right-Click a category data item in the Data pane and select New calculation, then
    select Distinct count
  33. 33How does a report designer determine whether the values of a measure data item are unique? a. Change the aggregation to count and compare the count value to the number of returns rows b. Right-click the data item and select Set as unique row identifier c. Open the Measure Details window and compare the total observations and distinct count statistics d. Display the data item properties of the measure to determine if the measure has unique valuesANSWER
    c. Open the Measure Details window and compare the total observations and
    distinct count statistics
  34. 34Assuming that there are data values for each city, how many different labels will be displayed when using this data item?ANSWER
    a. 3    Assuming that there are data values for each city, how many different labels will be displayed when using this data item?
  35. 35What is one possible reason why the now geography item is returning 0% mapped values? a. The data is no longer available in memory b. The user does not have permission to create geographic data items c. The wrong Name or code context has been selected for the data item d. The geographic map provider service is not configured properlyANSWER
    c. The wrong Name or code context has been selected for the data item
  36. 36Which action would you take to correct the error in the expression for Number of Days to Receive Order? a. Change the Result Type to Date b. Use the TreatAs operator for each date data item c. Change the classification for the dates to Measure d. Format the dates using Numeric formatANSWER
    b. Use the TreatAs operator for each date data item
  37. 37A report designer can change the data source for a report. Which statement is true when the new data source is selected? a. Data roles do not need to be updated with data items form the new data source b. Data roles for category classification need to be updated with new data items c. Data roles for control objects need to be updated with new data items d. Data roles for fata items do not have the same name and classification need to be updatedANSWER
    d. Data roles for fata items do not have the same name and classification need to be
    updated
  38. 38When multiple data sources are accessed in one report, which statement is TRUE? a. A report prompt CANNOT be applied to the report b. A single page CANNOT use data items from more than one data source c. An expression CAN use data items from multiple data sources d. One object CANNOT use data items from multiple data sourcesANSWER
    d. One object CANNOT use data items from multiple data sources
  39. 39What gets automatically created when the report designer drags the hierarchy into the report prompt area? a. A drop-down list for Product Brand b. A button bar for Product Line c. A filter action from Product Brand to Product Line d. Two parametersANSWER
    c. A filter action from Product Brand to Product Line
  40. 40A category and measure are dragged to the report canvas, and a bar chart is automatically created if you wanted to use a treemap instead, what action would you take? a. Right-click the bar chart and selected Change Bar Chart to b. Change the name of the bar chart to treemap in the Options pane c. Add a second measure to automatically change the object d. Drag a treemap on top of the bar chart to change the objectANSWER
    a. Right-click the bar chart and selected Change Bar Chart to
  41. 41Which method does the report designer use to change Histogram 1 to Histogram 2? a. Change the aggregation to minimum b. Remove the data source filter c. Reduce the number of bins d. Change the scale on the Y-axisANSWER
    c. Reduce the number of bins
  42. 42In this treemap, Profit is currently assigned the role of Color. I f Profit were removed from this role, what would happen? a. The tiles would be colored using the frequency of Revenue b. Visual Analytics would issue an error, and the treemap would not be populated c. The tiles would be colored using the frequency of Product Line d. The tiles would all be the same colorANSWER
    d. The tiles would all be the same color
  43. 43What is different between the two objects?b. The Marker size property is set differently on the two objectsWhat is different between the two objects?
  44. 44Select the appropriate bar chart options to match the exhibitSelect the appropriate bar chart options to match the exhibitSelect the appropriate bar chart options to match the exhibit
  45. 45For this Bubble plot object created in SAS Visual Analytics, which statement about the data item role assignments id true? a. Revenue is assigned to the Lattice row role b. Product Line is assigned to the Group role c. Profit is assigned to the Animation role d. Product Material Cost is assigned to the Measures roleANSWER
    b. Product Line is assigned to the Group role
  46. 46When working with the text topics objects, what must the report designer set in order to use it in a report? a. Category b. Measure c. Sentiment collection d. Unique row identifierANSWER
    d. Unique row identifier
  47. 47Which Link color option has been set on the path analysis object? a. Path b. Event c. Sequence order d. Drop offANSWER
    b. Event
  48. 48Which two types of network analysis can you create in SAS Visual Analytics? (Choose two) a. Ungrouped b. Hierarchical c. Grouped d. ClusteredANSWER
    a. Ungrouped
    b. Hierarchical
  49. 49Which source table is structured appropriately for the path analysis?ANSWER
    a.    Which source table is structured appropriately for the path analysis?Which source table is structured appropriately for the path analysis?
  50. 50How so you view the details table for the bar chart object? a. Select View on the toolbar b. Right-click the object and select Show Data Labels c. Maximize the object d. Select Show Details Table in the Options paneANSWER
    c. Maximize the object
  51. 51The report designer has just changed the filter to add more data to this line chart. Why are some of the lines outside of view? a. Fixed minimum and maximum has been set on the axis b. The data does not fit c. There is too much data for a line chart d. Data outside of the chart can be ignoredANSWER
    a. Fixed minimum and maximum has been set
  52. 52Which option has been added to change the pie chart from Exhibit A to Exhibit B? a. Title: Custom Title b. Direction_ Counterclockwise c. Data label location: Arrows d. Data label location: CalloutANSWER
    d. Data label location: Callout
  53. 53What option was added to the bubble plot in Exhibit B? a. Style: Background Style b. Graph Frame: Data tip font c. Style: Fill was changed to solid d. Graph Frame Data tip styleANSWER
    a. Style: Background Style
  54. 54The chart has been filtered to display Year > 2007. The forecast confidence is 95%. What must you do if you want to enable the What If button in the Roles pane? a. Add underlying factors b. Expand the forecast horizon c. Remove the filter d. Increase the forecast confidenceANSWER
    a. Add underlying factors
  55. 552. Where to click when you want to see the page control area (literal seleccionar) ​ANSWER
    Se debe picar en los puntitos    2. Where to click when you want to see the page control area (literal seleccionar) ​
  56. 56What is not shown in data source menu?ANSWER
    Rename data source​    What is not shown in data source menu?
  57. 574. What can be schedule to share ​ANSWER
    You can schedule report distribution through email to a set of users, groups or both​
  58. 585. What is shared in the email​ANSWER
    Link to the report, and a summary: SAS Visual Analytics automatically adds a subject line with the report name. The URL for the report is automatically generated and appears in the email message.​
  59. 596. Where to click when you want to see forecast algorithm​ANSWER
    Dependent variable results tab​
  60. 607. Why what-if button is grey out​ANSWER
    No hay underlying factors ​
  61. 618. What can you do/can’t do when import local file​ANSWER
    You can import data from a Microsoft Excel spreadsheet (XLS or XLSX), a text file (CSV or TXT), or a SAS data set (SASHDAT or SAS7BDAT).​
  62. 629. What does color represent for path analysis​ANSWER
    A path, an event or drop out ​
  63. 6310. Alert for a display rule​ANSWER
    You can use the Display Rules pane to add alerts when you create an expression-based display rule. An alert for a display rule notifies users via email when the alert condition is met. You can specify how frequently the system checks to see whether the alert condition has been met. You can also specify how often users are notified.​
  64. 6411. How to create distinct count variable​ANSWER
    select New data item > Calculated item. Result Type needs to be Aggregated Measure. Click Operators and expand the Numeric (simple) group. ​
  65. 6512. What is basic data role for gauge object ​ANSWER
    Measure
  66. 6614. How can you change data format from DDMMYY to YEAR from data pane​ANSWER
    .In the Data pane, right-click a data item, select Format?​
    Formats can be modified for datetime data items and measures
  67. 6715. How can you specify reference line in the object​ANSWER
    Select the object and click Options pane.​
  68. 6816. Treemap: Which variables represent tile, size, color, data tip values​ANSWER
    Tiles: the value of a category or hierarchy node ​
    Size and color: measures (cannot be below zero and must have an aggregation of sum.)
  69. 6918. Which container te deja manejar el depth de los objetos?​ANSWER
    Precision Container​
  70. 7019. Which container objects is being used in the sample report (precision/prompt/stacking/standard container) – Hay muchas de containers​ANSWER
    Standard – arranges objects horizontally or vertically and supports reflow ​
    · Stacking – stacks objects on top of one another; however, only one object is visible at a time. has a control bar that lets you move between objects​
    · Precision – gives you total control over objects locations and sizes ​
    ·Prompt Container- groups prompt controls. ​
    · Scrolling Container- displays content in a scrolling layout, where each object fills the entire container area and you scroll to see other objects. You can select either a vertical layout or a horizontal layout. ​
  71. 7120. How many reports are visible for end user -> (muestra 2 hidden reports y 2 reports with normal and “hidden” name) ​ANSWER
    2
  72. 7221. ¿Como funcionan las alertas? Le hubiera llegado una alerta cada día o solo el primer día ​ANSWER
    Venía algo tipo:​
    Real sales > estimated sales ​
    Green ​
    1er día: 600,000 sales ​
    Estimated sales 560,000​
    2do día: 580,000 real sales ​
    550,000 estimated sales ​
    Según yo avisa en el día 1 y dos porque no está fijo y por eso descartas las respuestas de que siempre que sea mayor a $550,000
  73. 73¿Qué no se puede poner en un contenedor?ANSWER
    Filter
  74. 7424. Muestra una grafica con una línea a la mitad y pregunta cómo se genera esa línea​Al poner “new reference line” se pone una a la mitad, pero en “value” lo puedes cambiar​
  75. 7531. Que feature permite distribuir múltiples reportes? Opciones: Schedule, share reports y otras que no me acuerdo ​Creo que es Schedule ​
  76. 7633. Cell graphs/heat maps de un crosstable … era un crosstable con una columna de varios colores. ​Es una cell graph con heat map (como la de frequency). Si fuera un heat map sería un objeto independiente, no un cross tab… según yo ​
    * El “order amount” es un cell grpah con bar

Information

Description
Big Data Flashcards on SAS Viya practice exam, created by Abigail Bustamante on 23/01/2024.
Views
4
Rating

More on Business Reporting and Dashboards

Feedback

What is it about?

What do you think of the new look?

How do you like it?