Skip to main content

A00-270 Real Exam Questions

SAS BI Content Developmentfor SAS 9

107 questions available · Page 1 of 11

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

Which data sources can be used to create reports and analysis using SAS Web Report Studio? (Choose two.)

  1. A

    SAS Information Map

  2. B

    SAS OLAP cube

  3. C

    SAS Stored Process

  4. D

    SAS table

Show answer and explanation

Correct answers: A, C

Question 2 Single choice

A stored process is created from all of the tasks in a SAS Create New Stored Process Wizard?

  1. A

    The code is included from the metadata

  2. B

    The code is included from the process flow

  3. C

    The code is referenced from an external file

  4. D

    The code is written manually

Show answer and explanation

Correct answer: A

Question 3 Multiple choice

Which delivery methods are valid for alerts in a SAS BI Dashboard? (Choose two.)

  1. A

    Alerts Portlet

  2. B

    SAS BI Dashboard Portlet

  3. C

    Stored Process Alerts Portlet

  4. D

    Email

Show answer and explanation

Correct answers: A, D

Question 4 Single choice

Refer to the exhibit.

Which technique was used to produce the separate pie charts?

  1. A

    Pie Subgroup from the Assign Data Window

  2. B

    Multiple Pies from the Properties Window

  3. C

    Grouped Pies from the Properties Window

  4. D

    Horizontal Series from the Assign Data Window

Show answer and explanation

Correct answer: B

Question 5 Single choice

Refer to the exhibit.

Why is there a warning icon in this bar-line chart in SAS Web Report Studio?

  1. A

    There are empty cells with no report objects.

  2. B

    The properties of the bar line chart have not been set.

  3. C

    The report has not been saved.

  4. D

    There are not enough measure data items.

Show answer and explanation

Correct answer: D

Question 6 Single choice

The metadata libname engine is commonly used with stored process to ensure that metadata security is enforced to control access to the data.

Which options do not have a default value and must be manually coded in the libname statement?

  1. A

    PORT = option
    AND
    PROTOCOL = option

  2. B

    REPNAME = option
    OR
    REPID = option

  3. C

    LIBRARY = option
    OR
    LIBID = option

  4. D

    USERID = option
    AND
    PASSWORD = option

Show answer and explanation

Correct answer: C

Question 7 Single choice

The required components of a SAS BI Dashboard are:

  1. A

    Data Model, Range, Indicator, and Dashboard

  2. B

    Data Model, OLAP Cube, Indicator, and Dashboard

  3. C

    Information Map, Indicator, Range, and Dashboard

  4. D

    Data Model, Stored Process, Indicator, Range, and Dashboard

Show answer and explanation

Correct answer: A

Question 8 Single choice

Refer to the exhibit and note the error.

The data model for this SAS BI Dashboard has been built using a SAS Information Map.

What is the reason for the error?

  1. A

    The SAS Information Map used as a data source does not have a measure defined.

  2. B

    The content developer does not have the ReadMetadata permission on the SAS Information Map.

  3. C

    The SAS Information Map was built using an OLAP Cube.

  4. D

    The gauge type for the indicator is not correct and needs to be changed.

Show answer and explanation

Correct answer: A

Question 9 Single choice

A SAS Information Map is based on multiple relational tables.

Which statement is true regarding the relationship?

  1. A

    The default join is an inner join

  2. B

    A relationship can be created only if column names in the data sources match

  3. C

    A relationship can be created even if the joining columns are different types

  4. D

    The default join created is a full outer join

Show answer and explanation

Correct answer: B

Question 10 Single choice

A dashboard shows a horizontal row of three static Traffic Light gauges. Each Traffic Light gauge is positioned vertically instead of horizontally.

What should be done to position each gauge horizontally?

  1. A

    Select Flip Horizontal on the gauge properties.

  2. B

    Ensure the dashboard and indicator are the correct width to display three gauges.

  3. C

    Reduce the display size of the gauge sufficiently to allow all three to fit.

  4. D

    Change to a gauge type that supports horizontal display of multiple gauges.

Show answer and explanation

Correct answer: B