File Info
| Exam | SnowPro-Core |
| Number | SnowPro-Core |
| File Name | Snowflake.SnowPro-Core.VCEplus.2024-11-24.108q.tqb |
| Size | 753 KB |
| Posted | Nov 24, 2024 |
| Download | Snowflake.SnowPro-Core.VCEplus.2024-11-24.108q.tqb |
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
What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?
- Swift
- JavaScript
- Python
- SQL
Correct answer: C
Explanation:
The Snowpark API allows developers to create User-Defined Functions (UDFs) in various languages, including Python, which is known for its ease of use and wide adoption in data-related tasks.Reference:Based on general programming and cloud data service knowledge as of 2021. The Snowpark API allows developers to create User-Defined Functions (UDFs) in various languages, including Python, which is known for its ease of use and wide adoption in data-related tasks.Reference:Based on general programming and cloud data service knowledge as of 2021.
Question 2
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
- Bytes scanned
- Bytes written to result
- Partitions scanned
- Partitions total
- Percentage scanned from cache
Correct answer: CD
Explanation:
The statistics that can be used to identify queries with inefficient pruning are 'Partitions scanned' and 'Partitions total'.These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34. The statistics that can be used to identify queries with inefficient pruning are 'Partitions scanned' and 'Partitions total'.These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.
Question 3
Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
- INTEGER
- OBJECT
- VARIANT
- VARCHAR
- LIST
Correct answer: BC
Explanation:
The Snowflake data types that can be used to build nested hierarchical data are OBJECT and VARIANT.These data types support the storage and querying of semi-structured data, allowing for the creation of complex, nested data structures The Snowflake data types that can be used to build nested hierarchical data are OBJECT and VARIANT.These data types support the storage and querying of semi-structured data, allowing for the creation of complex, nested data structures
Question 4
What is the name of the SnowSQLfile that can store connection information?
- history
- config
- snowsqLcnf
- snowsql.pubkey
Correct answer: B
Explanation:
The SnowSQL file that can store connection information is named 'config'. It is used to store user credentials and connection details for easy access to Snowflake instances.Reference:Based on general database knowledge as of 2021. The SnowSQL file that can store connection information is named 'config'. It is used to store user credentials and connection details for easy access to Snowflake instances.Reference:Based on general database knowledge as of 2021.
Question 5
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
- Duo Security
- OAuth
- Okta
- Single Sign-On (SSO)
Correct answer: A
Explanation:
Snowflake provides Multi-Factor Authentication (MFA) support as an integrated feature, powered by the Duo Security service.This service is managed completely by Snowflake, and users do not need to sign up separately with Duo1 Snowflake provides Multi-Factor Authentication (MFA) support as an integrated feature, powered by the Duo Security service.This service is managed completely by Snowflake, and users do not need to sign up separately with Duo1
Question 6
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
- Cloud Services
- Database Storage
- Query Processing
- Metadata Management
Correct answer: B
Explanation:
Snowflake reorganizes data into its internal optimized, compressed, columnar format in the Database Storage layer.This process is part of how Snowflake manages data storage, ensuring efficient data retrieval and query performance Snowflake reorganizes data into its internal optimized, compressed, columnar format in the Database Storage layer.This process is part of how Snowflake manages data storage, ensuring efficient data retrieval and query performance
Question 7
What can a Snowflake user do in the Admin area of Snowsight?
- Analyze query performance.
- Write queries and execute them.
- Provide an overview of the listings in the Snowflake Marketplace.
- Connect to Snowflake partners to explore extended functionality.
Correct answer: A
Explanation:
In the Admin area of Snowsight, users can analyze query performance, manage Snowflake warehouses, set up and view details about resource monitors, manage users and roles, and administer Snowflake accounts in their organization2. In the Admin area of Snowsight, users can analyze query performance, manage Snowflake warehouses, set up and view details about resource monitors, manage users and roles, and administer Snowflake accounts in their organization2.
Question 8
How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
- Create a view.
- Cluster a table.
- Enable the search optimization service.
- Enable Time Travel.
- Index a table.
Correct answer: BC
Explanation:
To optimize query performance in Snowflake, users can cluster a table, which organizes the data in a way that minimizes the amount of data scanned during queries.Additionally, enabling the search optimization service can improve the performance of selective point lookup queries on large tables34. To optimize query performance in Snowflake, users can cluster a table, which organizes the data in a way that minimizes the amount of data scanned during queries.Additionally, enabling the search optimization service can improve the performance of selective point lookup queries on large tables34.
Question 9
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?
- Yes, because a table owner has full control and can unset masking policies.
- Yes, because masking policies only apply to cloned tables.
- No, because masking policies must always reference specific access roles.
- No, because ownership of a table does not include the ability to change masking policies
Correct answer: D
Explanation:
Even if a developer is granted ownership of a table with a masking policy, they will not be able to modify the table to read the masked data if their role does not have the necessary permissions. Ownership of a table does not automatically confer the ability to alter masking policies, which are designed to protect sensitive data.Masking policies are applied at the schema level and require specific privileges to modify12.[COF-C02] SnowPro Core Certification Exam Study GuideSnowflake Documentation on Masking Policies Even if a developer is granted ownership of a table with a masking policy, they will not be able to modify the table to read the masked data if their role does not have the necessary permissions. Ownership of a table does not automatically confer the ability to alter masking policies, which are designed to protect sensitive data.Masking policies are applied at the schema level and require specific privileges to modify12.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Masking Policies
Question 10
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
- Informatica
- Power Bl
- Adobe
- Data Robot
Correct answer: D
Explanation:
Data Robot is recognized as a machine learning and data science partner within the Snowflake Partner Ecosystem. It provides an enterprise AI platform that enables users to build and deploy accurate predictive models quickly.As a partner, Data Robot integrates with Snowflake to enhance data science capabilities2.[COF-C02] SnowPro Core Certification Exam Study GuideSnowflake Documentation on Machine Learning & Data Science Partnershttps://docs.snowflake.com/en/user-guide/ecosystem-analytics.html Data Robot is recognized as a machine learning and data science partner within the Snowflake Partner Ecosystem. It provides an enterprise AI platform that enables users to build and deploy accurate predictive models quickly.As a partner, Data Robot integrates with Snowflake to enhance data science capabilities2.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Machine Learning & Data Science Partners
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html
