Commonly Asked SAS Interview Questions with Answer (ST) : 11 - 15

Ques (ST) 11 : What are the different types of SAS Application Server's required for SAS Enterprise Guide to run ?

Ans : SAS Enterprise Guide interacts with different types of SAS Application Server's to perform all activities which are mentioned below :

1. SAS Metadata Server : To read and write metadata to SAS metadata repository
2. SAS OLAP Server : To process queries for cubes
3. SAS Stored Process Server : To execute store processes
4. SAS Workspace Server : To execute SAS codes and to access data

Ques (ST) 12 : Can we create CUBES by using SAS Enterprise Guide now ?

Ans : No, Now we cannot create CUBES by using SAS Enterprise Guide.

We can only view cubes by using OLAP Analyzer in SAS Enterprise Guide.

• We can build cubes by using SAS OLAP CUBE Studio or SAS DI Studio

Ques (ST) 13 : What are the different types of SAS Application Server's required for SAS Add-In Microsoft Office ?

Ans : SAS Add-In Microsoft office interacts with following SAS Application Server's :

1. SAS Metadata Server
2. SAS Stored Process Server
3. SAS Workspace Server

• SAS Add-In Microsoft office does not communicate with SAS OLAP Server but Microsoft Excel can access SAS OLAP cubes by using pivot table facility which is in-built in MS Excel

Ques (ST) 14 : What are the different types of SAS Application Server's required for SAS Information Map Studio ?

Ans : SAS Information Map Studio interacts with following SAS Application Server's :

1. SAS Workspace Server
2. SAS Metadata Server
3. SAS OLAP Server

Ques (ST) 15 : What are SAS Information maps and who uses it ? What is the basic role of SAS Information Map Studio ?

Ans : SAS Information Maps includes metadata which explains data warehouse in business terminology. 
It displays the data in business term with labels in spite of tables and columns name as in data warehouse to business user.

SAS Information Maps consists physical tables, relations between tables and business rules.

Business users use Information Maps.

SAS Information Map Studio works like a bridge between data warehouse and business user who builds reports from data.