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

Question - 60 Maximum mark : - 117

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

You need to ensure that the performance of the Research_Aggr view is optimized. What should you do?

Specify that access to the view must be made only through a stored procedure. ✘ Specify that indexes must be created on the views Data1 and Data2 columns. ✘ Specify that indexes must be created on the base table columns that contain the data that is used by thecalculations in the Data1 and Data2 columns. ✘ Specify that indexes that are present on the view must be rebuilt each month, with a fill factor of 50 percent. ✔

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 process for identifying when the server hardware is approaching full utilization fulfills the business requirements. What should you do?

Use SQL Trace to log the activity on the servers to a log file. ✘ Use Performance Logs and Alerts to log the activity on the servers to a log file. ✘ Instruct the end users to report when application response time decreases. ✘ Check the Windows event log for errors or warnings that are produced due to high utilization. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Currently the ComplexCalc column in the Results table is updated by a Transact-SQL trigger that calls the COM component by using the sp_OA* extended stored procedures. You want to migrate this process to a solution that does not use sp_OA* and that requires the minimum amount of development and testing time. What should you do?

Write a new extended stored procedure in Microsoft Visual C++ to call the COM component. Write a Transact-SQL trigger that calls this extended stored procedure to update the ComplexCalc column. ✘ Rewrite the COM component in a managed code language. Write a managed trigger to call the newmanaged component to update the ComplexCalc column. ✘ Create a stored procedure in a managed code language to call the COM component and insert the data intothe ComplexCalc column or update the ComplexCalc column. ✘ Create a user-defined function in a managed code language to call the COM component. Write a Transact-SQL trigger to call the new managed function to update the ComplexCalc 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 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 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 create a performance testing plan to ensure that the new application solutions overhead is within allowable limits. What should you do?

Measure pagefile utilization before and after installing the new application solution. ✘ Measure end-user response times in the existing solution and in the new solution. ✘ Measure the response times of key queries in the existing solution and in the new solution. ✘ Measure CPU counters and disk performance counters before and after installing the new applicationsolution. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that on-demand reports fulfill the business requirements. What should you do?

Design the reports to use a matrix. ✘ Design the reports to use a list. ✘ Design the reports to use a table without a grouping level. ✘ Design the reports to use a table with a grouping level. ✔

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 access by government auditors to auditing information will fulfill all business and technical requirements. What should you do?

Replicate auditing information to a stand-alone SQL Server 2005 database server that is on the outside of the company firewall. Grant the auditors select permissions for the replicated audit information. ✘ Replicate auditing information to a stand-alone SQL Server 2005 server that is on the inside of the companyfirewall. Grant the auditors select permission for the replicated audit information. ✘ Use SQL Server Authentication for the auditors. Create a database role named GrantAudit that has selectpermissions for all audit tables. Assign this role to the auditors.Ensure that no other user has select permission for audit tables. ✘ Use SQL Server Authentication for the auditors. Grant the auditors select permissions for all audit tables.Deny select permission on all audit tables to public. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You need to design a process by which customers can access import product status over the Internet. Your solution must fulfill all business and technical requirements. What should you do?

Design a SQL Server Reporting Services (SSRS) solution that sends import product status reports to customers in e-mail messages. ✘ Design a parameterized stored procedure that provides import product status information to customers. ✘ Design a Web service that provides import product status information to customers. ✘ Design a Notification Services solution that sends customers an e-mail message when import productstatus is updated. ✔

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

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