SAS BI Interview Question and Answers

1. What are the softwares and applications that are used most frequently used by SAS bi applications developers?

A: SAS AppDev Studio

SAS A/F

SAS/Internet

                 

2. What are the applications primarily used by business analyst?

A: SAS bi dashboard

SAS Enterprise Guide

SAS Information Map Studio

SAS OLAP Cube Studio

SAS Stored Process

SAS Visual BI

3. How will you locate the SAS platform applications?

A: Go to

SAS >> All Programs>>SAS

4. How will you location SAS platform applications available from web browser?

A: Start>> internet

View the links stored as favorites in internet explorer

5. Why is the SAS Add-in for Microsoft Office not available in the SAS group from the Windows Start menu?

 A: The SAS add-in is a software component that is available from within Microsoft Excel, Microsoft Power and Microsoft Word

6. What is the limit of the number of the rows and columns available in the worksheet

A: 1 million rows and 16000 columns

7. What are several options for creating reports in Web Report Studio?

A:  There are three options

Report wizard which consist of five steps

Templates that contain report layout information

Edit mode, which provide full control over all aspects of report creation

8. What is the primary data source for the WRS?

A: Information maps

9. How many types of prompts are there?

A: Four type:

Dynamic prompts

Cascading prompts

Relative date/Time prompts

Range prompts

10. How many types prompting framework can be broken down to?

A: Design time: creating the framework to ask questions and have the results passed to the application

Run time: Displaying the prompt in an application and processing the user input.