[May 22, 2024] COF-C02 Ultimate Study Guide - PracticeDump
Ultimate Guide to Prepare COF-C02 Certification Exam for SnowPro Core in 2024
NEW QUESTION # 69
Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
- A. Data classification
- B. Tagging
- C. Query acceleration service
- D. Search optimization service
Answer: D
NEW QUESTION # 70
Fail-safe is unavailable on which table types?
- A. Temporary
- B. Provisional
- C. Transient
- D. Permanent
Answer: A,C
NEW QUESTION # 71
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
- A. User-Defined Table Functions (UDTF)
- B. External Tables
- C. External Tokenization
- D. Materialized Views
Answer: C
NEW QUESTION # 72
Which Snowflake partner specializes in data catalog solutions?
- A. Alation
- B. Tableau
- C. DataRobot
- D. dbt
Answer: A
NEW QUESTION # 73
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
- A. Cluster depth
- B. Caching
- C. Query pruning
- D. Retrieval optimization
Answer: C
NEW QUESTION # 74
What is the MAXIMUM Time Travel retention period for a transient table?
- A. O days
- B. 7 days
- C. 1 day
- D. 90 days
Answer: C
NEW QUESTION # 75
True or False: Fail-safe can be disabled within a Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION # 76
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
- A. Custom Edition
- B. Enterprise Edition
- C. Virtual Private Snowflake
- D. Business Critical Edition
- E. Standard Edition
Answer: C,D
NEW QUESTION # 77
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers
- A. They should not set up multi_Factor Authentication (MFA)-as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
- B. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
- C. Their default role should be set to SYSTEMADMIN (the lower of the two)
- D. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
- E. They should use the SYSADMIN role to perform administrative work on database objects
Answer: C,D,E
NEW QUESTION # 78
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
- A. ACCESS_HISTORY
- B. RESOURCE_MONIT ORS
- C. POLICY_REFERENCES
- D. QUERY_HISTORY
- E. ROLES
Answer: C,D
Explanation:
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.
NEW QUESTION # 79
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
- A. The Pipe load history is reset to empty.
- B. The destination table is truncated.
- C. The REFRESH command is executed.
- D. The stage will be purged.
Answer: C
NEW QUESTION # 80
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
- A. COPY INTO TABLE statement
- B. Stage definition
- C. Table definition
- D. Session level
Answer: A
NEW QUESTION # 81
How long is Snowpipe data load history retained?
- A. Until the pipe is dropped
- B. 64 days
- C. As configured in the create pipe settings
- D. 14 days
Answer: B
Explanation:
Explanation
Bulk data load
Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%20dat
NEW QUESTION # 82
What happens when an external or an internal stage is dropped? (Select TWO).
- A. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
- B. When dropping an external stage, the files are not removed and only the stage is dropped
- C. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
- D. When dropping an external stage, both the stage and the files within the stage are removed
- E. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
Answer: B,E
NEW QUESTION # 83
True or False: Data Providers can share data with only the Data Consumer.
- A. True
- B. False
Answer: B
NEW QUESTION # 84
Which data types optimally store semi-structured data? (Select TWO).
- A. VARCHAR
- B. CHARACTER
- C. VARIANT
- D. ARRAY
- E. STRING
Answer: C,D
NEW QUESTION # 85
......
SnowPro Core Fundamentals-COF-C02 Exam-Practice-Dumps: https://pass4sure.practicedump.com/COF-C02-exam-questions.html