Developer Quiz - SAS Bi 9.2

33 Questions
SAS Quizzes & Trivia

A SAS 9. 2 Developer Quiz

Sample Question

In SAS Web Report Studio 4.3, for prompts, a default value is no longer required.

True

False

Number of Questions:

More Options
Please wait...
Questions and Answers
  • 1. 
    In SAS Web Report Studio 4.3, for prompts, a default value is no longer required.
    • A. 

      True

    • B. 

      False

  • 2. 
    In SAS WRS 4.3 You can now insert rows and columns between existing rows and columns in the layout grid using the vertical toolbar.
    • A. 

      True

    • B. 

      False

  • 3. 
    SAS WRS 4.3, dynamic text could be:
    • A. 

      Included in header and footer

    • B. 

      Acts a placeholder for text that will be generated from data when the report is viewed.

    • C. 

      Enables you to include information such as the name and description of the data source that is supplying the data for the report

    • D. 

      All of the above

  • 4. 
    SAS WRS 4.3: Which of the following is NOT part of the quick start method for creating a new saved report?  
    • A. 

      Report Wizard

    • B. 

      Using Template

    • C. 

      Save a Report Based on a Data Source

    • D. 

      Base new report on an existing

    • E. 

      All of the above are part of the quick start method

  • 5. 
    There are _____ quick start methods for creating a new saved report in SAS WRS 4.3
  • 6. 
    Edit mode contains a layout grid for placing and arranging objects in the body of the report section. The grid consists of cells into which you place tables, graphs, geographical maps, stored processes, text, and images.  Which of the following is NOT a part of the default layout?
    • A. 

      Does not contain any report object

    • B. 

      It contains four (4) cells

    • C. 

      The option for synchronizing objects is enabled

    • D. 

      Cells are left-aligned

  • 7. 
    SAS Web Report Studio 4.3 provides text formatting tools in the _____ Text dialog box,
  • 8. 
    To insert one or more stored processes into a report layout, perform these tasks to insert a stored process object
    • A. 

      Drag the stored process tool from the toolbar into a specific cell

    • B. 

      Click on the horizontal toolbar

    • C. 

      All of the above

    • D. 

      One of the Above

  • 9. 
    When specifying group break parameters for the stored process in SAS Web Report Studio 4.3, you cannot complete this step if no stored process has been assigned to the stored process report object, if no group breaks are defined in the section that contains the stored process, or if the stored process does not contain any parameters.
    • A. 

      True

    • B. 

      False

  • 10. 
    Measures used in a custom data item expression are always calculated by using the default aggregation method. Within SAS Web Report Studio, it is not possible to produce a detailed calculation.
    • A. 

      True

    • B. 

      False

  • 11. 
    SAS Web Report Studio 4.3, If your query does not include a time hierarchy from a multidimensional data source, then you can create a custom data item that is based on relative time
    • A. 

      True

    • B. 

      False

  • 12. 
    SAS Web Report Studio 4.3, for multidimensional data sources, records are always grouped and the aggregation method of a measure cannot be changed.
    • A. 

      True

    • B. 

      False

  • 13. 
    To change the format of a data item, complete these steps in SAS Web Report Studio 4.3: 
    • A. 

      In the Section Data panel, right-click a data item, and then select Format to open the Define a Format dialog box.

    • B. 

      Select a Type of format. For measure data items, the options are Default, Currency, and Number

    • C. 

      Click OK

    • D. 

      All of the above

    • E. 

      None of the above, you cannot change the data format

  • 14. 
    Which of the following is NOT part of the Report Distribution Feature in SAS Web Report Studio 4.3?
    • A. 

      The Distribute Report Wizard enables you to distribute reports by using e-mail with a PDF attachment or as embedded HTML.

    • B. 

      Reports can be distributed multiple times.

    • C. 

      Only advanced users can distribute reports or manage recipient lists

    • D. 

      The distributed output saved to the report repository.

  • 15. 
    Comments are not exported with a report in SAS Web Report Studio 4.3?
    • A. 

      True

    • B. 

      False

  • 16. 
    Check All that Apply The SAS OLAP environment uses the following Java desktop applications
    • A. 

      SAS Management Console

    • B. 

      SAS OLAP Server Monitor

    • C. 

      SAS OLAP Cube Studio

  • 17. 
    Some functions that you can perform on a cube after it is created, Check all that Apply:
    • A. 

      Tune the aggregations for the cube

    • B. 

      Add and edit calculated members and measures for the cube

    • C. 

      Incrementally update the cube

    • D. 

      Export and then import a SAS package between SAS environments

  • 18. 
    In order to define cubes, you must be connected to a running metadata server.
    • A. 

      True

    • B. 

      False

  • 19. 
    A drill-through table can be a view, data set, or other data file that contains data that is used to define a cube
    • A. 

      True

    • B. 

      False

  • 20. 
    Drill through tables sources could be:
    • A. 

      Detail data tables

    • B. 

      Star schema

    • C. 

      None of the above

    • D. 

      A and B

  • 21. 
    SAS Information Map 4.2: To create Information Map Studio select two of the main tasks:
    • A. 

      Set application preferences for SAS Information Map Studio.

    • B. 

      Create a connection profile

    • C. 

      Create data

    • D. 

      Define data source

  • 22. 
    To create a SAS Information Map one of the task is Create and customize data items.
    • A. 

      True

    • B. 

      False

  • 23. 
    SAS Info Map: In order to use your data sources together in a query, you must create a ________ between them
  • 24. 
    SAS Info Map: The cardinality setting enforces the cardinality between data sources
    • A. 

      True

    • B. 

      False

  • 25. 
    SAS Info Map: When creating a filter the first step is to navigate to Information Map Contents pane and select Information Map icon and then navigate to the Design tab.
    • A. 

      True

    • B. 

      False

  • 26. 
    You cannot apply mandatory filters (prefilters) to selected relational data sources and users to prescreen data for queries.
    • A. 

      True

    • B. 

      False

  • 27. 
    The SAS Information Delivery Portal provides a framework that enables you to develop and deploy custom portlets that meet your organization's needs
    • A. 

      True

    • B. 

      False

  • 28. 
    A portlet archive (PAR) file which is an XML file that specifies the portlet's actions as well as initialization, path, and access control information
    • A. 

      True

    • B. 

      False

  • 29. 
    The action and initializer classes included in the SAS Information Delivery Portal are designed to handle a portlet's basic function of displaying multiple JSP page
    • A. 

      True

    • B. 

      False

  • 30. 
    You can create Java classes, JSP pages, and other supporting files to implement portlets using any Java integrated development environment (IDE).
    • A. 

      True

    • B. 

      False

  • 31. 
    SAS Information Delivery Portal 4.3 check all that apply:
    • A. 

      A new Customize menu is available from the banner. Some options from the Options menu have been moved to the Customize menu to improve usability.

    • B. 

      Data explorations are no longer available from the portal. Any data explorations from earlier versions of SAS have been converted to reports.

    • C. 

      Publishing SAS Information Maps is no longer supported.

    • D. 

      Data explorations are available from the portal.

  • 32. 
    SAS Portal can contain SAS content, such as SAS Information Maps, SAS reports, SAS Stored Processes, and packages created by the SAS Publishing Framework but not the Other Web content, including Web applications, documents, links to internal or external Web pages, and syndication channels that provide syndicated, continually updated Web content.
    • A. 

      True

    • B. 

      False

  • 33. 
    In Information Portal when you click on an information map, it opens in SAS Web Report Studio or SAS Web Report Viewer as a SAS report
    • A. 

      True

    • B. 

      False