COF-C02 Free Exam Questions and Answers PDF Updated on Apr-2023
Latest COF-C02 Exam Dumps Recently Updated 265 Questions
NEW QUESTION 139
A deterministic query is run at 8am, takes 5 minutes, and the results are cached.
Which of the following statements are true? Choose 2 answers
- A. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
- B. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
- C. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
- D. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
Answer: C,D
NEW QUESTION 140
The Snowflake Cloud Data Platform is described as having which of the following architectures?
- A. Serverless query engine
- B. Shared-nothing
- C. Shared-disk
- D. Multi-cluster shared data
Answer: D
NEW QUESTION 141
What is the purpose of multi-cluster virtual warehouses?
- A. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
- B. To allow the warehouse to resize automatically
- C. To eliminate or reduce Queuing of concurrent queries
- D. To create separate data warehouses to increase query optimization
Answer: C
NEW QUESTION 142
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?
- A. Database
- B. Tables
- C. Warehouses
- D. Worksheets
Answer: A,C,D
NEW QUESTION 143
What are supported file formats for unloading data from Snowflake? (Choose three.)
- A. JSON
- B. XML
- C. AVRO
- D. ORC
- E. CSV
- F. Parquet
Answer: A,E,F
NEW QUESTION 144
Which of the following describes external functions in Snowflake?
- A. They contain their own SQL code.
- B. They call code that is stored inside of Snowflake.
- C. They are a type of User-defined Function (UDF).
- D. They can return multiple rows for each row received
Answer: C
Explanation:
External functions are user-defined functions that are stored and executed outside of Snowflake.
External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.
https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.
NEW QUESTION 145
What is the purpose of an External Function?
- A. To call code that executes outside of Snowflake
- B. To share data in Snowflake with external parties
- C. To run a function in another Snowflake database
- D. To ingest data from on-premises data sources
Answer: A
Explanation:
https://docs.snowflake.com/en/sql-reference/external-functions.html
NEW QUESTION 146
What is the most granular object that the Time Travel retention period can be defined on?
- A. Table
- B. Account
- C. Schema
- D. Database
Answer: A
NEW QUESTION 147
True or False: Pipes can be suspended and resumed.
- A. True
- B. False
Answer: A
NEW QUESTION 148
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
- A. Enterprise
- B. Standard
- C. Premier
- D. Business Critical Edition
Answer: A
NEW QUESTION 149
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
- A. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
- B. There is no need to have a Snowflake account in the target region, a share will be created for each user.
- C. Shares attached to listings in remote regions can be viewed from any account in an organization.
- D. The listing is replicated into all selected regions automatically, the data is not.
- E. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
Answer: B,E
NEW QUESTION 150
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 151
Which of the following accurately describes shares?
- A. Access to a share cannot be revoked once granted
- B. Tables, secure views, and secure UDFs can be shared
- C. Data consumers can clone a new table from a share
- D. Shares can be shared
Answer: B
NEW QUESTION 152
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
- A. SHOW GRANTS TO ROLE MY_ROLE
- B. SHOW GRANTS OF ROLE MY_ROLE
- C. SHOW GRANTS FOR ROLE MY_ROLE
- D. SHOW GRANTS ON ROLE MY_ROLE
Answer: A
NEW QUESTION 153
When loading data into Snowflake, the COPY command supports: Choose 2 answers
- A. Aggregates
- B. Column reordering
- C. Fitters
- D. Data type conversions
- E. Joins
Answer: B,D
NEW QUESTION 154
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
- A. The reader account will automatically use the Standard edition of Snowflake.
- B. The reader account compute will be billed to the provider account.
- C. The reader account can create a copy of the shared data using CREATE TABLE AS...
- D. The reader account can clone data the provider has shared, but cannot re-share it.
Answer: D
NEW QUESTION 155
What privilege should a user be granted to change permissions for new objects in a managed access schema?
- A. Grant the OWNERSHIP privilege on the database.
- B. Grant ALL privileges on the schema.
- C. Grant the OWNERSHIP privilege on the schema.
- D. Grant the MANAGE GRANTS global privilege.
Answer: D
NEW QUESTION 156
......
Snowflake COF-C02 Real 2023 Braindumps Mock Exam Dumps: https://passguide.dumpexams.com/COF-C02-vce-torrent.html