COF-C02 Exam Dumps - SnowPro Core Certification Exam (COF-C02)
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
What is the default character set used when loading CSV files into Snowflake?
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
User-level network policies can be created by which of the following roles? (Select TWO).
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
What SQL command would be used to view all roles that were granted to user.1?
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
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?
What is the difference between a stored procedure and a User-Defined Function (UDF)?
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
What privilege should a user be granted to change permissions for new objects in a managed access schema?
How often are the Account and Table master keys automatically rotated by Snowflake?
Which file format will keep floating-point numbers from being truncated when data is unloaded?
Which command is used to unload files from an internal or external stage to a local file system?
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Which privilege must be granted by one role to another role, and cannot be revoked?
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
Which Snowflake command can be used to unload the result of a query to a single file?
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
What will prevent unauthorized access to a Snowflake account from an unknown source?
Which command is used to start configuring Snowflake for Single Sign-On (SSO)?
Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.
How can this be achieved?
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
CREATE STAGE
COPY INTO
