最新的Snowflake SnowPro® Core Certification (COF-C03) - COF-C03免費考試真題

問題1
At what levels can a resource monitor be configured? (Select TWO).

正確答案: B,C
說明:(僅 VCESoft 成員可見)
問題2
Which command removes a role from another role or a user in Snowflak?

正確答案: C
說明:(僅 VCESoft 成員可見)
問題3
Why is a federated environment used for user authentication in Snowflake?

正確答案: C
問題4
Which Snowflake feature enables loading data from cloud storage as soon as files are available in a stage?

正確答案: A
問題5
Why would the REPEATABLE keyword be used in a SAMPLE clause?

正確答案: C
說明:(僅 VCESoft 成員可見)
問題6
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

正確答案: D
說明:(僅 VCESoft 成員可見)
問題7
What is the least-privileged database role needed to view the definition of a secure materialized view?

正確答案: A
說明:(僅 VCESoft 成員可見)
問題8
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

正確答案: A,C,D
說明:(僅 VCESoft 成員可見)
問題9
Which Snowflake objects can process staged files in parallel? (Select TWO)

正確答案: A,E
問題10
Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

正確答案: C
問題11
What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).

正確答案: C,D
說明:(僅 VCESoft 成員可見)
問題12
What is cached during a query on a virtual warehouse?

正確答案: A
說明:(僅 VCESoft 成員可見)
問題13
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?

正確答案: D
說明:(僅 VCESoft 成員可見)
問題14
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

正確答案: A
說明:(僅 VCESoft 成員可見)
問題15
Use of which feature or setting consumes Snowflake credits, but generates no storage costs?

正確答案: B