Question 1 · 11 in bank
Select 2A user is automating a data pipeline using the Snowflake CLI and needs to pass variables into SQL scripts. Which variable templating syntaxes should be used? (Choose two.)
Show answer
Answer: BC
SnowPro Core11 questions across 2 pages are complete and free, with no account or card.
11 questions in this bank
Free access · progress saved on this device
A user is automating a data pipeline using the Snowflake CLI and needs to pass variables into SQL scripts. Which variable templating syntaxes should be used? (Choose two.)
Answer: BC
Which objects can be recovered after being dropped? (Choose two.)
Answer: DE
Which feature or service should be used to identify data about a department that was responsible for a recent revenue shortfall?
Answer: C
Which interface or service allow users to connect to Snowflake with Python? (Choose two.)
Answer: AE
Which feature allows users to audit how sensitive data is being accessed over time?
Answer: D
Which security features are used to control inbound access to Snowflake and internal stages? (Choose two.)
Answer: AC
A data team needs to connect Snowflake to a remote Git repository over a public network using a personal access token for authentication. Which components should be created in Snowflake to implement this connection? (Choose two.)
Answer: CE
When using the COPY INTO <table> command, which parameter should be used to load unstructured data?
Answer: C
A Developer has scheduled a dynamic table to refresh incrementally, but the process uses a full refresh instead. When used, which query operator will cause a full refresh instead of the scheduled incremental refresh?
Answer: C
Which types of values lead to slower queries and increased storage consumption when placed within a VARIANT column? (Choose two.)
Answer: AE
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C03 practice, question 1. 11 questions available.
Version 1.0.0. How we source questions