Question 1001 · 1323 in bank
How can network and private connectivity security be managed in Snowflake?
Show answer
Answer: A
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
How can network and private connectivity security be managed in Snowflake?
Answer: A
What consideration should be made when loading data into Snowflake?
Answer: D
D The number of data files that can be processed in parallel is determined by the amount of compute resources in a warehouse. https://docs.snowflake.com/en/user-guide/data-load-considerations-plan
Source: Adapted from community discussion — 0e504b5
How can a user improve the performance of a single large complex query in Snowflake?
Answer: A
A Scaling up is for improving speed of a single complex query. Scaling out is for solving concurrency issues (queueing of many queries) Resizing a warehouse generally improves query performance, particularly for larger, more complex queries. It can also help reduce the queuing that occurs if a warehouse does not have enough compute resources to process all the queries that are submitted concurrently. Note that warehouse resizing is not intended for handling concurrency issues; instead, use additional warehouses to handle the workload or use a multi-cluster warehouse (if this feature is available for your account). https://docs.snowflake.com/en/user-guide/warehouses-considerations
Source: Adapted from community discussion — 0e504b5
If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended when:
Answer: D
Hi could you please add or update it some more questions. I took Snowflake pro core exam last week but didn't able to pass the exam. I have gone all the questions which is here but even one question didn't come to the exam from this.
Source: Adapted from community discussion — kaun
Who can access a referenced file through a scoped URL?
Answer: B
Scoped URL Only the user who generated the scoped URL can use the URL to access the referenced file. File URL Any role that has sufficient privileges on the stage can access the file: External stage: USAGE Internal stage: READ
Source: Adapted from community discussion — stornati
Snowflake will return an error when a user attempts to share which object?
Answer: C
C You can share the following Snowflake database objects: External tables Dynamic tables Secure views Secure materialized views Secure UDFs Tables https://docs.snowflake.com/en/user-guide/data-sharing-intro
Source: Adapted from community discussion — 0e504b5
What setting in Snowsight determines the databases, tables, and other objects that can be seen and the actions that can be performed on them?
Answer: A
Why would a Snowflake user decide to use a materialized view instead of a regular view?
Answer: A
When a database is cloned, which objects in the clone inherit all granted privileges from the source object? (Choose two.)
Answer: CD
DE https://docs.snowflake.com/en/user-guide/object-clone#access-control-privileges-for-cloned-objects Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container. This rules out BC. A can't be cloned. This leaves us DE.
Source: Adapted from community discussion — 0e504b5
How does the Access_History view enhance overall data governance pertaining to read and write operations? (Choose two.)
Answer: AB
The ACCESS_HISTORY view provides a unified picture of what data was accessed, when the data access took place, and how the accessed data moved from the data source object to the data target object. https://docs.snowflake.com/en/user-guide/access-history
Source: Adapted from community discussion — Rana1986
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1001. 1323 questions available.
Version 1.0.0. How we source questions