Examen 70-461 V001

Results

#1. You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by using the following definition: You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What should you do?

Explanation:

http://msdn.microsoft.com/en-us/library/cc280449.aspx

http://msdn.microsoft.com/en-us/library/cc280464.aspx

http://msdn.microsoft.com/en-us/library/cc280576.aspx

http://msdn.microsoft.com/en-us/library/ee240835.aspx

#2. You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. What should you do?

#3. You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage users who are prevented from deleting records in the Sales schema. You need to achieve this goal by using the minimum amount of administrative effort. What should you do?

#4. You develop a database for a travel application. You need to design tables and other database objects. You create the Airline_Schedules table. You need to store the departure and arrival dates and times of flights along with time zone information. What should you do?

Explanation:

http://msdn.microsoft.com/en-us/library/ff848733.aspx

http://msdn.microsoft.com/en-us/library/bb630289.aspx

#5. You are a database developer at an independent software vendor. You create stored procedures thatcontain proprietary code. You need to protect the code from being viewed by your customers. Which storedprocedure option should you use?

http://technet.microsoft.com/en-us/library/bb510663.aspx 

http://technet.microsoft.com/en-us/library/ms174361.aspx

http://msdn.microsoft.com/en-us/library/ms187926.aspx

http://technet.microsoft.com/en-us/library/ms190357.aspx

http://technet.microsoft.com/en-us/library/ms188061.aspx

Deja una respuesta

WP to LinkedIn Auto Publish Powered By : XYZScripts.com