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

Question - 15 Maximum mark : - 26

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 2

You are developing a stored procedure named Community.usp_ScoreInsertMultiple. This stored procedure will be used to write the scores of one or more players for one or more games to a database table named Community.MemberGameScores. One row should be inserted for each player/game combination. You need to accomplish this goal in a single call to the database. What should you do?

Create a user-defined type named PlayerScoresType.User PlayerScoresType as a parameter to the stored procedure. ✘ Create a user-defined aggregate named PlayerScoresAggregate.Use PlayerScoresAggregate as aparameter to the stored procedure. ✘ Add an nvarchar(max) parameter, and send the scores as a comma-delimited list. ✘ Add an xml parameter, and provide the scores to the stored procedure in XML format. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are designing a stored procedure in the Community schema that will retrieve data from tables in the Community schema and in the Financial schema. You know that at least one query against the Financial schema will need to use dynamic SQL. You need to use only the minimum permissions that are required by the applications user to execute this stored procedure. Which permission or permissions should you use? (Choose all that apply.)

EXECUTE permission on the stored procedure and SELECT permission on the Financial table that the dynamic SQL query will use ✘ EXECUTE permission on the stored procedure and SELECT permission on all of the Financial tables thatare used in the stored procedure ✘ EXECUTE permission on the stored procedure only ✘ EXECUTE permission on the stored procedure and SELECT permission on all of the Community tables thatare used in the stored procedure ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are developing the SQL Server Integration Services (SSIS) package that will load the data warehouse server for the gaming community. You need to ensure that in the event of a package failure, the remaining load time is as short as possible when restarting the package. You must also ensure that no duplicate data is loaded. Which action or actions should you perform? (Choose all that apply.)

Set the TransactionOption property of the package to Required. Set the TransactionOption property of each task to Required. Set the package to create a database snapshot after each successful task. Use package checkpoints. Set the package to restart at the last database snapshot.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design the deletion of characters to comply with the application requirements. What should you do?

Design a stored procedure that verifies that the character can be deleted and then deletes it. ✘ Design a user-defined function that verifies that the character can be deleted. ✘ Design a trigger a that checks whether the character should not be deleted and ensures that it is notdeleted. ✘ Design a view that shows only characters that can be deleted. Always delete characters through this view. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

When the community is in production, sales representatives will need to generate the gaming community usage report. The report was designed by using SSRS, and it uses both query and filter parameters. You need to minimize response time when the representatives browse this report, and you need to minimize the impact on the overall performance of the production servers. What should you do?

Create snapshots of the report every hour, and render the report from the snapshot. ✘ Enable session caching for the report with a timeout of 60 minutes. ✘ Create an indexed view that covers the reports query. ✘ Create new indexes on all tables that are used by this report. In these indexes, include all columns that arereferenced in the reports query. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a strategy for modifying database objects that will fulfill the business requirements. What should you do?

Specify a default value, and specify that null values are allowed for new table columns.Specify that the order of columns cannot be changed.Specify that the return type of user-defined functions cannot be changed. ✘ Specify that null values are not allowed for new table columns.Specify that columns cannot be added toexisting views.Specify that new parameters for existing user-defined functions must be added at the end of the parameter list. ✘ Specify that null values are not allowed for new table columns.Specify that new parameters for existingstored procedures must be added at the end of the parameter list.Specify that when the return type for a user-defined function is changed, only a larger data type can be used. ✘ Specify that null values are allowed for new table columns.Specify that the order of columns cannot bechanged.Specify that new parameters for existing user-defined functions must be added at the end of the parameter list. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design database performance monitoring to fulfill the business and technical requirements. What should you do?

Use SQL Server Profiler to monitor database activity. Use System Monitor to monitor server performance. ✘ Use the SQL Trace stored procedures to monitor database activity. Use Performance Logs and Alerts tomonitor server performance. ✘ Use a SQL Server Integration Services (SSIS) package to monitor database activity and to monitor serverperformance. ✘ Use the SQL Trace stored procedures to monitor database activity. Use System Monitor to monitor serverperformance. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are designing the function that will be used to verify whether a members character in game can be deleted. What should you do?

Design the function as a stored procedure in a .NET Framework language. ✘ Design the function as a stored procedure in Transact-SQL. ✘ Design the function as a user-defined function in a .NET Framework language. ✘ Design the function as a user-defined function in Transact-SQL. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design the storage of character information as specified in the business and technical requirements. What should you do?

Create a user-defined type (UDT) that can handle storing the information for a character in any game, and load it into the database. Store the information for the characters in a column named CharacterInformation by using the UDT, as shown in the following table.Community.MemberGameCharactersMemberIDGameIDCharacterInformationINTINT(The UDT) ✘ Store the information about the members characters in a column named CharacterInformation with the xmldata type, as shown in the following table.Community.MemberGameCharactersMemberIDGameIDCharacterInformationINTINTXML ✘ For each game, create a single table that associates that games members with their character informationin that specific game. ✘ Store the information about the members characters in a column named CharacterInformation with thenvarchar(max) data type, as shown in the following table.Community.MemberGameCharactersMemberIDGameIDCharacterInformationINTINTNVARCHAR (max) ✔ Store the information about the members characters in a column named CharacterInformation with thevarchar(max) data type, as shown in the following table.Community.MemberGameCharactersMemberIDGameIDCharacterInformationINTINTVARCHAR(max) ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

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 2

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