Which restore option is suitable in this scenario?

You have been notified that the ‘apps’ . ‘reports’ table has been accidentally truncated. You
have single file mysqldump backup available taken prior to the truncate. The backup

contains all the tables from the instance, and the ‘apps’ . ‘reports’ table must be restored
without affecting the other remaining databases and tables. Which restore option is suitable
in this scenario?

A.
Execute LOAD DATA INFILE ‘backup.sql’ SCHEMA=’apps’ TABLE= ‘reports’

B.
Execute mysqldump on the backup,sql file and apply – filter arguments to obtain only the
‘apps’ . ‘reportys’ table.

C.
Restore the backup to another databases instance and obtain a copy of the reports table
individually.

D.
Extract the ‘apps’ . ‘reports’ table from the backup using the SOURCE command.