SOL-C01 · Question #82
SOL-C01 Question #82: Real Exam Question with Answer & Explanation
The correct answer is A: It selects all columns from a specified table or view.. 'SELECT selects all columns from a specified table or view and can be used with a 'WHERE' clause. The column order is not guaranteed to be the defined order. `SELECT is generally discouraged in production as changes to the table schema can break applications relying on a specific
Question
Which of the following statements are true regarding the 'SELECT ' command in Snowflake?
Options
- AIt selects all columns from a specified table or view.
- BIt always returns the columns in the order they were defined in the table schema.
- CIt is generally recommended for production environments due to its performance efficiency.
- DIt selects all columns from all tables in the current database.
- EIt can be used in conjunction with a 'WHERE' clause to filter the results.
Explanation
'SELECT selects all columns from a specified table or view and can be used with a 'WHERE' clause. The column order is not guaranteed to be the defined order. `SELECT is generally discouraged in production as changes to the table schema can break applications relying on a specific column order or set of columns and it may return a lot of data unnecessarily. It only affects the table specified, not all tables in the database.
Topics
Community Discussion
No community discussion yet for this question.