File Info
| Exam | SnowPro-Core |
| Number | SnowPro-Core |
| File Name | Snowflake.SnowPro-Core.VCEplus.2024-12-04.137q.vcex |
| Size | 465 KB |
| Posted | Dec 04, 2024 |
| Download | Snowflake.SnowPro-Core.VCEplus.2024-12-04.137q.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
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
- GO driver
- Node.js driver
- ODBC driver
- Python connector
- Spark connector
Correct answer: CD
Explanation:
Multi-Factor Authentication (MFA) token caching is typically supported for clients that maintain a persistent connection or session with Snowflake, such as the ODBC driver and Python connector, to reduce the need for repeated MFA challenges.Reference:Based on general security practices in cloud services as of 2021. Multi-Factor Authentication (MFA) token caching is typically supported for clients that maintain a persistent connection or session with Snowflake, such as the ODBC driver and Python connector, to reduce the need for repeated MFA challenges.Reference:Based on general security practices in cloud services as of 2021.
Question 2
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 3
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 4
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 5
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 6
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 7
Which user object property requires contacting Snowflake Support in order to set a value for it?
- DISABLED
- MINS TO BYPASS MFA
- MINS TO BYPASS NETWORK POLICY
- MINS TO UNLOCK
Correct answer: B
Explanation:
The user property 'MINS TO BYPASS MFA' in Snowflake allows temporary bypass of MFA for a user, which can be set by an account administrator without contacting Snowflake Support2. The user property 'MINS TO BYPASS MFA' in Snowflake allows temporary bypass of MFA for a user, which can be set by an account administrator without contacting Snowflake Support2.
Question 8
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 9
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 10
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.
