SOL-C01 · Question #297
SOL-C01 Question #297: Real Exam Question with Answer & Explanation
The correct answer is A: Option A. Options A and D are the most efficient and correct. automatically handles the conversion of Snowflake TIMESTAMP NTZ to Pandas datetime objects. Option D `pd.read_sqr using the connection context is also good , which handles the conversion automatically as well. Option B fetches t
Question
In a Snowflake Notebook, you're attempting to read data from a Snowflake table named 'CUSTOMER DATA into a Pandas DataFrame for further analysis. The table contains a column named of data type TIMESTAMP NTZ. Which of the following Python code snippets will successfully read the data and preserve the 'CREATED_AT column as a datetime object in the DataFrame?
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
Explanation
Options A and D are the most efficient and correct. automatically handles the conversion of Snowflake TIMESTAMP NTZ to Pandas datetime objects. Option D `pd.read_sqr using the connection context is also good , which handles the conversion automatically as well. Option B fetches the data as tuples, requiring manual column naming and datetime conversion, and it is inefficient. Option C requires to work correctly. Option E cast timestamp column explicitly and defeats purpose.
Topics
Community Discussion
No community discussion yet for this question.