File Info
| Exam | SnowPro Core Recertification |
| Number | COF-R02 |
| File Name | Snowflake.COF-R02.VCEplus.2023-01-09.30q.vcex |
| Size | 17 KB |
| Posted | Jan 09, 2023 |
| Download | Snowflake.COF-R02.VCEplus.2023-01-09.30q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- True
- False
Correct answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Question 2
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.
- More micro-partitions
- Better query scheduling
- Double the numbers of servers In the compute duster
- Higher storage costs
Correct answer: C
Explanation:
Question 3
Which of the following statement is true of Snowflake?
Select one.
- It was built specifically for the cloud
- it was built as an on-premises solution and then potted to the cloud
- It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
- It was built for Hadoop architecture
- It's based on an Oracle Architecture
Correct answer: A
Explanation:
Question 4
The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers
- The complexity of each query
- The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- The size of the data required for each query
- The tool that s executing the query
Correct answer: AC
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Question 5
Which of the following statements would be used to export/unload data from Snowflake?
- COPY INTO @stage
- EXPORT TO @stage
- INSERT INTO @stage
- EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
Correct answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html
Question 6
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
- True
- False
Correct answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html
Question 7
What are the three layers that make up Snowflake's architecture?
Choose 3 answer
- Compute
- Tri-Secret Secure
- Storage
- Cloud Services
Correct answer: ACD
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
Question 8
Which type of table corresponds to a single Snowflake session?
- Temporary
- Translent
- Provisional
- Permanent
Correct answer: A
Explanation:
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.https://docs.snowflake.com/en/user-guide/tables-temptransient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session. Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temptransient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.
Question 9
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
- True
- False
Correct answer: A
Explanation:
Question 10
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
- True
- False
Correct answer: B
Explanation:
