Updated Snowflake COF-C01 Dumps – Check Free COF-C01 Exam Dumps (2023)
Updated COF-C01 exam with Snowflake Real Exam Questions
NEW QUESTION 77
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION 78
What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.
- A. Patching software
- B. Maintaining metadata and statists
- C. Physical security
- D. Installing and configuring hardware
Answer: A,B,D
NEW QUESTION 79
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
- A. True
- B. False
Answer: B
NEW QUESTION 80
What privileges are required to create a task?
- A. The role must have access to the target schema and the create task privilege on the schema itself.
- B. Tasks are created at the Application level and can only be created by the Account Admin role.
- C. The global privilege create task is required to create a new task.
- D. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
Answer: C
NEW QUESTION 81
What command is used to load files into an Internal Stage within Snowflake? Select one.
- A. TRANSFER
- B. COPY INTO
- C. INSERT
- D. PUT
Answer: D
NEW QUESTION 82
How a Snowpipe charges calculated?
- A. Per-second/per Warehouse size
- B. Number of Pipes in account
- C. Per-second/per-core granularity
- D. Total storage bucket size
Answer: C
NEW QUESTION 83
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The queries currently being run by the Virtual Warehouse
- B. The entire Virtual Warehouse
- C. The primary duster in the virtual warehouse
- D. The database the Virtual Warehouse resides in
Answer: B
NEW QUESTION 84
True or False: Snowflake charges a premium for storing semi-structured data.
- A. True
- B. False
Answer: B
NEW QUESTION 85
How would you determine the size of the virtual warehouse used for a task?
- A. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- B. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
- D. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
Answer: C
NEW QUESTION 86
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
- A. Scaling up
- B. Scaling out
- C. Scaling rhythmically
- D. Scaling max
Answer: A
NEW QUESTION 87
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate fluctuations in workload
- B. To accommodate more users
- C. To accommodate a more complex workload
- D. To accommodate more queries
Answer: C
NEW QUESTION 88
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. During a release, new customer requests/queries/connections transparently move over to the newer version
- B. They roll up and release approximately monthly, but customers can request early release application
- C. They happen approximately weekly
- D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
Answer: A,C
NEW QUESTION 89
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. False
- B. True
Answer: B
NEW QUESTION 90
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- A. Via SQL commands
- B. Via Virtual Warehouses
- C. Via the data_share=true parameter
- D. Via the Snowflake Web Interface (Ul)
Answer: A,D
NEW QUESTION 91
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
- A. True
- B. False
Answer: B
NEW QUESTION 92
Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answers
- A. Java
- B. JavaScript
- C. SQL
- D. Python
Answer: B,C
NEW QUESTION 93
Which of the following terms best describes Snowflake's database architecture?
- A. Columnar shared nothing
- B. Multi-cluster, shared data
- C. Shared disk
- D. Cloud-native shared memory
Answer: B
NEW QUESTION 94
What are the three layers that make up Snowflake's architecture? Choose 3 answer
- A. Cloud Services
- B. Storage
- C. Compute
- D. Tri-Secret Secure
Answer: A,B,C
NEW QUESTION 95
True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
- A. True
- B. False
Answer: B
NEW QUESTION 96
Which of the following are options when creating a Virtual Warehouse?
- A. User count
- B. Local SSD size
- C. Auto-suspend
- D. Auto-resume
Answer: C,D
NEW QUESTION 97
Which type of table corresponds to a single Snowflake session?
- A. Translent
- B. Temporary
- C. Provisional
- D. Permanent
Answer: B
NEW QUESTION 98
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers
- A. Information Schema -> TABLE_STORAGE_METRICS
- B. SHOW STORAGE BY TABLE;
- C. Information Schema -> TASLE_HISTORY
- D. SHOW TABLES;
Answer: A,D
NEW QUESTION 99
True or False: You can define multiple columns within a clustering key on a table.
- A. False
- B. True
Answer: B
NEW QUESTION 100
True or False: Fail-safe can be disabled within a Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION 101
......
Actual COF-C01 Exam Recently Updated Questions with Free Demo: https://vceplus.practicevce.com/Snowflake/COF-C01-practice-exam-dumps.html