Study tips 70-461

Which Transact-SQL statement should you use?

What Transact SQL statement would accomplish this task?

How would you create this table?

Which Transact-SQL statement should you use?

You need to improve the performance of the view by persisting data to disk

You need to store the departure and arrival dates and times of flights along with time zone information

You need to supply the stored procedure with multiple event names and their dates as parameters

Which code segment should you use?

Which code segment should you use?

Which code segment should you use?