Microsoft 070-332 Actual Free Exam Questions & Community Discussion
DRAG DROP
You manage a SharePoint farm.
The sales team would like to evaluate the Microsoft SQL Server 2012 Reporting Services (SSRS) Power View feature.
You need to install Reporting Services for SharePoint to support Power View.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)
You manage a SharePoint farm.
The sales team would like to evaluate the Microsoft SQL Server 2012 Reporting Services (SSRS) Power View feature.
You need to install Reporting Services for SharePoint to support Power View.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)
Correct Answer:
Box 1: Install and start the SSRS SharePoint service.
Box 2: Create an SSRS service application.
Box 3: Active the Power View site collection feature.
Note:
Step 1: Install Reporting Services Report Server in SharePoint mode
Step 2: Register and start the Reporting Services SharePoint Service
Step 3: Create a Reporting Services Service Application
Step 4: Activate the Power View Site Collection Feature.
Reference: Install Reporting Services SharePoint Mode for SharePoint 2013
Box 2: Create an SSRS service application.
Box 3: Active the Power View site collection feature.
Note:
Step 1: Install Reporting Services Report Server in SharePoint mode
Step 2: Register and start the Reporting Services SharePoint Service
Step 3: Create a Reporting Services Service Application
Step 4: Activate the Power View Site Collection Feature.
Reference: Install Reporting Services SharePoint Mode for SharePoint 2013
You are the administrator of your company's SharePoint environment.
The company plans to use Excel Services. A file share is designated to contain all the files that are used by Excel
Services.
You need to configure Excel Services to use the file share.
What should you do?
The company plans to use Excel Services. A file share is designated to contain all the files that are used by Excel
Services.
You need to configure Excel Services to use the file share.
What should you do?
Correct Answer: C
Vote an answer
DRAG DROP
You are a SharePoint developer at Contoso, Ltd. The Contoso finance department is developing a reporting application
that displays financial information from an internal application on the SharePoint Business Intelligence (BI) site.
You must configure a single server SharePoint environment to support Reporting Services. You must validate that the
installation works correctly.
You need to build and test the environment.
Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions
to the answer area and arrange them in the correct order.
You are a SharePoint developer at Contoso, Ltd. The Contoso finance department is developing a reporting application
that displays financial information from an internal application on the SharePoint Business Intelligence (BI) site.
You must configure a single server SharePoint environment to support Reporting Services. You must validate that the
installation works correctly.
You need to build and test the environment.
Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions
to the answer area and arrange them in the correct order.
Correct Answer:
Box 1:
Box 2:
Box 3:
Box 4:
Create business intelligence site
Box 5:
Note:
Reporting Services SharePoint service
Step 1: Install Reporting Services Report Server in SharePoint mode
Step 2: Register and start the Reporting Services SharePoint Service
Step 3: Create a Reporting Services Service Application
Step 4: Activate the Power View Site Collection Feature. Reference:
Step 5: Verify the installation.
In a SharePoint document library, create a basic Reporting Services report that only contains a text box, for example a
ti tle. The report does not contain any data sources or datasets. The goal is to verify you can open Report Builder, build
a basic report, and preview the report.
Reference: Install Reporting Services SharePoint Mode for SharePoint 2013
https://technet.microsoft.com/library/jj219068.aspx
Box 2:
Box 3:
Box 4:
Create business intelligence site
Box 5:
Note:
Reporting Services SharePoint service
Step 1: Install Reporting Services Report Server in SharePoint mode
Step 2: Register and start the Reporting Services SharePoint Service
Step 3: Create a Reporting Services Service Application
Step 4: Activate the Power View Site Collection Feature. Reference:
Step 5: Verify the installation.
In a SharePoint document library, create a basic Reporting Services report that only contains a text box, for example a
ti tle. The report does not contain any data sources or datasets. The goal is to verify you can open Report Builder, build
a basic report, and preview the report.
Reference: Install Reporting Services SharePoint Mode for SharePoint 2013
https://technet.microsoft.com/library/jj219068.aspx
You are a SharePoint administrator at Litware, Inc.
Excel Services is not currently able to load workbooks on the SharePoint site. The Unified Logging Service (ULS) log
contains the following error message:
System.Data.SqICIient.SqIException: Cannot open database "WSS_Content_Portal_Content_Database" requested by
the login. The login failed. Login failed for user 'LITWARE\svcExcelService'.
You need to grant only the minimum necessary permissions to the Excel Services account to ensure that users can
open Excel workbooks from within a browser window.
Which Windows PowerShell cmdlet or cmdlets should you run?
Excel Services is not currently able to load workbooks on the SharePoint site. The Unified Logging Service (ULS) log
contains the following error message:
System.Data.SqICIient.SqIException: Cannot open database "WSS_Content_Portal_Content_Database" requested by
the login. The login failed. Login failed for user 'LITWARE\svcExcelService'.
You need to grant only the minimum necessary permissions to the Excel Services account to ensure that users can
open Excel workbooks from within a browser window.
Which Windows PowerShell cmdlet or cmdlets should you run?
Correct Answer: B
Vote an answer
You are configuring a SharePoint environment to support workflows.
Workflows must meet the following requirements:
Display a visual representation of the workflow.
Display the workflow history.
Provide access to external lists.
You need to implement the necessary shared services.
Which shared services should you implement? (Each correct answer presents part of the solution. Choose two.)
Workflows must meet the following requirements:
Display a visual representation of the workflow.
Display the workflow history.
Provide access to external lists.
You need to implement the necessary shared services.
Which shared services should you implement? (Each correct answer presents part of the solution. Choose two.)
Correct Answer: A,E
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
HOTSPOT
You need to support Windows Phone devices.
Which Site Settings option should you configure? (To answer, select the appropriate option in the answer area.)
You need to support Windows Phone devices.
Which Site Settings option should you configure? (To answer, select the appropriate option in the answer area.)
Correct Answer:
Note:
* Browsing the web on a mobile device is now so common that a SharePoint site must be optimized for readability
and ease of use on smartphones and other mobile devices such as tablets. With device channels in SharePoint 2013,
you can render a single publishing site in multiple ways by using different designs that target different devices.
* A device channel is part of the SharePoint 2013 publishing infrastructure that enables you to render certain site
content, style your content, and even change images-while maintaining the same URL across a pool of different
devices. Compared to the desktop version of the SharePoint site, a mobile rendering can be formatted with a smaller
width, have better navigation with wider touch targets, and show a reduced amount of information for better
usability. You can create a single site, and author and edit the content a single time for all your different mobile
devices. When a user browses a SharePoint site from a mobile device such as a smartphone or tablet, the mobile
browser submits to the site an HTTP GET request that includes a user agent string. This string contains information
about the type of device that is trying to access the site. Based on that device substring, the device browser can be
redirected to a specific master page view.
* Figure 1. Using device channels across different device platforms
You need to configure the BCS model to access data.
What should you do?
What should you do?
Correct Answer: D
Vote an answer
HOTSPOT
You are managing search results in a SharePoint farm.
You need to promote or demote search results that include specific tags.
In the Search service application, what should you configure? (To answer, select the appropriate link in the answer
area.)
You are managing search results in a SharePoint farm.
You need to promote or demote search results that include specific tags.
In the Search service application, what should you configure? (To answer, select the appropriate link in the answer
area.)
Correct Answer:
DRAG DROP
You need to configure authentication for the Tailspin360.TailspinToys.com site.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)
You need to configure authentication for the Tailspin360.TailspinToys.com site.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)
Correct Answer:
Box 1:
Box 2:
Box 3:
Note:
* Step 1:
/ Target Application Type. By default, SharePoint Online uses type Group Restricted.
/ In the Members section, enter a list of users or SharePoint Online groups of users who need to access the target
application. Or, you can use the Browse button to search for the name of a group that you want to map to the Target
Application.
* Step 2:
In the Credential Fields section, enter the Field Names and Field Types for the credentials that are required to access
data in the Target Application. These fields determine how you will map identity in the Secure Store Service. By
default, the Credential Fields list the Windows User Name and Windows Password with matching Field Types (User
Name and Password), and specifies that the password is masked.
* Step 3:
If you are using Excel Services, use the procedures in this section to complete the necessary configuration steps.
If the Unattended Service Account has not already been configured for Excel Services, follow these steps to configure
it.
To configure the Unattended Service Account
On the SharePoint Central Administration home page, under Application Management, click Manage Service
Applications.
Click the Excel Services service application.
Click Global Settings.
In the External Data section, choose the Use an existing Unattended Service Account option, and then type the name
of the target application that you created for the Unattended Service Account in the Target Application ID text box.
Click OK.
* From scenario:
/ The site must be accessible only to members of the Sales team.
/ The salesAccess shared domain account has permissions to read data from the database.
/ Excel workbooks published to a document library app must be opened in a browser. Excel workbooks in other
locations must open in Excel.
* The Secure Store Service is designed to create a background mapping between a group of users in SharePoint, and a
single user known to the external data system. When the Secure Store Service is properly configured, the following
occurs:
* A user authenticates through Internet Information Services (the web server technology underlying SharePoint
technologies) to SharePoint Online via valid credentials.
* Inside SharePoint Online, the Secure Store Service uses mapped credentials known to the external business
application to render any necessary external data on the site for the authenticated user.
Reference: Create or edit a Secure Store Target Application
Box 2:
Box 3:
Note:
* Step 1:
/ Target Application Type. By default, SharePoint Online uses type Group Restricted.
/ In the Members section, enter a list of users or SharePoint Online groups of users who need to access the target
application. Or, you can use the Browse button to search for the name of a group that you want to map to the Target
Application.
* Step 2:
In the Credential Fields section, enter the Field Names and Field Types for the credentials that are required to access
data in the Target Application. These fields determine how you will map identity in the Secure Store Service. By
default, the Credential Fields list the Windows User Name and Windows Password with matching Field Types (User
Name and Password), and specifies that the password is masked.
* Step 3:
If you are using Excel Services, use the procedures in this section to complete the necessary configuration steps.
If the Unattended Service Account has not already been configured for Excel Services, follow these steps to configure
it.
To configure the Unattended Service Account
On the SharePoint Central Administration home page, under Application Management, click Manage Service
Applications.
Click the Excel Services service application.
Click Global Settings.
In the External Data section, choose the Use an existing Unattended Service Account option, and then type the name
of the target application that you created for the Unattended Service Account in the Target Application ID text box.
Click OK.
* From scenario:
/ The site must be accessible only to members of the Sales team.
/ The salesAccess shared domain account has permissions to read data from the database.
/ Excel workbooks published to a document library app must be opened in a browser. Excel workbooks in other
locations must open in Excel.
* The Secure Store Service is designed to create a background mapping between a group of users in SharePoint, and a
single user known to the external data system. When the Secure Store Service is properly configured, the following
occurs:
* A user authenticates through Internet Information Services (the web server technology underlying SharePoint
technologies) to SharePoint Online via valid credentials.
* Inside SharePoint Online, the Secure Store Service uses mapped credentials known to the external business
application to render any necessary external data on the site for the authenticated user.
Reference: Create or edit a Secure Store Target Application
You are the administrator of a SharePoint environment. The SharePoint environment uses Azure Infrastructure
Services for disaster recovery.
You must create a disaster recovery plan that includes warm failover to Azure Infrastructure Services.
You need to identify which service databases must be restored.
Which two service databases must you restore? Each correct answer presents part of the solution.
Services for disaster recovery.
You must create a disaster recovery plan that includes warm failover to Azure Infrastructure Services.
You need to identify which service databases must be restored.
Which two service databases must you restore? Each correct answer presents part of the solution.
Correct Answer: B,C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
===========================
Case Study: 5
Contoso Ltd
Background
A company named Contoso, Ltd. has offices in Seattle and Toronto. Each office has a data center and a
region-specific site in a single Active Directory Domain Services (AD DS) domain named contoso.com. The
database servers run Microsoft SQL Server 2008 R2. Database servers are installed in each data center and
are members of the region-specific sites. The WAN connection between the data centers is a dedicated T3
connection.
Existing Corporate Farm
Contoso has a SharePoint farm named HQ-SP10. The SharePoint servers in the farm run SharePoint Server
2010 on Windows Server 2008 R2.
HQ-SP10 hosts many web applications that require unique service accounts. A SharePoint 2010 web
application named WebApp1 is located at https://webapp1.contoso.com. WebApp1 references a custom
knowledge base module in HQ-SP10 and the content is stored in the SharePoint database HQDB. Employees
authenticate to WebApp1 by using classic mode authentication.
Users in both offices make frequent updates to SharePoint content. Administrators make only minimal
changes to the SharePoint farm settings and web applications.
Existing Product Support Farm
The product support department hosts a SharePoint farm named DEPT-SP13. The SharePoint servers in the
farm run SharePoint Server 2013 and are members of a domain named PrdSupport.contoso.com.
DEPT-SP13 hosts two service applications:
A built-in service application provides access to a business data model
*
connected to the company's data warehouse.
A custom service application named SvcApp1 provides access to data in a
*
legacy system.
Users in the product support department access the service applications by using a local web application
named WebApp2. WebApp2 is located at webapp2.contoso.com and is stored in the SharePoint database
DEPTDB. Users in other departments access the service applications by using WebApp1.
Technical Challenges
You are upgrading HQ-SP10 and the web applications hosted in the farm to a new SharePoint Server 2013
farm named HQ-SP13.
When upgrading the content database to SharePoint Server 2013, you receive the following error message:
Business Requirements
The SharePoint 2010 environment must meet the following business requirements:
HQ-SP10 must provide read-only access to users during the migration.
*
All customizations in HQ-SP10 must be migrated to HQ-SP13.
*
The SharePoint 2013 environment must meet the following business requirements:
HQ-SP13 and the web applications must remain available if one of the
*
SharePoint servers or database servers is offline.
Users' documents stored in HQ-SP13 must be available if all the servers in a
*
region are offline.
Shared resources in SvcApp1 must be available to other SharePoint farms in
*
the company.
All customizations in HQ-SP13 must be verified after the farm upgrade.
*
Periodically, you must provide an offline copy of site content from HQ-SP13
*
to the legal department.
Technical Requirements
You have the following technical requirements:
All users must be able to access the business data model for the company data warehouse.
Backup administrators must be able to restore HQ-SP13, WebApp1, and SvcApp1 separately.
The SharePoint 2013 environment for HQ-SP13 must meet the following technical requirements:
The database servers must run Microsoft SQL Server 2012.
*
The databases must belong to a SQL Server AlwaysOn Availability Group
*
and use the WAN connection for database replication between the sites.
The database servers must be configured with the Enable Contained
*
Databases property.
Application pools for the web applications require unique service accounts.
*
After the upgrade, users in the accounting department who connect to
*
WebApp1 must be able to access shared resources in SvcApp1.
===========================
Before you upgrade the web application, you need to validate that customizations will continue to function.
Which Windows PowerShell cmdlet should you run?
Case Study: 5
Contoso Ltd
Background
A company named Contoso, Ltd. has offices in Seattle and Toronto. Each office has a data center and a
region-specific site in a single Active Directory Domain Services (AD DS) domain named contoso.com. The
database servers run Microsoft SQL Server 2008 R2. Database servers are installed in each data center and
are members of the region-specific sites. The WAN connection between the data centers is a dedicated T3
connection.
Existing Corporate Farm
Contoso has a SharePoint farm named HQ-SP10. The SharePoint servers in the farm run SharePoint Server
2010 on Windows Server 2008 R2.
HQ-SP10 hosts many web applications that require unique service accounts. A SharePoint 2010 web
application named WebApp1 is located at https://webapp1.contoso.com. WebApp1 references a custom
knowledge base module in HQ-SP10 and the content is stored in the SharePoint database HQDB. Employees
authenticate to WebApp1 by using classic mode authentication.
Users in both offices make frequent updates to SharePoint content. Administrators make only minimal
changes to the SharePoint farm settings and web applications.
Existing Product Support Farm
The product support department hosts a SharePoint farm named DEPT-SP13. The SharePoint servers in the
farm run SharePoint Server 2013 and are members of a domain named PrdSupport.contoso.com.
DEPT-SP13 hosts two service applications:
A built-in service application provides access to a business data model
*
connected to the company's data warehouse.
A custom service application named SvcApp1 provides access to data in a
*
legacy system.
Users in the product support department access the service applications by using a local web application
named WebApp2. WebApp2 is located at webapp2.contoso.com and is stored in the SharePoint database
DEPTDB. Users in other departments access the service applications by using WebApp1.
Technical Challenges
You are upgrading HQ-SP10 and the web applications hosted in the farm to a new SharePoint Server 2013
farm named HQ-SP13.
When upgrading the content database to SharePoint Server 2013, you receive the following error message:
Business Requirements
The SharePoint 2010 environment must meet the following business requirements:
HQ-SP10 must provide read-only access to users during the migration.
*
All customizations in HQ-SP10 must be migrated to HQ-SP13.
*
The SharePoint 2013 environment must meet the following business requirements:
HQ-SP13 and the web applications must remain available if one of the
*
SharePoint servers or database servers is offline.
Users' documents stored in HQ-SP13 must be available if all the servers in a
*
region are offline.
Shared resources in SvcApp1 must be available to other SharePoint farms in
*
the company.
All customizations in HQ-SP13 must be verified after the farm upgrade.
*
Periodically, you must provide an offline copy of site content from HQ-SP13
*
to the legal department.
Technical Requirements
You have the following technical requirements:
All users must be able to access the business data model for the company data warehouse.
Backup administrators must be able to restore HQ-SP13, WebApp1, and SvcApp1 separately.
The SharePoint 2013 environment for HQ-SP13 must meet the following technical requirements:
The database servers must run Microsoft SQL Server 2012.
*
The databases must belong to a SQL Server AlwaysOn Availability Group
*
and use the WAN connection for database replication between the sites.
The database servers must be configured with the Enable Contained
*
Databases property.
Application pools for the web applications require unique service accounts.
*
After the upgrade, users in the accounting department who connect to
*
WebApp1 must be able to access shared resources in SvcApp1.
===========================
Before you upgrade the web application, you need to validate that customizations will continue to function.
Which Windows PowerShell cmdlet should you run?
Correct Answer: D
Vote an answer
0
0
0
10