Practice Question Answers and Explanations

1. Correct answer: C

   SAP BusinessObjects Analysis, edition for Microsoft Office is Excel-based and can handle parent-child hierarchies.None of the other three business intelligence tools are Excel-based

2. Correct answer: B

   SAP Crystal Reports for Enterprise create pixel-perfect reports. SAP BusinessObjects Design Studio is not a reporting tool. SAP BusinessObjects Web Intelligence SAP Lumira are not used for creating pixel-perfect reports.

3. Correct answer: A

   SAP BusinessObjects Design Studio can display results on a mobile device, has a WYSIWYG design environment and scripting, and can be used to create dashboards. SAP Lumira and SAP BusinessObjects Web Intelligence are not dashboard-building tools.

4. Correct answer: C

   You use a Transient Provider to expose an SAP BW information object inside SAP HANA. See SAP BW Consuming SAP HANA Information Models.

5. Correct answers: A, B

   SAP Lumira can publish your business intelligence content directly to the SAP Cloud for Analytics. SAP Predictive Analytics is built on SAP Lumira. See the SAP Cloud for Analytics section.

6. Correct answer: D

   Microsoft Excel queries SAP HANA using MDX via the ODBO driver. See Figure 15.2. It is the only business intelligence tool in this chapter that uses the ODBO driver.

7. Correct answers: B, D

   SAP BusinessObjects Analysis and SAP BusinessObjects Design Studio use BICS.

8. Correct answer: D

   SAP Predictive Analytics is based on SAP Lumira, and SAP Lumira can publish storyboards.

9. Correct answers: A, D

   JavaScript knowledge may be required for SAP BusinessObjects Design Studio (see Figure 15.6) and when creating a REST web service (see Using SAP HANA Information Models in SAP HANA XS). You create a composite provider in SAP BW via the application server, and the process does not require coding. Creating a report in SAP Crystal Reports for Enterprise does not require JavaScript.