SASInstitute SAS BI Content Development (A00-270) Free Practice Test
Question 1
The customer wants to build a SAS OLAP Cube from data stored in separate dimension and a fact table. What type of input would be used to build the customer cube?
Correct Answer: D
Question 2
Refer to the exhibit.
A user is running a stored process from a SAS Web Report Studio report. The stored process has a cascading prompt requesting the user to select Country then Department. The user attempts to select a value but the drop down for Country is empty. Why are the values for the prompt missing?
A user is running a stored process from a SAS Web Report Studio report. The stored process has a cascading prompt requesting the user to select Country then Department. The user attempts to select a value but the drop down for Country is empty. Why are the values for the prompt missing?
Correct Answer: C
Question 3
When a SAS Web Report Studio report is built, the default behavior is to produce an aggregated report with measures summed. Average is a more appropriate aggregation for an age data item. In the information map, how can the aggregation be changed to average the measures?
Correct Answer: A
Question 4
Refer to the exhibit.
A SAS Information Map has been built with the SAS OLAP Cube that has been structured as shown in the exhibit. You want to generate a SAS Web Report Studio report using the information map that contains the cube data. A SAS Information Map has been built with the SAS OLAP Cube that has been structured as shown in the exhibit. You want to generate a SAS Web Report Studio report using the information map that contains the cube data. A SAS Information Map has been built with the SAS OLAP Cube that has been structured as shown in the exhibit. You want to generate a SAS Web Report Studio report using the information map that contains the cube data. Which selection is valid?
A SAS Information Map has been built with the SAS OLAP Cube that has been structured as shown in the exhibit. You want to generate a SAS Web Report Studio report using the information map that contains the cube data. A SAS Information Map has been built with the SAS OLAP Cube that has been structured as shown in the exhibit. You want to generate a SAS Web Report Studio report using the information map that contains the cube data. A SAS Information Map has been built with the SAS OLAP Cube that has been structured as shown in the exhibit. You want to generate a SAS Web Report Studio report using the information map that contains the cube data. Which selection is valid?
Correct Answer: B
Question 5
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?
Correct Answer: C
Question 6
In which application can you create shared prompts?
Correct Answer: C
Question 7
Which SAS applications can be used to create data sources for reporting and analysis using the SAS platform applications? (Choose two.)
Correct Answer: A,B