1.Exhibit:
Drag and drop question. Drag the items to the proper locations.
Correct Answers:
2.Exhibit:
Drag and drop question. Drag the items to the proper locations.
Correct Answers:
1Y0-A05 220-602 642-515
3.BACKGROUND
A company called SkySoftware,Inc.is a technical content development company ,in which
creating documentation and training materials for kinds of software vendors are their
main business .There are 26 full-time employees at its central office in America ,and
more than 100 part-time writers who work from home all over the world now.
Planned Changes
In order to facilitate remote contract writers submit work by process, the company
intends to implement a new Web service-based solution.
Now ,when the Microsoft Word document arrives ,it is submitted by e-mail ,and stored
in file shares on a file server which is called FP2.Allowing work to be submitted to a
Web service in WordML format and then stored in an xml column in a new database called
SkySoftware_projects is the new solution.
On an existing Web server in the perimeter network,the Web service will be hosted. In
order to access the database server ,it will use impersonation .The following diagram
show a design for the new application solution. (The diagram can also be viewed by
clicking the Case Study Exhibits button.)
3..Problem Statements
After a review of the company??s current security policies, in order to protect
company data from unauthorized access or accidental deletion management wants
improvement of the policies as much as possible.
EXISTING DATA ENVIRONMENT
Databases
There is the SQL Server 2005 database named SkySoftware_biz which will store the
financial and personnel data in the company.
Dbo user has all objects in the database of the SkySoftware_biz.
Database Servers
There are two databases servers in the Seattle office they are a primary server and a
warm standby server. SkySoftware_biz database is stored in the a primary server named
SQL 1,and SkySoftware_biz database is stored in a warm standby server named SQL2,the
user could copy SkySoftware_biz database through log shipping.
The SkySoftware_biz database on SQL2 could be brought online by hand when the f a
server fails, the client application could be set to use the standby server easily
The hardware excels database performance requirements on both servers significantly.
A managed client/server application will process the pros_eware biz database,the
application will use ADO.NET 2.0 to connect to the database server.
EXISTING INFRASTRUCTURE
Network Infrastructure
The network consists of teo is listed below:
3.Directory Services Infrastructure
There is single Active Directory domain named proseware.com in the company network.
The relevant organizational units (OUs), user accounts,and global groups in the domain
are shown below:
70-270 70-272 70-293
3.The contract writers?? accounts are defined in the ContractorAccts OU. In the Users
container ,there are all other user accounts defined.
BUSINESS REQUIREMENTS
General Requirements
There is data for all current projects and archived content from previously completed
projects in the new SkySoftware_projects database.Writers can submit multiple
revisions of a document.While the project is active ,all versions of the document must
be maintained.When the project is completed, the final version will be handed off to
the customer.
Writers and project managers need to use the data in archived projects to get back
documents copies ,which have been handed off to customers.
Availability
It is considered that the cavailability for the SkySoftware_biz database sufficient,
and must not be changed .However, If a server failure or a storage array failure ,the
SkySoftware_projects database must provide a level of availability that ensures that
the database is automatically made fully available as quickly as possible.In
addition,the risk of data loss must be minimal.
There is no new hardware be purchased for the availability solution. When the new
application is implemented FP2, which is used to store project documents now, will be
decommissioned.
A lot of data must be manually inserted into the SkySoftware_biz database by a custom
bulk load operation which requires the database to fail over to the warm standby
server used for log shipping sometimes.
Recoverability
The system use a combination of full, partial, and transaction log lockups to back up
all system and user databases. When recovering from a server failure, a recovery plan
must be created that specifies the steps that are necessary to use these backups.
If the SkySoftware_projects database is destroyed or attacked,the recovery method need
to be optimized to ensure that the filegroups including current project data which are
recovered and made available as quickly as possible.
If an error occurs during the manual bulk load process, the SkySoftware_biz database
must be recoverable to its previous state except the regularly scheduled backups.
TECHNICAL REQUIREMENTS
Security
Only the database administrator can manage logins in the SkySoftware_biz database.
The administrator of the database and managers of the project can manage SQL Server
logins and users for access to the new SkySoftware_projects database.
Employee salary information stored in the SkySoftware_biz database,must be protected
from unauthorized access.
All traffic to and from the HTTP endpoint must be encrypted by using SSL.
If the users are actually required, they are only permitted, because the principle of
least privilege should be applied throughout the solution
Maintainability
The company??s database administrator plans to minimize the counts of separate
database servers in order to minimize management overhead. Multiple servers can be
used on the purpose of providing enhanced availability, but a single server should be
focused on the day-to-day maintenance of the databases whenever possible.
The planned SkySoftware_projects database must use the full recovery model, and must
include three filegroups as shown below:.
Correct Answers:
70-450 70-536 70-646
4.In order to create the highest solution for the four busiest stores, you decide to
use fewer server, you will finish the requirements of the company, Which is the
correct answer?
A: You should create a failover cluster with three cluster nodes, and two virtual
servers on two Windows Clustering groups.
B: You should create a failover cluster with one cluster nodes, and one virtual
servers on one Windows Clustering groups.
C: You should create a database mirror for each of the four store_nnn_rentals
databases, and configure each mirrored database to use a witness server and full
transaction safety.
D: You should set log shipping for the five store_nnn_rentals databases.
Correct Answers: A
5.You are creating the security of the HTTP endpoint of proseware_projects
application.you should identify which login or logins should be idenfied the CONNECT
right on the HTTP endpoint Which is the correct answer?
A: You should add BUILTIN\UsersA local Windows group containing the
PROSEWARE\DomainUsers domain global group
B: You should add ContractWritersA local Windows group containing the
PROSEWARE\Contractors domain global group
C: You should add PMsA local Windows group containing the PROSEWARE\ProjectManagers
domain global group
D: You should add EdsA local Windows group containing the PROSEWARE\Editors domain
global group
Correct Answers: B
6.In order to improve the speed of backups on SQL1, Which is the correct answer?
A: You should set the hard disks as a RAID-0 array, and store the backups on this new
array.
B: You should set the hard disks as a RAID-5 array, and store the backups on this new
array.
C: You should set the hard disks as a RAID-7 array, and store the backups on this new
array.
D: You should set the hard disks as a RAID-6 array, and store the backups on this new
array.
E: you should set the hard disks as a RAID-10 array, and store the backups on this new
array.
Correct Answers: A
7.You are creating a design plan for DBSRV2. How should you organize the placement of
database files?
A: Assign the system databases of all instances to a single separate drive set.
B: Assign each system database to its own drive set.
C: Assign the tempdb databases of all instances to a single separate drive set.
D: Assign the tempdb database of each instance to its own drive set.
Correct Answers: D
8.In order to create a method for identifying the amount of examples which any one SQL
Server 2005 computer will support. Which is the correct answer?
A: You should clarify that each server needs to have one instance for each customer.
B: You should clarify that each server need to every have only one instance.
C: You should clarify that each server needs to have one instance for each database
that is hosted on that server.
D: You should clarify that each server needs to have one instance for each customer
who has one or more databases that are hosted on that server.
Correct Answers: D
9.BACKGROUND
Company Overview
Lively Messenger deliveries throughout the Canada, the partners of the company comes
from all over the world.The company distributes packages of all sizes to both business
and residential addresses.
The main office is wengehua there is some delivery partners which located in Canada
The packages of the whole sizes to both business and residential addresses. Should be
Distributed by The company partners with multiple regional delivery companies
Planned Changes
There are the Specifications which are written. The company wills create a new
application to manage employee benefits for Lively Messenger, in order to authenticate
the users to SQL Server, the users?? Active Directory credentials should be used in
the
Application. There is some of the benefits data which is sensitive. so they will be
viewed
only from the benefits management application??Others information should be bowered by
common visitors
They will use he Promotions database and the Partners database which will be
consolidated onto a single SQL Server computer, their aim is to reduce money,
employees of the regional delivery companies by using SQL Server-authenticated logins
will also use
These databases named Promotions and Partners, for the users, they have not same
permission for both database.
Problem Statements
The Users that bowering time is too for application of the Shipment Tracking using the
Tracking database??Using a large number of global temporary tables should be used for
application of the The Shipment Tracking. database server named SQL1 lead to
performance issues through Application diagnostics.In the master database on
SQL1,Results of running the performance MMC snap-in (PerfMon) displays higher values
for following counters:
. Log Flush Waits/sec
. Log Growths
There is heavy data modification and heavy report generation for the server named SQL5
which includes the main tables concurrently. It will lead to the problem.
EXISTING DATA ENVIRONMENT
Database Servers
There are some The SQL Server computers listed below:
9.Databases
The single SQL Server-authenticated login named OrdersApp which connects the Orders
application and SQL5
There are data encryption, triggers and other technology in the Orders database,you
should encrypted the database master key for the Orders database when you are using
the service master key for SQL5.
After running the application. You should find that the content of the size of tempdb
is big,There is a single data file in this database
The whole historical customer information from the seven most recent completed fiscal
years plus the current year to date has included in the CRM database
EXISTING INFRASTRUCTURE
Network Infrastructure
for its regional delivery partners, they are allowed to get access to browser-based
extranet by the configuration of Lively Messenger WAN ,They are listed below:
9.Server Infrastructure
In the following table, the listed below protocols are enabled for inner connections
to the servers in the perimeter network.
9.BUSINESS REQUIREMENTS
General Requirements
Applications can get access and modify data which is held for the Tracking database.
The regional delivery partners should run the application.
Customer information will last three years in the CRM database for research purposes,
Copies of CRM data monthly should be retained for at least six years, which is
required by the company. Data older than two years will most likely never be needed,
so this auditing requirement is the reason older data should be retained.Auditing
requirement should be made available in its entirety, in a database other than CRM so
that it can be examined separately from the current data when the older data is ever
needed
Availability
There is storage area network (SAN) storage in SQL6??SQL6 supports CRM is a critical
application.SQL6 supports CRM should be available with minimal downtime. SQL7 fits for
Application of the ERP .and is available with minimal downtime.
The listed availability requirements should be identified for SQL6 and SQL7.
1. It will happen for any failover from one SQL Server computer to another
automatically
2. Every servers need to be available at an IP address which is the same before and
after a failover event.
3. SQL Server Agent jobs must resume running ,with no human intervention,after a
failover event.
4 For the other server, the failure of SQL6 or the failure of SQL7 should not cause
performance degradation
5 Special data copy operations or other special processing should not be required
prior to the initiation of the failover
The reports which are running against the Orders data should be able to access
information that is no more than six minutes out of date, and the reports should
display committed information only. Some of these reports take 20 to 25 minutes to
run.
Recoverability
A process need to be designed to recover a copy of the Orders database to another SQL
Server sample at the end of each month. This copy of the Orders database will be used
to run end-of-month accounting reports.
To clarify recovery operations, no more than six recover operations need to be forced
in the event of any type of data failure for the CRM database.
TECHNICAL REQUIREMENTS
Security
credit card information which is stored in the Orders database only exist in the
Orders application .Which is written by the company
Individual visitors should log in to SQL Server by using SQL Server-authenticated
logins in the ExtraNet and Partners databases. The expiration of the Password need to
be enforced on all accounts which could access databases.
All connections from the regional delivery companies are allowed over HTTP and HTTPS,
but not over any other protocols Which is written by the company
Performance
In order to performance well there is the function of the searching and updating data
by using a local copy the Tracking database which synchronizes back to the central
Tracking database.
Interoperability
In the Tracking database, some values need to be populated through reading the Windows
registry on a Microsoft Windows Server 2003 application server named AppServerTest1,
which is located in USA. These values need to be populated once per hour in order to
keep shipment tracking information up-to-date.
Correct Answers:
10.As part of a consolidation strategy, you are planning to migrate several database
servers running SQL Server 2000 to a new server running SQL Server 2005. Which of the
following design strategies is most likely to improve the perfor?mance of the new
server?
A: Move the tempdb database of each instance to its own drive set.
B: Place the tempdb database of each instance on a network attached storage (NAS)
device.
C: Place the tempdb databases of all instances in a single separate drive set.
D: Migrate each database server to the new server as a separate instance.
Correct Answers: A
