[Nov 30, 2023] COF-C02 certification guide Q&A from Training Expert TestSimulate
COF-C02 Certification Overview Latest COF-C02 PDF Dumps
The SnowPro Core Certification Exam is designed for individuals who are interested in pursuing a career in data warehousing and analytics. It is also suitable for professionals who are already working with the Snowflake platform and want to enhance their knowledge and skills. COF-C02 exam is an excellent opportunity for individuals to validate their skills and demonstrate their proficiency in the Snowflake platform.
NEW QUESTION # 97
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
- A. Create a task that runs a GET operation to intermittently check for new files
- B. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
- C. Create a task that puts the files in an internal stage and automate the data loading wizard
- D. Create a task that runs a copy into operation from an external stage every 5 minutes
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 98
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
- A. SHARE on databases and schemas
- B. REFERENCE_USAGE on databases
- C. CREATE_SHARE on the account
- D. SELECT on tables used by the secure view
Answer: B
NEW QUESTION # 99
True or false: it is best practice to define a clustering key on every table.
- A. False
- B. True
Answer: A
NEW QUESTION # 100
Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)
- A. Growth of storage and compute are tightly coupled together
- B. Compute can be scaled up or down without the requirement to add more storage
- C. Multiple compute clusters can access stored data without contention
- D. Storage expands without the requirement to add more compute
Answer: B,C,D
NEW QUESTION # 101
Snowflake is designed for which type of workloads? (Choose two.)
- A. OLAP (Analytics) workloads
- B. OLTP (Transactional) workloads
- C. On-premise workloads
- D. Concurrent workloads
Answer: A,D
NEW QUESTION # 102
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- A. REPLACE_INVALID_CHARACTERS
- B. STRIP_NULL_VALUES
- C. SKIP_BYTE_ORDER_MARK
- D. VALIDATION_MODE
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
NEW QUESTION # 103
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
- A. 300-500 MB
- B. 10-50 MB
- C. 100-250 MB
- D. 1000-1500 MB
Answer: C
NEW QUESTION # 104
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
- A. Premium
- B. Enterprise
- C. Standard
- D. Business Critical
Answer: D
Explanation:
https://docs.snowflake.com/en/user-guide/privatelink-azure.html
NEW QUESTION # 105
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. False
- B. True
Answer: B
NEW QUESTION # 106
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
- A. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
- B. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- C. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
Answer: D
NEW QUESTION # 107
As a best practice, clustering keys should only be defined on tables of which minimum size?
- A. Multi-Gigabyte (GB) Range
- B. Multi-Terabyte (TB) Range
- C. Multi-Kilobyte (KB) Range
- D. Multi-Megabyte (MB) Range
Answer: B
NEW QUESTION # 108
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 ACCOUNT_USAGE.LOGIN_HISTORY; - C. SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY; - D. SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())
Answer: B
NEW QUESTION # 109
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
- A. In the metadata of the pipe for 64 days
- B. In the metadata of the target table for 64 days
- C. In the metadata of the target table for 14 days
- D. In the metadata of the pipe for 14 days
Answer: C
NEW QUESTION # 110
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
- A. Virtual Private Snowflake
- B. Enterprise
- C. Standard
- D. Business Critical
Answer: D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition
NEW QUESTION # 111
Where can a user find and review the failed logins of a specific user for the past 30 days?
- A. The ACCESS_HISTORY view in ACCOUNT_USAGE
- B. The USERS view in ACCOUNT_USAGE
- C. The LOGIN_HISTORY view in ACCOUNT_USAGE
- D. The SESSIONS view in ACCOUNT_USAGE
Answer: C
NEW QUESTION # 112
What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.
- A. Installing and configuring hardware
- B. Patching software
- C. Physical security
- D. Maintaining metadata and statists
Answer: A,B,D
NEW QUESTION # 113
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
- A. Is only available to customers with Business Critical Edition
- B. Is available to all Snowflake Editions
- C. Is activated using an "ALTER DATABASE" command
- D. Restricts or enables access to specific IP addresses
Answer: B,D
NEW QUESTION # 114
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
- A. False
- B. True
Answer: B
NEW QUESTION # 115
Which formats does Snowflake store unstructured data in? (Choose two.)
- A. Array
- B. Object
- C. GeoJSON
- D. XML
- E. BLOB
Answer: B,E
NEW QUESTION # 116
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data.
Will the developer be able to modify the table to read the masked data?
- A. No, because masking policies must always reference specific access roles.
- B. No, because ownership of a table does not include the ability to change masking policies
- C. Yes, because a table owner has full control and can unset masking policies.
- D. Yes, because masking policies only apply to cloned tables.
Answer: C
NEW QUESTION # 117
Which of the following are best practices for loading data into Snowflake? (Choose three.)
- A. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
- B. Enclose fields that contain delimiter characters in single or double quotes.
- C. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
- D. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
- E. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
- F. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
Answer: A,B,F
NEW QUESTION # 118
......
The Best Snowflake COF-C02 Study Guides and Dumps of 2023: https://www.testsimulate.com/COF-C02-study-materials.html