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
Which type of role can be granted to a share?
Answer: C
Grant the database role to a share and grant future privileges on an object to the database role: GRANT DATABASE ROLE dbr1 TO SHARE myshare; GRANT SELECT ON FUTURE TABLES IN SCHEMA sh TO DATABASE ROLE dbr1;
Source: Adapted from community discussion — nexerSnow
When unloading data with the COPY INTO [location] command, what is the purpose of the PARTITION BY parameter option?
Answer: D
What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?
Answer: B
Non-native values such as dates and timestamps are stored as strings when loaded into a VARIANT column, so operations on these values could be slower and also consume more space than when stored in a relational column with the corresponding data type.
Source: Adapted from community discussion — nexerSnow
Which of the following statements is true of Snowflake micro-partitioning?
Answer: C
Which views are included in the DATA_SHARING_USAGE schema? (Choose two.)
Answer: D
Correct Answers: D. MONETIZED_USAGE_DAILY and E. LISTING_TELEMETRY_DAILY MONETIZED_USAGE_DAILY: This view provides daily usage data for monetized data sharing, which is relevant for tracking and analyzing how shared data is being accessed and utilized in a monetized context. LISTING_TELEMETRY_DAILY: This view contains daily telemetry data for data listings, offering insights into the activity and interactions with data listings shared via Snowflake.
Source: Adapted from community discussion — cybe001
What does a table with a clustering depth of 1 mean in Snowflake?
Answer: C
Which Snowflake object contains all the information required to share a database?
Answer: D
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
Answer: D
Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?
Answer: B
When a Snowflake user loads CSV data from a stage, which COPY INTO [table] command guideline should they follow?
Answer: B
B is correct. Any valid character can be used as a field delimiter (not A) Snowflake recommends that files be compressed, but it's not required (Not C) You can drop columns from the file to the target table (Not D) https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare#preparing-delimited-text-files
Source: Adapted from community discussion — Catallyst48
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 11. 1323 questions available.
Version 1.0.0. How we source questions