Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 251
Which role can create and manage Snowflake accounts?
- A: SYSADMIN
- B: ACCOUNTADMIN
- C: ORGADMIN
- D: SECURITYADMIN
Question 252
Which security feature is available in all Snowflake editions?
- A: Data masking policies
- B: Object-level access control
- C: Object tagging
- D: Customer-managed encryption keys
Question 253
A table named car_sales contains a single VARIANT column named src.
Below is the output of the query SELECT * FROM car_sales;
Which queries will return the element "phone number" from the data? (Choose two.)
- A: SELECT src:customer.’phone number’ FROM car_sales;
- B: SELECT SRC:customer."phone number" FROM car_sales;
- C: SELECT src:customer."phone number" FROM car_sales;
- D: SELECT SRC:customer.phone number FROM car_sales;
- E: SELECT SRC:CUSTOMER."phone number" FROM car_sales;
Question 254
Which strings will be converted to TRUE using the TO_BOOLEAN() or CAST() functions when unloading data? (Choose two.)
- A: 0
- B: n
- C: no
- D: on
- E: yes
Question 255
True or False: You can define multiple columns within a clustering key on a table.
- A: True
- B: False
Question 256
Which authentication method requires access to a secure file that is only stored on the user's local device?
- A: Password authentication
- B: Key-pair authentication
- C: Multi-Factor Authentication (MFA)
- D: Federated authentication
Question 257
Which drivers or connectors are supported by Snowflake? (Choose two.)
- A: Perl Connector
- B: MongoDB Rust Driver
- C: Go Snowflake Driver
- D: Cobol Driver
- E: Snowflake Connector for Python
Question 258
If a source table is updated while cloning is in progress, what data will be included in the cloned table?
- A: All data from the timestamp when the user runs the query.
- B: All data from the timestamp when the user session was created.
- C: All data from the timestamp when the clone statement was initiated.
- D: All data from the timestamp when the clone statement was completed.
Question 259
The CUSTOMER table in the T1 database is accidentally dropped.
Which privileges are required to restore this table? (Choose two.)
- A: SELECT privilege on the CUSTOMER table
- B: OWNERSHIP privilege on the CUSTOMER table
- C: All privileges on the CUSTOMER table
- D: All privileges on the T1 database
- E: CREATE TABLE privilege on the T1 database
Question 260
Which ACCOUNT_USAGE view can be used to identify the masking policy assigned to an object?
- A: ACCESS_HISTORY
- B: OBJECT_DEPENDENCIES
- C: POLICY_REFERENCES
- D: TAG_REFERENCES
Question 261
A stream object will advance its offset when it is used in which statement?
- A: SELECT
- B: INSERT
- C: CREATE
- D: COPY INTO [location]
Question 262
What does an integration between Snowflake and Microsoft Private Link or AWS PrivateLink support?
- A: The isolation of data within a Snowflake account.
- B: The use of Secure Data Sharing among Snowflake accounts.
- C: A Virtual Private Network (VPN) between a user and Snowflake.
- D: A secure, direct connection to Snowflake that does not use the internet.
Question 263
Which type of URL gives permanent access to files in cloud storage?
- A: Pre-signed URL
- B: Account URL
- C: Scoped URL
- D: File URL
Question 264
Which Snowflake data governance feature supports resource usage monitoring?
- A: Data classification
- B: Column lineage
- C: Access history
- D: Object tagging
That’s the end of your free questions
You’ve reached the preview limit for SnowPro CoreConsider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!