Microsoft Sharepoint 2013 SharePoint 2013 Business Intelligence and Workflows 1 — Questions and Answers
Question 1: What is the new workflow engine introduced in SharePoint 2013 that replaces the Windows Workflow Foundation engine?
- SharePoint Designer Workflow 2.0
- Workflow Manager 1.0 with Azure Workflow (Correct answer)
- Microsoft Flow integration
- SharePoint Workflow Service
Correct answer: Workflow Manager 1.0 with Azure Workflow
SharePoint 2013 introduced Workflow Manager 1.0, an external Azure-based workflow engine that replaces the legacy Windows Workflow Foundation engine used in SharePoint 2010.
Question 2: Which SharePoint 2013 BI feature allows users to create and publish interactive dashboards from Excel workbooks?
- Excel Services (Correct answer)
- PerformancePoint Services
- Power View for SharePoint
- SQL Server Reporting Services
Correct answer: Excel Services
Excel Services in SharePoint 2013 allows users to publish Excel workbooks to SharePoint, enabling browser-based interactive viewing and data analysis without a local Excel installation.
Question 3: In SharePoint 2013, what is PerformancePoint Services used for?
- Monitoring SharePoint server performance
- Creating KPI scorecards, dashboards, and analytical reports for business intelligence (Correct answer)
- Analyzing search performance metrics
- Measuring page load performance for sites
Correct answer: Creating KPI scorecards, dashboards, and analytical reports for business intelligence
PerformancePoint Services in SharePoint 2013 is a BI service application that provides tools for building KPI scorecards, dashboards, analytical charts, and reports connected to data sources.
Question 4: What SharePoint 2013 workflow feature allows workflows to call external web services?
- Web Service Activity
- Call HTTP Web Service action (Correct answer)
- External Service Connector
- REST Workflow Bridge
Correct answer: Call HTTP Web Service action
SharePoint 2013 Workflow Manager includes a 'Call HTTP Web Service' action that enables workflows to make REST API calls to external web services during execution.
Question 5: In SharePoint 2013, which tool is primarily used by business users to create workflows without writing code?
- Visual Studio 2012
- SharePoint Designer 2013 (Correct answer)
- InfoPath Designer 2013
- Visio 2013
Correct answer: SharePoint Designer 2013
SharePoint Designer 2013 is the primary no-code tool for business users and IT pros to create list workflows, site workflows, and reusable workflows in SharePoint 2013.
Question 6: What is the purpose of Visio 2013's integration with SharePoint Designer 2013 workflows?
- Generate Visio diagrams from SharePoint site maps
- Allow workflows designed in Visio to be exported to SharePoint Designer for implementation (Correct answer)
- Visualize SharePoint farm topology in Visio
- Create org charts from the User Profile Service
Correct answer: Allow workflows designed in Visio to be exported to SharePoint Designer for implementation
Visio 2013 can be used to visually design workflow diagrams that can be exported to SharePoint Designer 2013, where they are converted into functional workflows.
What is the new workflow engine introduced in SharePoint 2013 that replaces the Windows Workflow Foundation engine?