Microsoft-PRO Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Set 5

Question - 10 Maximum mark : - 19

Home
All Exams
Microsoft-PRO Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Online Practice Exams
Microsoft-PRO Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Set 5

You need to migrate the DeliveryVans, AirlinePreferences, and SeasonalContractors databases into the data center. What should you do?

Install a separate instance of SQL Server 2005 for each of the databases on a single server. ✘ Create a SQL Server database for each of the databases in a single instance of SQL Server 2005. ✘ Import the data from each of the databases into a single database in an instance of SQL Server 2005. ✘ Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of thedatabases. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that customers will be able to administer their databases and other SQL Server settings. What should you do for each customer?

Place the appropriate database user accounts into the customer db_datareader and db_datawriter fixed database roles. ✘ For each customer, place the appropriate logins into the sysadmin fixed server role. ✘ For each customer, create a local Windows user account on the appropriate SQL Server computer andplace the account into the local Administrators group. ✘ For each customer, create a local Windows user account on the appropriate SQL Server computer andplace the account into the local Server Operators group. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a high-availability hosting service solution for Fabrikam, Inc., that fulfills their business requirements. What should you do?

Design a hosting service option that replicates each of their customer databases to a subscription SQL Server computer. Use the same subscription server for all highly available customer databases. ✘ Design a hosting service option that provides redundant power supplies, network adapters, and cooling fansin the server that hosts the customer databases. ✘ Design a hosting service option that places the customer databases on a RAID-1 volume. ✘ Design a hosting service option that places the customer databases on a RAID-5 volume. ✔ Design a hosting service option that places the customer databases in a clustered instance of SQL Server2005. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to make recommendations or design changes to ensure that patient information is protected while it is stored in the database. What should you do?

Recommend that customers should configure column-level encryption for all columns that contain patient information. ✘ Specify that a server administrator must encrypt all database files by using the Windows Encrypting FileSystem (EFS). ✘ Recommend that all customer connections to SQL Server computers should be made by means of anIPSec tunnel. ✘ Specify that all SQL Server computers must contain IPSec-enabled network adapters. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to make recommendations to help customers who use Web applications mitigate potential SQL Server security risks. What should you do?

Recommend that data on the customers SQL Server computer should be encrypted. ✘ Recommend that the customers SQL Server computer should be placed behind a hardware firewall. ✘ Recommend that the customers Web server should be placed behind a firewall. ✘ Recommend that the customers Web application should access data only through stored procedures. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to make recommendations for maximizing the performance of queries based on patient names from the Patient table. What should you do?

Recommend that an index should be created on the patient name and ID columns, and that the index fill factors should be set at 10%. ✘ Recommend that a nonclustered index should be created on only the patient name column. ✘ Recommend that a clustered index should be created on the patient name column. ✘ Recommend that a nonclustered index, which uses the INCLUDE clause for all columns, should be createdon the patient name column. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to make recommendations to help customers who use Web applications mitigate potential SQL Server security risks. What should you do?

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a hosting service option for customers who require periodic delivery of database tape backups. How should you design the hosting service option?

Create a full copy-only database backup to tape on a regular basis. ✘ Perform a backup of the full-text catalog to tape on a regular basis. ✘ Back up all customer transaction log files every hour. ✘ Create differential database backups to tape on a regular basis. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a high-availability hosting service solution for Fabrikam, Inc., that fulfills their business requirements. What should you do?

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You need to make recommendations to help customers who use Web applications mitigate potential SQL Server security risks. What should you do?

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Microsoft-PRO Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Set 5

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner