Study tips 70-462

You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained

You need to configure a new database to support FILETABLES

Which four actions should you perform in sequence?

Which Transact-SQL statement should you use before attempting the restore?

Which Transact-SQL statement should you use?

Which Transact-SQL statement should you use?

Which Transact-SQL statement should you use?

Which Transact-SQL statement should you use?

You need to ensure that the login for the ticketing application cannot access other production databases

You need to ensure that the minimum amount of disk space is used to store the data in the customer table