Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Microsoft 70-460 Exam - Cheat-Test.com

Free 70-460 Sample Questions:

Q: 1
You work as a database developer at ABC.com. ABC.com has a SQL Server 2012 database infrastructure with a very large database named SalesDB. You create a new table named SalesHistory that will hold historical data from the SalesDB database.
You need to perform a batch update from the SalesDB database to the SalesHistory table. You want the status information from the batch process to be logged to a SQL Server table that must be created by the batch process.
How would you accomplish this task?
A. You should make use of the FORMAT function.
B. You should make use of the CONVERT function.
C. You should make use of a scalar user-defined function.
D. You should make use of an inline function.
E. You should make use of a table-valued function.
F. You should make use of a stored procedure.
Answer: C

Q: 2
You are developing a SQL Server 2012 database for ABC.com. You need to create a computed column that returns the data by referencing another table using an INNER JOIN.
How would you accomplish this?
A. You should make use of the FORMAT function.
B. You should make use of a scalar user-defined function.
C. You should make use of an inline function.
D. You should make use of a table-valued user-defined function.
E. You should make use of a stored procedure.
Answer: B

Q: 3
Which of the following statements regarding SQL Server 2012 objects is TRUE?
A. A user-defined data type can accept an input variable and return a table of results but cannot be used within a view.
B. A scalar function can accept an input variable and return a table of results but cannot be used within a view.
C. A table-valued function can accept an input variable and return a table of results but cannot be used within a view.
D. A table-valued type can accept an input variable and return a table of results but cannot be used within a view.
Answer: A

Q: 4
You work as a SQL Server 2012 database developer at ABC.com. TesABCig.com has a database named DataDB.
You are developing a complex stored procedure named sp_updater that will use a single transaction to update several tables in the DataDB database.
You are concerned about data integrity and incomplete updates should the sp_updater stored procedure cause a run-time error.
To mitigate this potential problem you want the transaction to terminate and the transaction to be rolled back if the sp_updater stored procedure raises a run-time error.
How would you accomplish this task?
A. You should make use of the SET XACT_ABORT ON statement in the stored procedure.
B. You should have the stored procedure run in the SERIALIZABLE ISOLATION LEVEL.
C. You should make use of a LOOP hint in the stored procedure.
D. You should have the stored procedure run in the SNAPSHOT ISOLATION LEVEL.
E. You should make use of an INSTEAD OF UPDATE trigger in the stored procedure.
Answer: A

Q: 5
You work as a SQL Server 2012 database developer at ABC.com.
ABC.com has a database SalesDB with a large Orders table. You create a heap named OldData that will store historical data from the Orders table.
You need to write a Transact-SQL query that will insert rows of data from the Orders table that are marked as closed and are more than six months old.
Which of the following table hints should you use in your query if you want to optimize transaction logging and locking for the query?
A. You should make use of the READPAST hint.
B. You should make use of the HOLDLOCK hint.
C. You should make use of the READCOMMITTED hint.
D. You should make use of the NOLOCK hint.
E. You should make use of the TABLOCK hint.
F. You should make use of the UPDLOCK hint.
Answer: E


© 2014 Cheat-Test.com, All Rights Reserved