SOL-C01 · Question #307
A data engineer is building a Snowflake Notebook to perform some data transformations. The notebook interacts with a Snowflake table named 'SALES DATA' which contains columns like 'ORDER ID', 'PRODUCT
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #307. The question stem and answer options stay visible for context.
Question
A data engineer is building a Snowflake Notebook to perform some data transformations. The notebook interacts with a Snowflake table named 'SALES DATA' which contains columns like 'ORDER ID', 'PRODUCT ID, 'SALE DATE, and `SALE AMOUNT. The engineer wants to use a Streamlit application to visualize the daily sales trends based on the transformed data. However, they are facing challenges with authenticating the Streamlit application to Snowflake and efficiently retrieving the data. Which of the following approaches would provide the most secure and efficient way to authenticate Streamlit to Snowflake and load the necessary data?
Options
- AHardcoding Snowflake credentials (username and password) directly within the Streamlit
- BUsing a Snowflake access token generated outside of Streamlit and passing it as a Streamlit
- CCreating a Snowflake user with extremely broad privileges and storing those credentials as
- DGranting public access to the 'SALES_DATA' table and querying it directly from Streamlit without
- EUsing Snowflake's OAuth integration and leveraging Streamlit's ability to handle authentication
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 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.