SnowPro Core Certification Exam (COF-C02) Free Questions - Part 6
Question No : 76) Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
A. Internal stages
B. Incremental backups
C. Time Travel
D. Zero-copy clones
E. Fail-safe
Question No : 77) What are ways to create and manage data shares in Snowflake? (Select TWO)
A. Through the Snowflake web interface (Ul)
B. Through the DATA_SHARE=TRUE parameter
C. Through SQL commands
D. Through the enable__share=true parameter
E. Using the CREATE SHARE AS SELECT * TABLE command
Question No : 78) A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files. If the user runs the same copy into command what will happen?
A. All data from all of the files on the stage will be appended to the table
B. Only data about new customers from the new files will be appended to the table
C. The operation will fail with the error uncertain files in stage.
D. All data from only the newly-added files will be appended to the table.
Question No : 79) Which of the following are benefits of micro-partitioning? (Select TWO)
A. Micro-partitions cannot overlap in their range of values
B. Micro-partitions are immutable objects that support the use of Time Travel.
C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
D. Rows are automatically stored in sorted order within micro-partitionsE. Micro-partitions can be defined on a schema-by-schema basis
Question No : 80) Which of the following compute resources or features are managed by Snowflake? (Select TWO).
A. Execute a COPY command
B. Updating data
C. Snowpipe
D. AUTOMATIC__CLUSTERING
E. Scaling up a warehouse
Question No : 81) Which copy INTO command outputs the data into one file?
A. SINGLE=TRUE
B. MAX_FILE_NUMBER=1
C. FILE_NUMBER=1
D. MULTIPLE=FAISE
Question No : 82) A user has unloaded data from Snowflake to a stage Which SQL command should be used to validate which data was loaded into the stage?
A. list @file__stage
B. show @file__stage
C. view @file__stage
D. verify @file__stage
Question No : 83) Which of the following can be executed/called with Snowpipe?
A. A User Defined Function (UDF)
B. A stored procedure
C. A single copy_into statement
D. A single insert__into statement
Question No : 84) User-level network policies can be created by which of the following roles? (Select TWO).
A. ROLEADMIN
B. ACCOUNTADMIN
C. SYSADMIN
D. SECURITYADMIN
E. USERADMIN
Question No : 85) Which of the following describes external functions in Snowflake?
A. They are a type of User-defined Function (UDF).
B. They contain their own SQL code.
C. They call code that is stored inside of Snowflake.
D. They can return multiple rows for each row received
Question No : 86) 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. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Question No : 87) 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?
A. Standard
B. Premium
C. Enterprise
D. Business Critical
Question No : 88) What is the minimum Snowflake edition required to create a materialized view?
A. Standard Edition
B. Enterprise Edition
C. Business Critical Edition
D. Virtual Private Snowflake Edition
Question No : 89) A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?
A. Create a task that runs a copy into operation from an external stage every 5 minutes
B. Create a task that puts the files in an internal stage and automate the data loading wizard
C. Create a task that runs a GET operation to intermittently check for new files
D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
Question No : 90) When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
A. A single join node uses more than 50% of the query time
B. Partitions scanned is equal to partitions total
C. An AggregateOperacor node is present
D. The query is spilling to remote storage
COF-C02 Answers