SnowPro Core Certification Exam (COF-C02) Free Questions - Part 14
Question No : 196) What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
A. The Pipe load history is reset to empty.
B. The REFRESH command is executed.
C. The stage will be purged.
D. The destination table is truncated.
Question No : 197) What is true about sharing data in Snowflake? (Choose two.)
A. The Data Consumer pays for data storage as well as for data computing.
B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
C. A Snowflake account can both provide and consume shared data.
D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
E. The Data Consumer pays only for compute resources to query the shared data.
Question No : 198) How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?
A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.
Question No : 199) Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
A. Materialized view
B. Sequence
C. Secure view
D. Transient table
E. Clustered table
Question No : 200) For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
A. CHECK_OPTION
B. IS_SECURE
C. IS_UPDATEABLE
D. TABLE_NAME
Question No : 201) How are serverless features billed?
A. Per second multiplied by an automatic sizing for the job
B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account
Question No : 202) How can a row access policy be applied to a table or a view? (Choose two.)
A. Within the policy DDL
B. Within the create table or create view DDL
C. By future APPLY for all objects in a schema
D. Within a control table
E. Using the command ALTER ADD ROW ACCESS POLICY ;
Question No : 203) Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
D. A user cannot specify a default warehouse when using the ODBC driver.
E. The default virtual warehouse size can be changed at any time.
Question No : 204) The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
A. USERADMIN
B. PUBLIC
C. ORGADMIN
D. SYSADMIN
Question No : 205) What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
A. VIEWS_HISTORY
B. OBJECT_HISTORY
C. ACCESS_HISTORY
D. LOGIN_HISTORY
Question No : 206) A single user of a virtual warehouse has set the warehouse to auto-resume and autosuspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed
When the user returns, how much billable compute time will have been consumed?
A. 4 minutes
B. 10 minutes
C. 14 minutes
D. 24 minutes
Question No : 207) Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)
A. Configure the user to be initially disabled.
B. Force an immediate password change.
C. Set a default role for the user.
D. Set the number of minutes to unlock to 15 minutes.
E. Set the user's access to expire within a specified timeframe.
Question No : 208) Which statement MOST accurately describes clustering in Snowflake?
A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
B. Clustering is the way data is grouped together and stored within Snowflake micropartitions.
C. The clustering key must be included in the COPY command when loading data into Snowflake.
D. Clustering can be disabled within a Snowflake account.
Question No : 209) 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 schema.
B. Grant the OWNERSHIP privilege on the database.
C. Grant the MANAGE GRANTS global privilege.
D. Grant ALL privileges on the schema.
Question No : 210) How often are the Account and Table master keys automatically rotated by Snowflake?
A. 30 Days
B. 60 Days
C. 90 Days
D. 365 Days.
COF-C02 Answers