Question: You need to create a simple database backup in the server's `Z:\Backups` directory. Which query should you use?

1. `BACKUP MyDatabase TO LOCATION = 'Z:\Backups\MyDatabase.bak';`
2. `CREATE BACKUP (DATABASE = 'MyDatabase' TO DISK = 'Z:\Backups\MyDatabase. bak');`
3. `BACKUP DATABASE MyDatabase ON 'Z:\Backups\MyDatabase.bak';`
4. `BACKUP DATABASE MyDatabase TO DISK = 'z:\Backups\MyDatabase.bak';`

Answer: The correct answer of the above question is Option D:`BACKUP DATABASE MyDatabase TO DISK = 'z:\Backups\MyDatabase.bak';`