HOTSPOT
###BeginCaseStudy###
Case Study: 1
Tailspin Toys
Background
Tailspin Toys is a multinational company that manufactures toys. Tailspin Toys has offices in
five regions worldwide. The company sells toys at various retail stores. The company also
sells toys directly to consumers through a web site.
The company has the following departments:
• Sales
• Distribution
• Manufacturing
Each department has an office in each region.
The fiscal calendar of Tailspin Toys runs from June to May.
The network contains a server farm that has Microsoft SharePoint Server 2013 installed.
Existing Environment
Current Database Environment
Each department uses SharePoint team sites for internal collaboration.
All manufacturing information is stored in a relational database named Manufacturing. All
sales information is stored in a relational database named Sales.
Tailspin Toys deploys SQL Server Analysis Services (SSAS) and configures SSAS to use
tabular models. SSAS will be used for all sales reports.
Tailspin Toys deploys a SQL Server Reporting Services (SSRS) instance in SharePoint
mode.
Sales Database
A database named Sales contains two tables named FactSales and DimProduct. FactSales
contains the following columns:
• SalesID
• Total Due
• OrderDate
DimProduct contains the following columns:
• ProductID
• ProductName
• ProductCategory
• ProductSubcategory
The Sales database contains information about the products. Most of the products have a
category and a subcategory. Certain products only have a category.
A sample from DimProduct is shown in the following table.
Requirements
Security Requirements
Tailspin Toys identifies the following security requirement:
• Sales department users must be allowed to view the sales transactions from their
region only.
• Sales department users must be able to view the contents of the manufacturing
reports.
• Manufacturing department users must be able to create new manufacturing reports.
• Third-party and custom solutions must NOT be deployed to the reporting server.
• Sales department users must NOT be able to create new manufacturing reports.
Planned Reporting Implementation
The manufacturing department plans to use the SSRS instance for its reports. The
manufacturing department also plans to make its reports accessible from SharePoint. All
manufacturing reports will use an existing database named Manufacturing.
Reporting Requirements
Tailspin Toys identifies the following reporting requirements:
• All reports must contain the company logo and a header that contains the date and the
time that the report was executed.
• All reports must be created by using the SQL Server Data Tools.
Manufacturing report
You plan to create a report named Manufacturinglssues.rdl. The report has the following
requirements:
• Manufacturing department managers must be able to view product issues by product
type, manufacturing plant location, and error type.
• The manufacturing department managers must be able to change views by choosing
options from drop-down lists.
Sales reports
You plan to create a sales report named RegionalSales.rdl. The report has the following
requirements:
• Users must be able to view the report by using a web browser. By default,
subcategories and product details must be hidden when using the browser.
• Users must be able to subscribe to receive the report by email. The report must be sent
by email as a PDF attachment.
You plan to create a quarterly sales report named QuarterSales.rdl. The report must display
sales data by fiscal quarter.
Technical Requirements
Tailspin Toys identifies the following technical requirements:
• Products in the DimProduct table that do NOT have a subcategory must use the
category value as the subcategory value.
• SSRS must NOT connect to databases more frequently than once every 30 minutes.
• Sales department users must be able to use Microsoft Excel to browse tabular data.
###EndCaseStudy###
You create a new SharePoint site to store reports for the manufacturing department.
You need to recommend a solution to meet the security requirements for the sales
department users and the manufacturing department users.
What should you recommend? To answer, select the appropriate group for the sales
department users and the manufacturing department users in the answer area.
Answer: 
Members
Members
0
0
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00913.jpg
0
0
For sales -Restricted Readers.
“Sales department users must NOT be able to create new manufacturing reports.”
0
0
By the way, can anyone explain me the groups in the question.
These groups we have in sp 2013 sp1:
Full Control – Has full control.
Design – Can view, add, update, delete, approve, and customize.
Edit – Can add, edit and delete lists; can view, add, update and delete list items and documents.
Contribute – Can view, add, update, and delete list items and documents.
Read – Can view pages and list items and download documents.
Approve – Can edit and approve pages, list items, and documents.
Manage Hierarchy – Can create sites and edit pages, list items, and documents.
Restricted Read – Can view pages and documents, but cannot view historical versions or user permissions.
Restricted Interfaces for Translation – Can open lists and folders, and use remote interfaces.
View Only – Can view pages, list items, and documents. Document types with server-side file handlers can be viewed in the browser but not downloaded.
So from where the owner,members groups?
0
0
Ok got this.
The members group have contribute permissions by default.(Man. users)
The restricted readers have restricted read permissions by default.(Sales users)
0
0
Sales – Restricted users
Manufacturing – Members
Members description – https://technet.microsoft.com/en-us/library/bb326284(v=sql.105).aspx
Restricted users – https://support.office.com/en-us/article/Default-SharePoint-groups-in-SharePoint-Server-50855943-c151-42bf-b6ea-07f2bb366ecc
and restricted users trick – https://briankgough.wordpress.com/2009/11/16/sharing-documents-with-restricted-read/
0
0
+1
0
0
One of our visitors recently proposed the following website.
0
0
here are some hyperlinks to websites that we link to due to the fact we believe they’re worth visiting
0
0
Here are a number of the web pages we recommend for our visitors
0
0
that is the finish of this write-up. Here youll find some web-sites that we think youll appreciate, just click the hyperlinks over
0
0
The information mentioned in the post are some of the very best accessible
0
0
please go to the websites we follow, which includes this a single, because it represents our picks in the web
0
0
Here is a superb Blog You may Find Interesting that we encourage you to visit.
0
0
below youll locate the link to some internet sites that we think you must visit
0
0
always a significant fan of linking to bloggers that I adore but dont get a whole lot of link appreciate from
0
0
the time to read or go to the subject material or web-sites we’ve linked to beneath the
0
0
here are some hyperlinks to web pages that we link to for the reason that we feel they are really worth visiting
0
0