Latest [Apr 17, 2024] Snowflake COF-C02 Exam Practice Test To Gain Brilliante Result
Take a Leap Forward in Your Career by Earning Snowflake COF-C02
NEW QUESTION # 96
What is the minimum Snowflake edition that has column-level security enabled?
- A. Business Critical
- B. Enterprise
- C. Virtual Private Snowflake
- D. Standard
Answer: B
NEW QUESTION # 97
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 98
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A. An HTTPS server with WebDAV
- B. An FTP server with TLS encryption
- C. A Google Cloud storage bucket
- D. A Windows server file share on Azure
Answer: C
NEW QUESTION # 99
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
- A. select src.dealership from car_sales;
- B. select src:Dealership from car_sales;
- C. select src:dealership from car_sales;
- D. select dealership from car_sales;
Answer: C
NEW QUESTION # 100
Snowflake's hierarchical key mode includes which keys? (Select TWO).
- A. Schema master keys
- B. Database master keys
- C. Secure view keys
- D. File keys
- E. Account master keys
Answer: D,E
NEW QUESTION # 101
Which stream type can be used for tracking the records in external tables?
- A. Insert-only
- B. Append-only
- C. Standard
- D. External
Answer: A
NEW QUESTION # 102
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
- A. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
- B. The transient table version cannot be retrieved after 24 hours.
- C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
- D. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
Answer: B
NEW QUESTION # 103
What are supported file formats for unloading data from Snowflake? (Choose three.)
- A. Parquet
- B. AVRO
- C. XML
- D. JSON
- E. ORC
- F. CSV
Answer: A,D,F
NEW QUESTION # 104
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 105
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
- A. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
- B. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
- C. A user cannot specify a default warehouse when using the ODBC driver.
- D. The default virtual warehouse size can be changed at any time.
- E. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
Answer: B
NEW QUESTION # 106
Which of the following are options when creating a virtual Warehouse? Choose 2 answers
- A. Auto-suspend
- B. Auto resize
- C. Auto-drop
- D. Auto-resume
Answer: A,D
NEW QUESTION # 107
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
- A. Query execution
- B. Compute resources
- C. Authentication
- D. Metadata
- E. Data storage
Answer: C,D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
* Authentication
* Infrastructure management
* Metadata management
* Query parsing and optimization
* Access control
NEW QUESTION # 108
Which Snowflow object does not consume and storage costs?
- A. Secure view
- B. Transient table
- C. Temporary table
- D. Materialized view
Answer: C
NEW QUESTION # 109
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A. False
- B. True
Answer: B
Explanation:
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.
NEW QUESTION # 110
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. SELECT on tables used by the secure view
- C. CREATE_SHARE on the account
- D. REFERENCE_USAGE on databases
Answer: D
NEW QUESTION # 111
How does Snowflake Fail-safe protect data in a permanent table?
- A. Fail-safe makes data available for 7 days, recoverable by user operations.
- B. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
- C. Fail-safe makes data available up to 1 day, recoverable by user operations.
- D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
Answer: B
NEW QUESTION # 112
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 113
A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.
How will those object names be resolved during execution?
- A. Snowflake will first check the current schema, and them the PUBLIC schema of the current database.
- B. Snowflake will resolve them according to the SEARCH_PATH parameter.
- C. Snowflake will first check the current schema, and then the schema the previous query used
- D. Snowflake will only check the schema the UDF belongs to.
Answer: A
NEW QUESTION # 114
What is a best practice after creating a custom role?
- A. Assign the custom role to the SYSADMIN role
- B. Add_CUSTOM to all custom role names
- C. Create the custom role using the SYSADMIN role.
- D. Assign the custom role to the PUBLIC role
Answer: A
NEW QUESTION # 115
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
- A. The virtual warehouse that is defined at the session level will be used to read all data.
- B. No virtual warehouse will be used, data will be read from the result cache.
- C. No virtual warehouse will be used, data will be read from the local disk cache.
- D. The default virtual warehouse will be used to read all data.
Answer: B
NEW QUESTION # 116
Which of the following terms best describes Snowflake's database architecture?
- A. Columnar shared nothing
- B. Multi-cluster, shared data
- C. Shared disk
- D. Cloud-native shared memory
Answer: B
NEW QUESTION # 117
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
- A. Internal stages
- B. Fail-safe
- C. Time Travel
- D. Zero-copy clones
- E. Incremental backups
Answer: B,C
NEW QUESTION # 118
Which statement describes pruning?
- A. The return of micro-partitions values that overlap with each other to reduce a query's runtime.
- B. The filtering or disregarding of micro-partitions that are not needed to return a query.
- C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.
- D. The ability to allow the result of a query to be accessed as if it were a table.
Answer: B
NEW QUESTION # 119
What happens to the underlying table data when a CLUSTER BY clause is added to a
Snowflake table?
- A. Smaller micro-partitions are created for common data values to allow for more parallelism
- B. Data is hashed by the cluster key to facilitate fast searches for common data values
- C. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
- D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
Answer: D
NEW QUESTION # 120
How would a user execute a series of SQL statements using a task?
- A. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
- B. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
- C. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
- D. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
Answer: B
NEW QUESTION # 121
......
Authentic Best resources for COF-C02 Online Practice Exam: https://www.dumpsvalid.com/COF-C02-still-valid-exam.html
Updates Up to 365 days On Developing COF-C02 Braindumps: https://drive.google.com/open?id=1Y0xIcf70sHTnfwgdRSm1pe7sLQvxSwnz