Snowflake
ADA-C01 · Question #55
A Snowflake Administrator needs to retrieve the list of the schemas deleted within the last two days from the DB1 database. Which of the following will achieve this?
The correct answer is B. SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SCHEMATA. See the full explanation below for the reasoning.
Question
A Snowflake Administrator needs to retrieve the list of the schemas deleted within the last two days from the DB1 database. Which of the following will achieve this?
Options
- ASHOW SCHEMAS IN DATABASE DB1;
- BSELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SCHEMATA;
- CSELECT * FROM DB1.INFORMATION_SCHEMA.SCHEMATA;
- DSELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.DATABASES;
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- C4% (1)
- D8% (2)
Community Discussion
No community discussion yet for this question.