SnowPro Core Certification Exam (COF-C02) Free Questions - Part 10
Question No : 136) Which of the following significantly improves the performance of selective point lookup queries on a table?
A. Clustering
B. Materialized Views
C. Zero-copy Cloning
D. Search Optimization Service
Question No : 137) Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
B. A Data Exchange allows groups of accounts to share data privately among the accounts.
C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
Question No : 138) By default, which Snowflake role is required to create a share?
A. ORGADMIN
B. SECURITYADMIN
C. SHAREADMIN
D. ACCOUNTADMIN
Question No : 139) What internal stages are available in Snowflake? (Choose three.)
A. Schema stage
B. Named stage
C. User stage
D. Stream stage
E. Table stage
F. Database stage
Question No : 140) When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
A. 10-50 MB
B. 100-250 MB
C. 300-500 MB
D. 1000-1500 MB
Question No : 141) A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?
A. Use auto-ingest Snowpipes to load large files in a serverless model.
B. Produce the largest files possible, reducing the overall number of files to process.
C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
D. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
Question No : 142) A user created a new worksheet within the Snowsight Ul and wants to share this with teammates. How can this worksheet be shared?
A. Create a zero-copy clone of the worksheet and grant permissions to teammates
B. Create a private Data Exchange so that any teammate can use the worksheet
C. Share the worksheet with teammates within Snowsight
D. Create a database and grant all permissions to teammates
Question No : 143) What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
A. The shared objects are transferred.
B. The shared objects are copied.
C. The shared objects become accessible.
D. The shared objects can be re-shared.
Question No : 144) User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW. Which command will show all privileges granted to that schema?
A. SHOW GRANTS ON ROLE DATA_SCIENCE
B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
C. SHOW GRANTS TO USER INQUISITIVE_PERSON
D. SHOW GRANTS OF ROLE DATA_SCIENCE
Question No : 145) What is the maximum Time Travel retention period for a temporary Snowflake table?
A. 90 days
B. 1 day
C. 7 days
D. 45 days
Question No : 146) How many resource monitors can be assigned at the account level?
A. 1
B. 2
C. 3
D. 4
Question No : 147) Which of the following can be used when unloading data from Snowflake? (Choose two.)
A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
B. Use the ENCODING file format option to change the encoding from the default UTF-8.
C. The OBJECT_CONSTRUCT function can be used to convert relational data to semistructured data.
D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
Question No : 148) The Snowflake Cloud Data Platform is described as having which of the following architectures?
A. Shared-disk
B. Shared-nothing
C. Multi-cluster shared data
D. Serverless query engine
Question No : 149) What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
A. Reader
B. Consumer
C. Vendor
D. Standard
E. Personalized
Question No : 150) In the Snowflake access control model, which entity owns an object by default?
A. The user who created the object
B. The SYSADMIN role
C. Ownership depends on the type of object
D. The role used to create the object
COF-C02 Answers