Microsoft-PRO Designing Database Solutions by Using Microsoft SQL Server 2005 Set 4

Question - 15 Maximum mark : - 28

Home
All Exams
Microsoft-PRO Designing Database Solutions by Using Microsoft SQL Server 2005 Online Practice Exams
Microsoft-PRO Designing Database Solutions by Using Microsoft SQL Server 2005 Set 4

You need to ensure that branch office database administrators cannot view the source code of database objects. What should you do?

Specify that the database permissions on database objects must deny all access to the administrators. ✘ Specify that all database objects must be stored in a secondary database file. Configure NTFS permissionson this file to deny access to the administrators. ✘ Specify that all database objects must be encrypted. ✘ Specify that all database objects must be written in managed code. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to minimize the size of the Notification Services database. What should you do?

Specify a one-day retention period for alerts and notifications in the Notification Services database. ✘ Specify that the Notification Services database must receive a full backup once each week. ✘ For the Notification Services database, specify a recovery model that truncates transaction logs on a regularbasis. ✘ Design a maintenance plan for the Notification Services database that shrinks the database monthly. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that the testing of the SSIS packages fulfills the business requirements. What should you do?

Specify that packages must be run, using standard sample data, on a test server. ✘ Specify that packages must be run on the production database. ✘ Specify that the packages must be run, using actual customer data, on a test server that contains a copy ofthe production database. ✘ Specify that packages must be run on the production database after a full backup of the productiondatabase is made. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that SSIS packages that are used to import new customer data do not create unacceptable performance. What should you do?

While packages are running, modify the thread priority of the SQL Server Agent service to Low. ✘ While packages are running, modify the thread priority of the SQL Server service to Low. ✘ Specify that packages must be designed to use only a single thread of operation. ✘ Schedule packages to run outside of normal office hours. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to implement the ComplexCalc column in the Results table while maintaining the best possible performance. What should you do?

Specify that a managed function must be created to call the COM component. Implement the ComplexCalc column as a computed column that calls the function. ✘ Deploy the COM component together with all client applications. ✘ Specify that a managed code trigger must be created to update the ComplexCalc column. Design thetrigger to call the COM component. ✘ Create a CLR user-defined data type to store the ComplexCalc column. Implement the type by usingmanual serialization and call the COM component in the types Read method. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?

Execute unit test scripts for each stored procedure in each database. ✘ Execute the stored procedures in the SQL Server Management Studio debugger, and verify the results. ✘ Set the database compatibility level on the database servers to 80. ✘ Execute the application user interface test scripts to verify proper operation. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design the indexing strategy for the articles that are submitted in XML format by authors. Which action or actions should you perform? (Choose all that apply.)

Create a VALUE secondary XML index on the xml data column. Create a PATH secondary XML index on the xml data column. Create a PROPERTY secondary XML index on the xml data column. Create a nonclustered index and add the xml data column by using INCLUDE. Create a primary XML index on the xml data column.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that the testing of the SSIS packages fulfills the 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.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You need to design the indexing strategy for the articles that are submitted in XML format by authors. Which action or actions should you perform? (Choose all that apply.)

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 Database Solutions by Using Microsoft SQL Server 2005 Set 4

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