Snowflake COF-C02 Exam Dumps

Snowflake COF-C02 Sample Question Answers

Question # 1

When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

A. 1 hour
B. 2 hours
C. 4 hours
D. 8 hours

Show Answer

Question # 2

If file format options are specified in multiple locations, the load operation selects whichoption FIRST to apply in order of precedence?

A. Table definition
B. Stage definition
C. Session level
D. COPY INTO TABLE statement

Show Answer

Question # 3

How does Snowflake reorganize data when it is loaded? (Select TWO).

A. Binary format
B. Columnar format
C. Compressed format
D. Raw format
E. Zipped format

Show Answer

Question # 4

Which Snowflake database object can be shared with other accounts?

A. Tasks
B. Pipes
C. Secure User-Defined Functions (UDFs)
D. Stored Procedures

Show Answer

Question # 5

Which Snowflake database object can be shared with other accounts?

A. Tasks
B. Pipes
C. Secure User-Defined Functions (UDFs)
D. Stored Procedures

Show Answer

Question # 6

What is the MINIMUM role required to set the value for the parameterENABLE_ACCOUNT_DATABASE_REPLICATION?

A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. ORGADMIN

Show Answer

Question # 7

Which system_defined Snowflake role has permission to rename an account and specifywhether the original URL can be used to access the renamed account?

A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. ORGADMIN

Show Answer

Question # 8

When using SnowSQL, which configuration options are required when unloading data froma SQL query run on a local machine? {Select TWO).

A. echo
B. quiet
C. output_file
D. output_format
E. force_put_overwrite

Show Answer

Question # 9

What value provides information about disk usage for operations where intermediateresults do not fit in memory in a Query Profile?

A. IO
B. Network
C. Pruning
D. Spilling

Show Answer

Question # 10

Which function will provide the proxy information needed to protect Snowsight?

A. SYSTEMADMIN_TAG
B. SYSTEM$GET_PRIVATELINK
C. SYSTEMSALLONTLIST
D. SYSTEMAUTHORIZE

Show Answer

Question # 11

How do secure views compare to non-secure views in Snowflake?

A. Secure views execute slowly compared to non-secure views.
B. Non-secure views are preferred over secure views when sharing data.
C. Secure views are similar to materialized views in that they are the most performant.
D. There are no performance differences between secure and non-secure views.

Show Answer

Question # 12

Which Snowflake layer is associated with virtual warehouses?

A. Cloud services
B. Query processing
C. Elastic memory
D. Database storage

Show Answer

Question # 13

What are characteristics of reader accounts in Snowflake? (Select TWO).

A. Reader account users cannot add new data to the account.
B. Reader account users can share data to other reader accounts.
C. A single reader account can consume data from multiple provider accounts.
D. Data consumers are responsible for reader account setup and data usage costs.
E. Reader accounts enable data consumers to access and query data shared by theprovider.

Show Answer

Question # 14

How does the search optimization service help Snowflake users improve queryperformance?

A. It scans the micro-partitions based on the joins used in the queries and scans only joincolumns.
B. II maintains a persistent data structure that keeps track of the values of the table'scolumns m each of its micro-partitions.
C. It scans the local disk cache to avoid scans on the tables used in the Query.
D. It keeps track of running queries and their results and saves those extra scans on thetable.

Show Answer

Question # 15

Which DDL/DML operation is allowed on an inbound data share?

A. ALTER TA3LE
B. INSERT INTO
C. MERGE
D. SELECT

Show Answer

Question # 16

A view is defined on a permanent table. A temporary table with the same name is createdin the same schema as the referenced table. What will the query from the view return?

A. The data from the permanent table.
B. The data from the temporary table.
C. An error stating that the view could not be compiled.
D. An error stating that the referenced object could not be uniquely identified.

Show Answer

Question # 17

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

A. GROUP BY
B. LIMIT
C. ORDER BY
D. PARTITION BY
E. UNION ALL

Show Answer

Question # 18

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Whichstatements will provide this access?

A. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLEMYROLE;
B. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USERUSER1;
C. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;
D. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Show Answer

Question # 19

What compute resource is used when loading data using Snowpipe?

A. Snowpipe uses virtual warehouses provided by the user.
B. Snowpipe uses an Apache Kafka server for its compute resources.
C. Snowpipe uses compute resources provided by Snowflake.
D. Snowpipe uses cloud platform compute resources provided by the user.

Show Answer

Question # 20

What activities can a user with the ORGADMIN role perform? (Select TWO).

A. Create an account for an organization.
B. Edit the account data for an organization.
C. Delete the account data for an organization.
D. View usage information for all accounts in an organization.
E. Select all the data in tables for all accounts in an organization.

Show Answer

Question # 21

Which Snowflake feature can be used to find sensitive data in a table or column?

A. Masking policies
B. Data classification
C. Row level policies
D. External functions

Show Answer

Question # 22

Which table function should be used to view details on a Directed Acyclic Graphic (DAG)run that is presently scheduled or is executing?

A. TASK_HISTORY
B. TASK_DEPENDENTS
C. CURRENT_TASK_GRAPHS
D. COMPLETE_TASK_GRAPHS

Show Answer

Question # 23

Snowflake's hierarchical key mode includes which keys? (Select TWO).

A. Account master keys
B. Database master keys
C. File keys
D. Secure view keys
E. Schema master keys

Show Answer

Question # 24

What role is required to use Partner Connect?

A. ACCOUNTADMIN
B. ORGADMIN
C. SECURITYADMIN
D. SYSADMIN

Show Answer

Question # 25

How does a Snowflake user extract the URL of a directory table on an external stage forfurther transformation?

A. Use the SHOW STAGES command.
B. Use the DESCRIBE STAGE command.
C. Use the GET_ABSOLUTE_PATH function.
D. Use the GET_STAGE_LOCATION function.

Show Answer

Question # 26

Which role allows a SnowFlake user to view table-level storage utilization information fromthe TABLE_STORAGE_METRICS view by the default?

A. ACCOUNTADMIN
B. SECURYADMIN
C. SYSADMIN
D. USERADMIN

Show Answer

Question # 27

What action can a user take to address query concurrency issues?

A. Enable the query acceleration service.
B. Enable the search optimization service.
C. Add additional clusters to the virtual warehouse
D. Resize the virtual warehouse to a larger instance size.

Show Answer

Question # 28

What SnowFlake database object is derived from a query specification, stored for later use,and can speed up expensive aggregation on large data sets?

A. Temporary table
B. External table
C. Secure view
D. Materialized view

Show Answer

Question # 29

Why would a Snowflake user decide to use a materialized view instead of a regular view?

A. The base tables do not change frequently.
B. The results of the view change often.
C. The query is not resource intensive.
D. The query results are not used frequently.

Show Answer

Question # 30

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualifiedobject names.How will those object names be resolved during execution?

A. Snowflake will resolve them according to the SEARCH_PATH parameter.
B. Snowflake will only check the schema the UDF belongs to.
C. Snowflake will first check the current schema, and then the schema the previous queryused
D. Snowflake will first check the current schema, and them the PUBLIC schema of thecurrent database.

Show Answer

Question # 31

What is a non-configurable feature that provides historical data that Snowflake may recoverduring a 7-day period?

A. Fail-safe
B. Time Travel
C. Cloning
D. Account replication

Show Answer

Question # 32

What are the main differences between the account usage views and the informationschema views? (Select TWO).

A. No active warehouse to needed to query account usage views but one is needed toquery information schema views.
B. Account usage views do not contain data about tables but information schema views do.
C. Account issue views contain dropped objects but information schema views do not.
D. Data retention for account usage views is 1 year but is 7 days to 6 months forinformation schema views, depending on the view.
E. Information schema views are read-only but account usage views are not.

Show Answer

Question # 33

What is one of the characteristics of data shares?

A. Data shares support full DML operations.
B. Data shares work by copying data to consumer accounts.
C. Data shares utilize secure views for sharing view objects.
D. Data shares are cloud agnostic and can cross regions by default.

Show Answer

Question # 34

A user wants to access stored in a stage without authenticating into Snowflake.Which type of URL should be used?

A. File URL
B. Staged URL
C. Scoped URL
D. Pre-signed URL

Show Answer

Question # 35

What is the Fail-safe period for a transient table in the Snowflake Enterprise edition andhigher?

A. 0 days
B. 1 day
C. 7 days
D. 14 days

Show Answer

Question # 36

Which data formats are supported by Snowflake when unloading semi-structured data?(Select TWO).

A. Binary file in Avro
B. Binary file in Parquet
C. Comma-separated JSON
D. Newline Delimited JSON
E. Plain text file containing XML elements

Show Answer

Question # 37

What step can reduce data spilling in Snowflake?

A. Using a larger virtual warehouse
B. Increasing the virtual warehouse maximum timeout limit
C. Increasing the amount of remote storage for the virtual warehouse
D. Using a Common Table Expression (CTE) instead of a temporary table

Show Answer

Question # 38

User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in thesame Snowflake account, wants to view the result set of the query executed by User1using the Snowsight query history.What will happen if User2 tries to access the query history?

A. If User2 has the sysadmin role they will be able to see the results.
B. If User2 has the securityadmin role they will be able to see the results.
C. If User2 has the ACCOUNTADMIN role they will be able to see the results.
D. User2 will be unable to view the result set of the query executed by User1.

Show Answer

Question # 39

When unloading data, which file format preserves the data values for floating-point numbercolumns?

A. Avro
B. CSV
C. JSON
D. Parquet

Show Answer

Question # 40

Which Snowflow object does not consume and storage costs?

A. Secure view
B. Materialized view
C. Temporary table
D. Transient table

Show Answer

Question # 41

A stream can be created on which Snowflake objects to record data manipulationlanguage(DML) changes? (Select TWO).

A. Database
B. Standard tables
C. Standard tables
D. Standard views
E. Schemas
F. Pipes

Show Answer

Question # 42

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

A. A single executable statement can call only two stored procedures. In contrast, a singleSQL statement can call multiple UDFs.
B. A single executable statement can call only one stored procedure. In contrast, a singleSQL statement can call multiple UDFs.
C. A single executable statement can call multiple stored procedures. In contrast, multipleSQL statements can call the same UDFs.
D. Multiple executable statements can call more than one stored procedure. In contrast, asingle SQL statement can call multiple UDFs.

Show Answer

Question # 43

What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

A. The provisioning of new compute resources for the warehouse will begin immediately.
B. The warehouse will remain suspended but new resources will be added to the queryacceleration service.
C. The provisioning of additional compute resources will be in effect when the warehouse isnext resumed.
D. The warehouse will resume immediately and start to share the compute load with otherrunning virtual warehouses.

Show Answer

Question # 44

Which statements describe benefits of Snowflake's separation of compute andstorage?(Select TWO).

A. The separation allows independent scaling of computing resources.
B. The separation ensures consistent data encryption across all virtual data warehouses.
C. The separation supports automatic conversion of semi-structured data into structureddata for advanced data analysis.
D. Storage volume growth and compute usage growth can be tightly coupled.
E. Compote can be scaled up or down without the requirement to add more storage.

Show Answer

Question # 45

What type of account can be used to share data with a consumer who does have a Snowflake account?

A. Data provider
B. Data consumer
C. Reader
D. Organization

Show Answer

Question # 46

What can a user win a reader account do in Snowflake?

A. Load now data
B. Update existing data
C. Create a new snare
D. Query shared data

Show Answer

Question # 47

What is the MAXIMUM Time Travel retention period for a transient table?

A. O days
B. 1 day
C. 7 days
D. 90 days

Show Answer

Question # 48

The VALIDATE table function has which parameter as an input argument for a Snowflakeuser?

A. Last_QUERY_ID
B. CURRENT_STATEMENT
C. UUID_STRING
D. JOB_ID

Show Answer

Question # 49

What are characteristics of transient tables in Snowflake? (Select TWO).

A. Transient tables have a Fail-safe period of 7 days.
B. Transient tables can be cloned to permanent tables.
C. Transient tables persist until they are explicitly dropped.
D. Transient tables can be altered to make them permanent tables.
E. Transient tables have Time Travel retention periods of 0 or 1 day.

Show Answer

Question # 50

What information is found within the Statistic output in the Query Profile Overview?

A. Operator tree
B. Table pruning
C. Most expensive nodes
D. Nodes by execution time

Show Answer

Question # 51

Snowflake users can create a resource monitor at which levels? (Select TWO).

A. User level
B. Pipe level
C. Account level
D. Cloud services level
E. Virtual warehouse level

Show Answer

Question # 52

Which kind of Snowflake table stores file-level metadata for each file in a stage?

A. Directory
B. External
C. Temporary
D. Transient

Show Answer

Question # 53

What consideration should be made when loading data into Snowflake?

A. Create small data files and stage them in cloud storage frequently.
B. Create large data files to maximize the processing overhead for each file.
C. The number of load operations That run in parallel can exceed the number of data filesto be loaded.
D. The number of data files that are processed in parallel is determined by the virtualwarehouse.

Show Answer

Question # 54

Which data types can be used in a Snowflake table that holds semi-structured data?(Select TWO).

A. ARRAY
B. BINARY
C. TEXT
D. VARIANT
E. VARCHAK

Show Answer

Question # 55

How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

A. Set the WAREHOUSES_SIZE to 6XL.
B. Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.
C. Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.
D. Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

Show Answer

Question # 56

What information does the Query Profile provide?

A. Graphical representation of the data model
B. Statistics for each component of the processing plan
C. Detailed Information about I he database schema
D. Real-time monitoring of the database operations

Show Answer

Question # 57

What is the MINIMUM permission needed to access a file URL from an external stage?

A. MODIFY
B. READ
C. SELECT
D. USAGE

Show Answer

Question # 58

Which pages are included in the Activity area of Snowsight? (Select TWO).

A. Contacts
B. Sharing settings
C. Copy History
D. Query History
E. Automatic Clustering History

Show Answer

Question # 59

What does Snowflake's search optimization service support?

A. External tables
B. Materialized views
C. Tables and views that are not protected by row access policies
D. Casts on table columns (except for fixed-point numbers cast to strings)

Show Answer

Question # 60

What happens when a network policy includes values that appear in both the allowed andblocked IP address list?

A. Those IP addresses are allowed access to the Snowflake account as Snowflake appliesthe allowed IP address list first.
B. Those IP addresses are denied access lei the Snowflake account as Snowflake appliesthe blocked IP address list first.
C. Snowflake issues an alert message and adds the duplicate IP address values lo both 'heallowed and blocked IP address lists.
D. Snowflake issues an error message and adds the duplicate IP address values to boththe allowed and blocked IP address list

Show Answer

Question # 61

How does Snowflake handle the bulk unloading of data into single or multiple files?

A. It assigns each unloaded data file a unique name.
B. It uses the put command to download the data by default.
C. It uses COPY INTO <location> for bulk unloading where the default option is SINGLE -TRUE.
D. It uses COPY INTO <location> to copy the data from a table into one or more files in anexternal stage only.

Show Answer