Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 251:

  Which command can be used to load data into an internal stage?

  A. LOAD

  B. copy

  C. GET

  D. PUT

  Correct Answer: D

  https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

• Question 252:

  What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

  A. Informatica

  B. Power Bl

  C. Adobe

  D. Data Robot

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

• Question 253:

  What feature can be used to reorganize a very large table on one or more columns?

  A. Micro-partitions

  B. Clustering keys

  C. Key partitions

  D. Clustered partitions

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 254:

  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: AC

• Question 255:

  A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

  A. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;

  B. SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())

  C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;

  D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

  Correct Answer: D

• Question 256:

  Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

  A. Load files that are approximately 25 MB or smaller.

  B. Remove all dates and timestamps.

  C. Load files that are approximately 100-250 MB (or larger)

  D. Avoid using embedded characters such as commas for numeric data types

  E. Remove semi-structured data types

  Correct Answer: CD

  https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

• Question 257:

  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 258:

  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

  Correct Answer: BC

  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 259:

  When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse

  According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

  A. Use multi-clustered warehousing to scale out warehouse capacity.

  B. Scale up the warehouse size to allow Queries to execute faster.

  C. Stop and start the warehouse to clear the queued queries

  D. Migrate some queries to a new warehouse to reduce load

  E. Limit user access to the warehouse so fewer queries are run against it.

  Correct Answer: AD

• Question 260:

  A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

  A. The primary cluster in the virtual warehouse

  B. The entire virtual warehouse

  C. The database in which the virtual warehouse resides

  D. The Queries currently being run on the virtual warehouse

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.