SAS Institute A00-470 Exam Questions Simulate Actual A00-470 Exam

Category:

Comments:

0 Comments

Post Date:

July 2, 2024

A00-470 exam dumps questions are designed to simulate the actual exam. This means that you will get a feel for the types of questions you can expect to see on the exam, as well as the format and difficulty level. In addition, SAS Visual Business Analytics Specialist A00-470 dumps are often accompanied by detailed explanations and answers. This means that if you get a question wrong, you can learn from your mistake and understand why the correct answer is the right one. Test free online A00-470 exam dumps below.

Page 1 of 5

1. Refer to the exhibit shown:

Two vertical bar charts are shown, first thin lines and the next thick bars.

Which method does the content developer use to change visualization1 to visualization 2.

Change the scale on the Y axis

reduce the number of bins

Remove data source filter

Edit the measure Facility Age to have only one decimal point.

2. A content developer creates a display rule for a crosstab.

What changes can the display rule apply to the crosstab?

The crosstab can be hidden if no results are returned by the display rule.

The brightness of the crosstab can be changed.

Individual cells can be color highlighted.

Rows can be color highlighted.

3. Which statement is true when importing an excel file with multiple work sheets into SAS Visual Analytics Designer

Only one work sheet can be imported at a time from excl files with multiple worksheets

All selected work sheets are imported as separate tables

You cannot import excel files with multiple work sheets

All selected worksheets are imported and concatenated together.

4. Refer to the exhibit below:

Assuming that there are data values for each city, how many different labels will be displayed when using this data item?

5. Which statement is true about setting a title for report objects in SAS Visual Analytics Designer?

Titles can only be set for report sections, not for individual report objects

Titles must include the name of the report object

if a title is entered, you can change the format and style of the title.

The tile of a report object is only visible if the user selects the report object

6. Refer to the two exhibits:

What option was added to the bubble plot in Exhibit B?

Style: Background Style

Graph Frame: Data tip font

Style: Fill was changed to solid

Graph Frame: Data tip style

7. Which statement is TRUE when importing Microsoft Office Access files into SAS Visual Analytics?

All selected tables are imported.

You can import one table at a time.

You cannot import Microsoft Access files.

All tables are imported.

8. How many data sources can each report section have in SAS Visual Analytics Designer?

250

it is determined by the preferences

Unlimited

9. Refer the exhibit below:

A content developer creates the above report in SAS Visual Analytics Designer. The report contains a report prompt, where year is set to 2010, and a section prompt on section 1 where region is set to south.

How will this report be filtered based on these prompt values?

Section1 will be filtered for region=south. section 2 will be filtered for year=2010

Section1 and section 2 will be filtered for region=south and for year=2010

Section1 will be filtered for Year=2010 and region=south. section 2 will be filtered for year=2010

Section1 will be filtered for Year=2010 and region=south. section 2 will not be filtered.

10. Which statement is TRUE when importing an Excel file with multiple worksheets into SAS Visual Analytics?

All selected worksheets are imported and concatenated.

You CAN choose the worksheet to be imported.

You CANNOT import Excel files with multiple worksheets.

All selected worksheets are imported and joined.

Page 2 of 5

11. In a bar chart created in SAS Visual Analytics Designer, what is the effect of setting the grouping scale property to normalize groups to 100%?

Bar charts that use lattice column data items are adjusted so that measures are totaled to 100% across the entire chart.

Bar charts that group a data item are adjusted so that measures in each separate group total 100%

Bar charts that use lattice column data items are adjusted so that measures in each separate lattice column total 100%.

Bar chart that group a data item are adjusted so that measures are totaled to 100% across the entire chart.

12. A 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 parameter

An action

A custom expression

An object link

13. Refer to the bar chart from SAS Visual Analytics in the exhibit below.

Note the details table for the report object.

How do you view the details table for the bar chart object?

Select View on the toolbar.

Right-click the object and select Show Data Labels.

Maximize the object.

Select Show Details Table in the Options pane.

14. A bubble plot is given, Refer the Exhibit:

For this bubble plot visualization created in SAS Visual Analytics Explorer, which statement about the data item role assignments is true.

Product cost of sale is assigned to the lattice rows role.

Profit is assigned to the measure role

Transaction Month is assigned to the datetime role

Product line is assigned to the group role.

15. The current page has page prompts displayed at the top of the page as shown in the below exhibit:

Which control object CANNOT be used in the page prompt area unless it is part of a prompt container?

Button Bar

List

Text Input

Slider

16. How can a report designer create a page in a report that is not visible to the end user?

Right-click the page name and select Hide Page.

Remove all interactions from the pages.

Edit the page authorizations and deny Read access.

Change the foreground page color to white.

17. Which statement is TRUE about the Image object?

Scale for the image cannot be adjusted.

Links cannot be added to images.

Images can be loaded from a UR

An image can be placed in the Report prompt area.

18. A content developer working in SAS Visual Analytics Designer, the user interface will not allow the content developer to add a list control to the report prompt area.

What must the content developer do so that the list control can be added to the report prompt area?

Set the global option properly on the list control and then add it.

Add a container and then add the list control to the container

Increase the size of the report prompt area then add the list control

Add the list control to the report canvas and use the duplicate / paste options.

19. Refer to the exhibits:

Which option has been added to change the pie chart from Exhibit A to Exhibit B?

Title: Custom Title

Direction: Counterclockwise

Data label location: Arrows

Data label location: Callout

20. Which statements pertaining to multiple data sources in a report are TRUE? (Choose two.)

Each object on a page can use data items from one data source or the other in their roles.

A report prompt can be applied to different data sources if the prompted data item can be mapped between the data sources.

A data filter can use data items from both data sources.

Cardinality thresholds for a report limit the number of rows processed in each of the data sources.

Page 3 of 5

21. Which is NOT a technique to move an object to a different page?

Select the object in the in the Outline pane and drag to an existing page.

Click on the object, select Move to, and then select New page.

Click on the object, select Duplicate, and then select New page.

Select the object. Click and hold then drag to a different page tab.

22. Which action in the SAS Visual Analytics Explorer creates Stacked bar charts:

Assign a category to the group role, then select stack as the grouping style in the properties tab

Assign a category to the Grouping role

Assign a category to the Grouping Style

Assign a category to the lattice columns, then select stack as the display rule.

23. A 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?

Right-click the bar chart and select Change Bar Chart to.

Change the name of bar chart to treemap in the Options pane.

Add a second measure to automatically change the object.

Drag a treemap on top of the bar chart to change the object.

24. What type of data items are required to calculate a dual axis bar line chart in SAS Visual Analytics Designer?

One category and two measures

Two categories

Two Measures

one category and one measure

25. Refer to the exhibit below:

How does the content developer create the facility (Distinct Count) data Item?

Change the classification property of Facility content to distinct count measure

Change the aggregation of Facility to Distinct count

Create a new custom category that displays the distinct count

Right click on Facility and select create Distinct count

26. Refer to the exhibit:

What gets automatically created when the report designer drags the hierarchy into the report prompt area?

A drop-down list for Product Brand.

A button bar for Product Line.

A filter action from Product Brand to Product Line.

Two parameters.

27. Which statement is NOT true about text objects?

Able to define a link to a target report.

Able to define an action to a target object.

Able to define display rules.

Able to define dynamic text.

28. Refer to the exhibit:

In this treemap from SAS Visual Analytics, Profit is currently assigned the role of Color.

If Profit were removed from this role, what would happen?

The tiles would be colored using the frequency of Revenue.

Visual Analytics would issue an error, and the treemap would not be populated.

The tiles would be colored using the frequency of Product Line

The tiles would all be the same color.

29. Refer to the exhibit below.

A content developer has a created a report that contains the Prompt Container pictured above.

Which set of properties matches what is shown in the Prompt Container?

A)

Option A

Option B

Option C

Option D

30. Refer to the exhibits:

Exhibit A

Exhibit B

How do you change the needle plot in Exhibit A to look like Exhibit B?

Change the fixed minimum value on the Y axis in the Options pane.

Override the system data limit in the Options pane.

Add a fixed baseline in the Options pane.

Add a reference line in the Options pane.

Page 4 of 5

31. Using SAS Visual Analytics Explorer, a content developer would like to examine the relationship between two measures with high cardinality.

Which visualization should the developer use?

Scatter Plot

Heat Map

Scatter Plot Matrix

Treemap

32. A report designer configures a list control to filter another list control using two-way automatic actions.

The designer should add the two list controls to which area of the report?

Report controls

Report canvas

Page properties

33. Refer to the exhibit:

How did the report designer include information (which is highlighted in the red box) about interactive filters?

Using the Interactive Filter check box in the Options pane for the report.

Using the Automatic Filters Options in the Filters pane.

Using a Text Object with the Interactive Filters option.

Using the Text Input Control object.

34. A report designer wants to add animation to a bar chart.

Which data item type should be added to the Animation role?

Date

Get A00-470 Dumps Full Version

Q&As: 135
Versions: PDF and Software Download Now

About Dumpsinfo

Dumpsinfo is a good platform providing the latest exam information and dumps questions for all IT certification exams. You can study all the latest exam dumps questions online.

[email protected]

Mon - Sat 9:00am - 6:00pm

SAS Institute A00-470 Exam Questions Simulate Actual A00-470 Exam

Related

Posts

Good A00-451 Exam Dumps Save Your Preparation Time

Pass A00-408 Exam to Get SAS Institute Certification

A00-406 Dumps Help You Study Objectives

Pass A00-282 Exam to Get SAS Institute Certification

About Us

EMAIL

Services

Opening Hours