Microsoft 70-464 Exam Practice Questions (P. 2)
- Full Access (209 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #6
DRAG DROP -
You are designing two stored procedures named Procedure1 and Procedure2.
You identify the following requirements:
✑ Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure.
✑ Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)
Select and Place:
You are designing two stored procedures named Procedure1 and Procedure2.
You identify the following requirements:
✑ Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure.
✑ Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)
Select and Place:
Correct Answer:
References:
http://msdn.microsoft.com/en-us/library/ms131102.aspx
http://msdn.microsoft.com/en-us/library/bb522446.aspx
http://msdn.microsoft.com/en-us/library/bb510489.aspx
References:
http://msdn.microsoft.com/en-us/library/ms131102.aspx
http://msdn.microsoft.com/en-us/library/bb522446.aspx
http://msdn.microsoft.com/en-us/library/bb510489.aspx
Question #8
You have a database that contains a user-defined function named Schema1.Udf1 and two tables named Schema1.Table1 and Schema1.Table2.
Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.
Schema1.Udf1 was defined by using the following code:
You need to write a query that will contain the following columns:
✑ Country
✑ CountryID
✑ CustomerName
The solution must meet the following requirements:
✑ Rows must be returned only if the function returns data.
✑ The amount of time it takes the query to execute must be minimized.
Which query should you use?
Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.
Schema1.Udf1 was defined by using the following code:
You need to write a query that will contain the following columns:
✑ Country
✑ CountryID
✑ CustomerName
The solution must meet the following requirements:
✑ Rows must be returned only if the function returns data.
✑ The amount of time it takes the query to execute must be minimized.
Which query should you use?
Question #9
You have a database hosted on SQL Azure.
You are developing a script to create a view that will be used to update the data in a table.
The following is the relevant portion of the script. (Line numbers are included for reference only.)
You need to ensure that the view can update the data in the table, except for the data in Column1.
Which code segment should you add at line 06?
You are developing a script to create a view that will be used to update the data in a table.
The following is the relevant portion of the script. (Line numbers are included for reference only.)
You need to ensure that the view can update the data in the table, except for the data in Column1.
Which code segment should you add at line 06?
Question #10
DRAG DROP -
You are planning two stored procedures named SProc1 and SProc2. You identify the following requirements:
✑ SProc1 must return a table.
✑ SProc2 must return a status code.
You need to identify which options must be implemented to meet each stored procedure requirement.
Which options should you identify?
To answer, drag the appropriate option to the correct requirement in the answer area. (Answer choices may be used once, more than once, or not at all.)
Select and Place:
You are planning two stored procedures named SProc1 and SProc2. You identify the following requirements:
✑ SProc1 must return a table.
✑ SProc2 must return a status code.
You need to identify which options must be implemented to meet each stored procedure requirement.
Which options should you identify?
To answer, drag the appropriate option to the correct requirement in the answer area. (Answer choices may be used once, more than once, or not at all.)
Select and Place:
All Pages