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

Question - 13 Maximum mark : - 22

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 5

You need to design a reporting solution so that customers can view weekly activity reports. Your solution must fulfill all business and technical requirements. What should you do?

Design a view that provides weekly activity data. Provide customers with a VPN connection to access the database server, and provide customers with a client application that executes the view and displays the results. ✘ Design an ASP.NET Web site that queries the database server to produce weekly activity reports. Place theWeb site on the Internet. ✘ Specify that SQL Server Reporting Services (SSRS) must be used to create weekly activity reports that aresent to each customer by e-mail. ✘ Specify that a SQL Server Reporting Services (SSRS) Web site must be placed in an extranet, and thatcustomers must be given access to that extranet. ✔ Design a view that provides weekly activity data. Instruct customers to query the view by submitting HTTP-based queries to a SQL Server computer. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that changes to assignments can be audited. Your solution must fulfill all business and technical requirements. What should you do?

Ensure that users have no direct access to the table that contains the assignments. ✘ Design DDL triggers for the table that contains the assignments. Design the triggers to write auditinginformation to a separate table. ✘ Design DML triggers for the table that contains the assignments. Design the triggers to write auditinginformation to a separate table. ✘ Design an updatable view that will be used for all changes to the table that contains the assignments. ✔

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 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 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.

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.

You need to provide analyst reporting capabilities that fulfill the business requirements. What should you do?

Add a Report Viewer control to APP3. ✘ Add an Internet Explorer ActiveX control to APP3. Set the controls URL to the A. Datum Corporation ReportManager. ✘ Create a hyperlink in APP3 that references the Report Manager. ✘ Create a proxy class to the Report Server Web service. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a view to fulfill the marketing department requirements. What should you do?

Join the Participant table to the Survey table by using a left outer join operator. ✘ Join the Participant table to the Survey table by using a full outer join operator. ✘ Join the Participant table to the Survey table by using an inner join operator. ✘ Join the Participant table to the Survey table by using a join operator. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design the new report named Results. What should you do?

Create a correlated subquery to produce a report that has concatenated respondent names. ✘ Create a table-valued function to produce a report that has concatenated respondent names. ✘ Create a user-defined aggregation to produce a report that has concatenated respondent names. ✘ Create a common table expression (CTE) query to produce the report. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?

Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database. ✘ Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL storedprocedure to cleanse the data and to insert the data into the database. ✘ Create a SQL Server Integration Services (SSIS) package to import, standardize, and cleanse the data. ✘ Create a CLR stored procedure to import the data into a staging table, to cleanse and standardize the data,and to insert the data into the database. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You need to control inadvertent changes to the database objects on the production database servers. What should you do?

Create DDL triggers to roll back changes to database objects. Disable the DDL triggers during maintenance activities. ✘ Revoke all CREATE, ALTER, and DROP permissions in the databases. ✘ Maintain all source code in a source code management tool. ✘ Script all database objects to individual text files. ✔

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 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