SOL-C01 Question #6: Real Exam Question with Answer & Explanation

Question

A Snowflake administrator needs to determine the default collation setting for a newly created database. Which of the following methods can be used to identify the default collation of the database named 'MY DATABASE?

Options

• ADESCRIBE DATABASE MY DATABASE;
• BSHOW DATABASES LIKE 'MY DATABASE';
• CSELECT followed by SELECT collation FROM INFORMATION_SCHEMA.DATABASES WHERE
• DSELECT FROM WHERE option_name = 'COLLATION';
• ESELECT DATABASE COLLATION FROM INFORMATION SCHEMA.DATABASES WHERE

Explanation

'DESCRIBE DATABASE MY_DATABASE;' will show all properties of the database, including the default collation. 'SHOW DATABASES LIKE 'MY DATABASE';' will also show information about the database but does not guarantee displaying the default collation. Options C, D, and E use the INFORMATION_SCHEMA, which is useful, but option A gives direct and complete metadata. 'DATABASE_OPTIONS' table does not exists in information schema. The most efficient method and recommended way is to use `DESCRIBE DATABASE.

No community discussion yet for this question.