CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #2
A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the
Sign in or unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to reveal the answer and full explanation for question #2. The question stem and answer options stay visible for context.
Question
A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist. Which of the following commands can the analyst use to complete the task without producing an error?
Options
- ADROP DATABASE database_name;
- BDROP TABLE database_name.table_name;
- CDELETE TABLE database_name.table_name;
- DDELETE TABLE table_name FROM database_name;
- EDROP TABLE table_name FROM database_name;
Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to see the answer
You've previewed enough free CERTIFIED-DATA-ANALYST-ASSOCIATE questions. Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.