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

Question - 15 Maximum mark : - 29

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 3

You need to design a method for archiving completedCjob data. Your solution must fulfill all business and technical requirements. What should you do?

On a weekly basis, run a stored procedure that deletes completed-job data from the tables that contain active-job data. ✘ Design a partitioned table that partitions completed-job data from active-job data. ✘ Design a SQL Server Agent job that deletes completed-job data from the tables that contain active-job data.Schedule the job to run weekly. ✘ Design a SQL Server Integration Services (SSIS) package that deletes completed-job data from the tablesthat contain active-job data. Schedule the package to run weekly. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a method for making sales reports available to users, in compliance with the business requirements. Your solution must require the minimum amount of development time. What should you do?

Generate the reports and send them in e-mail messages from the SQL Server 2005 production database server. ✘ Make the reports accessible by means of a SQL Server Reporting Services (SSRS) Web site. ✘ Create the reports as static HTML files that are hosted on a Web site. ✘ Make the reports available by means of an ASP.NET Web site. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a method for storing the incoming XML-formatted data about new videos. What should you do?

Specify individual columns of the appropriate data type to store the video titles and descriptions, and store actors in a separate table with a many-to-many relationship to the videos. Shred the XML data into the individual columns. ✘ Store the XML data in independent text files on the database servers hard disk. Specify a varchar column tohold the name of the text file for each video. ✘ Specify an nvarchar(max) column to store the raw XML data. ✘ Specify an XML data column to store the data. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that employee shift data is handled properly. Your solution must require the minimum amount of development time. What should you do?

Design a foreign key constraint on the employee shifts table so that only values from the employees table can be used. ✘ Design cascading referential integrity constraints between the employees table and the employee shiftstable. ✘ Design an AFTER DELETE trigger on the employees table that deletes corresponding rows from theemployee shifts table. ✘ Design an AFTER DELETE trigger on the employee shifts table that deletes corresponding rows from theemployees table. ✔

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 rental transactions table does not contain membership numbers that are not currently issued to a customer. You also need to make sure that the table design conforms to third normal form (3NF). What should you do?

Design a check constraint on the MembershipNumber column in the rental transactions table. Design the constraint to accept only data that has a valid format. ✘ Design a check constraint on the MembershipNumber column in the rental transactions table. Design theconstraint to verify that the membership number exists in the customers table. ✘ Design a referential integrity relationship between the MembershipNumber column in the rental transactionstable and the MembershipNumber column in the customers table. ✘ Remove the MembershipNumber column from the rental transactions table. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design the method for providing monthly sales reports. What should you do?

Design a SQL Server Integration Services (SSIS) package that creates a new table on the same server and copies the data for the sales report to that table. ✘ Design a SQL Server Reporting Services (SSRS) report that runs on the same SQL Server instance as theproduction database. ✘ At the end of each month, back up the database and restore it on a separate database server, and generatereports on that computer. ✘ At the end of each month, create a database snapshot of the database. Generate reports from thatsnapshot. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a method for the Southridge@Home application to retrieve data. What should you do?

Design a Web service that provides the necessary data. Host the Web service on the database server. ✘ Design a Web service that provides the necessary data. Host the Web service on an Internet Web server. ✘ Host the application on an Internet Web server and design it to submit queries to SQL Server by usingHTTP. ✘ Host the application on an Internet Web server and design it to submit XPath queries to SQL Server. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to provide a method for optimizing the most common database queries. What should you do?

Create an index on the primary key column of the customers table, and on the primary key column of the video titles table. ✘ Create covering indexes for copy availability and customer account balance. ✘ Create a SQL Server Agent job that recalculates database statistics each night. ✘ Create a SQL Server Agent job that rebuilds all indexes weekly, with a 50-percent fill factor. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are designing a performance monitoring plan for the database that supports APP1. You need to monitor only necessary indicators. Which indicator or indicators should you include in the baseline? (Choose all that apply.)

response times for frequently used queries database backup and restore completion times disk I/O CPU utilization network packet size

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You receive updates to data on potential survey participants. You need to create a stored procedure to synchronize the updated information with the XML representation of the data on potential survey participants that is stored in the database. What should you do?

Update the XML representation by using the OPENXML statement. ✘ Update the XML representation by using the modify() method. ✘ Update the XML representation by using the nodes() method. ✘ Update the XML representation by using the value() method. ✔

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 3

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