Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 101:

  Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

  A. INSERT

  B. PUT

  C. GET

  D. COPY

  Correct Answer: D

• Question 102:

  What are supported file formats for unloading data from Snowflake? (Choose three.)

  A. XML

  B. JSON

  C. Parquet

  D. ORC

  E. AVRO

  F. CSV

  Correct Answer: BCF

• Question 103:

  What happens when an external or an internal stage is dropped? (Select TWO).

  A. When dropping an external stage, the files are not removed and only the stage is dropped

  B. When dropping an external stage, both the stage and the files within the stage are removed

  C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable

  D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

  E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

  Correct Answer: AD

• Question 104:

  Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

  A. ROLES

  B. POLICY_REFERENCES

  C. QUERY_HISTORY

  D. RESOURCE_MONIT ORS

  E. ACCESS_HISTORY

  F. MASKING_POLICIES

  Correct Answer: BF

  https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%20POLICY-,Auditing%20Dynamic%20Data%20Masking,a%20masking%20policy%20is%20set.

• Question 105:

  How would you determine the size of the virtual warehouse used for a task?

  A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

  B. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

  C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

  D. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

  Correct Answer: C

• Question 106:

  Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

  A. Pipe

  B. External stage

  C. Task

  D. Stream

  Correct Answer: A

  Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

• Question 107:

  Which Snowflake feature is used for both querying and restoring data?

  A. Cluster keys

  B. Time Travel

  C. Fail-safe

  D. Cloning

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.

• Question 108:

  Which of the following can be executed/called with Snowpipe?

  A. A User Defined Function (UDF)

  B. A stored procedure

  C. A single copy_into statement

  D. A single insert__into statement

  Correct Answer: C

• Question 109:

  What features does Snowflake Time Travel enable?

  A. Querying data-related objects that were created within the past 365 days

  B. Restoring data-related objects that have been deleted within the past 90 days

  C. Conducting point-in-time analysis for Bl reporting

  D. Analyzing data usage/manipulation over all periods of time

  Correct Answer: B

  Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:

  Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted. Duplicating and backing up data from key points in the past. Analyzing data usage/manipulation over specified

  periods of time.

  https://docs.snowflake.com/en/user-guide/data-time-travel.html

• Question 110:

  In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

  A. Bytes scanned

  B. Bytes sent over the network

  C. Number of partitions scanned

  D. Percentage scanned from cache

  E. External bytes scanned

  Correct Answer: CD