Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 226
How can a Data Exchange Administrator provide a user with account access to a Data Exchange?
- A: Grant the user the USERADMIN role.
- B: Add the user to the Data Exchange.
- C: Enable the IMPORT SHARE privilege and grant this privilege to the user.
- D: Create a new database for the Data Exchange and provide access to the user.
Question 227
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A: Users
- B: Tables
- C: Databases
- D: Internal Stages
Question 228
Which features can be used with the Snowflake Standard edition? (Choose two.)
- A: Materialized views
- B: External functions
- C: Multi-cluster virtual warehouses
- D: Fail-safe
- E: Row-level security
Question 229
What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the COPY INTO [location] command used during data unloading? (Choose two.)
- A: Single quote character (')
- B: NULL
- C: 'NULL'
- D: NONE
- E: 'NONE'
Question 230
What identifiers are supported when creating a Snowflake account hostname? (Choose two.)
- A: Cloud region
- B: Snowflake domain
- C: Account name
- D: Account locator
- E: Account cloud platform
Question 231
Which virtual warehouse auto-suspend configurations will result in a warehouse that runs continually, 24 hours a day, 7 days a week? (Choose two.)
- A: −1
- B: 0
- C: 86400
- D: 172800
- E: NULL
Question 232
What kind of value does a User-Defined Function (UDF) return? (Choose two.)
- A: Dictionary
- B: List
- C: Object
- D: Scalar
- E: Tabular
Question 233
Which database objects can be shared with Secure Data Sharing? (Choose two.)
- A: Views
- B: Materialized views
- C: External stages
- D: External tables
- E: Dynamic tables
Question 234
When a transient table in Snowflake is dropped, what happens to the table?
- A: The table is no longer available for use.
- B: The table can be undropped using Fail-safe.
- C: The table can be recovered for 1 day only and after that it is no longer available.
- D: The table can be recovered only with the assistance of Snowflake Support.
Question 235
A data provider needs to securely collaborate with data consumers who do not reside in the same region.
What Snowflake sharing mechanism should be used?
- A: Direct share
- B: Data Exchange
- C: Data replication
- D: Listing
Question 236
What is the default File Format used in the COPY command if one is not specified?
- A: CSV
- B: JSON
- C: Parquet
- D: XML
Question 237
A user needs to know the maximum value of a date field in a table, and runs the following query:
select max(o_orderdate) from ORDERS;
Which part of Snowflake architecture will this query use?
- A: Database Storage
- B: Query Processing
- C: Cloud Services
- D: Compute
Question 238
When cloning a schema, which Snowflake object will not be included in the clone?
- A: An external stage
- B: A named internal stage
- C: A task
- D: A User-Defined Function (UDF)
Question 239
Which command will change the name of shared database role r1 to r4?
- A: ALTER ROLE d1.r1 RENAME TO d1.r4;
- B: ALTER ROLE d1.r1 RENAME TO d2.r4;
- C: ALTER DATABASE ROLE d1.r1 RENAME TO d2.r4;
- D: ALTER DATABASE ROLE d1.r1 RENAME TO d1.r4;
Question 240
What does the Remote Disk I/O statistic in the Query Profile indicate?
- A: Time spent reading from the result cache.
- B: Time spent reading from the virtual warehouse cache.
- C: Time when the query processing was blocked by remote disk access.
- D: The level of network activity between the Cloud Services layer and the virtual warehouse.
Question 241
Which role has the privileges to describe a share?
- A: ORGADMIN
- B: SECURITYADMIN
- C: SYSADMIN
- D: ACCOUNTADMIN
Question 242
This command is executed:
CREATE TABLE new_table CLONE existing_table COPY GRANT;
What will happen to the privileges of any cloned objects?
- A: The clone will only inherit SELECT privileges from the source object.
- B: The clone will inherit all privileges, including OWNERSHIP, from the source object.
- C: The clone will inherit all privileges except OWNERSHIP from the source object.
- D: The clone will not inherit any privileges from the source object.
Question 243
Where does Snowflake store the data output from a query that was executed in the past 24 hours?
- A: In a micro-partition
- B: In a remote disk
- C: In the result cache layer
- D: In the local disk cache layer
Question 244
What is the default authenticator while using the JDBC driver connection in Snowflake?
- A: externalbrowser
- B: snowlake
- C: username_password_mfa
- D: snowflake_jwt
Question 245
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A: True
- B: False
Question 246
When will Snowflake charge credits for the use of the Cloud Services layer?
- A: Credits will be charged whenever the Cloud Services layer is used.
- B: Credits will be charged only when running a Snowflake-provisioned compute warehouse COMPUTE_WH.
- C: Credits will be charged when the daily consumption of cloud services resources exceeds 10% of the daily warehouse usage.
- D: Credits will be charged only when a virtual warehouse consumes serverless compute services.
Question 247
How can the performance of queries run on external tables be optimized?
- A: Cluster the tables
- B: Create materialized views on the tables
- C: Use the metadata cache
- D: Enable the search optimization service
Question 248
What are the recommended alternative data types in Snowflake for unsupported large object data types such as BLOB and CLOB? (Choose two.)
- A: VARIANT
- B: ARRAY
- C: BINARY
- D: OBJECT
- E: VARCHAR
Question 249
A network policy set at which level will override all other network policies?
- A: Account
- B: User
- C: Security integration
- D: Database
Question 250
A company needs to share sales data with multiple marketing agency partners.
Which Snowflake data share mechanism is recommended for this use case?
- A: A shared Amazon S3 bucket
- B: Direct share
- C: A reader account
- D: Data Exchange
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!