nerdexam
Microsoft

70-466 · Question #159

You have a SQL Server Analysis Services (SSAS) multidimensional cube. You need to enable users to view the cube data from an iPad. What should you do?

The correct answer is C. Configure Excel Services in SharePoint.. Excel Services in SharePoint renders SSAS-connected workbooks in a browser, making cube data accessible on iPads without requiring any installed client software.

Configure and maintain an analysis services database

Question

You have a SQL Server Analysis Services (SSAS) multidimensional cube. You need to enable users to view the cube data from an iPad. What should you do?

Options

  • AInstall SQL Server 2012 Reporting Services (SSRS) in SharePoint integrated mode.
  • BDevelop a custom web application that connects to the cube.
  • CConfigure Excel Services in SharePoint.
  • DInstall SQL Server 2012 Reporting Services (SSRS) in native mode.

How the community answered

(31 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    87% (27)
  • D
    3% (1)

Why each option

Excel Services in SharePoint renders SSAS-connected workbooks in a browser, making cube data accessible on iPads without requiring any installed client software.

AInstall SQL Server 2012 Reporting Services (SSRS) in SharePoint integrated mode.

SSRS in SharePoint integrated mode delivers paginated reports but does not provide the interactive self-service cube exploration that Excel Services offers for mobile users.

BDevelop a custom web application that connects to the cube.

A custom web application could technically work but is an unnecessary development investment when Excel Services already provides this capability natively.

CConfigure Excel Services in SharePoint.Correct

Excel Services in SharePoint publishes Excel workbooks connected to SSAS cubes as interactive browser-based pivot tables and charts, accessible via Safari or any modern mobile browser on an iPad. It acts as a server-side rendering intermediary that translates SSAS cube data into HTML-based output suitable for iOS devices. This approach requires no client-side installation and provides native interactive cube browsing for mobile users.

DInstall SQL Server 2012 Reporting Services (SSRS) in native mode.

SSRS in native mode delivers reports via a standalone web portal but lacks the interactive cube pivoting and filtering capabilities that Excel Services provides.

Concept tested: SSAS cube mobile access via SharePoint Excel Services

Source: https://learn.microsoft.com/en-us/sharepoint/administration/overview-of-excel-services-in-sharepoint-server-2013

Topics

#SSAS#mobile access#Excel Services#SharePoint

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice