What is the LEAST-PRIVILEGED role that can enable replication for both source and target accounts by default?

• A.SECURITYADMIN
• B.ACCOUNTADMIN
• C.ORGADMIN
• D.SYSADMIN

Comment: *

Name: *

Email: *

Verification: *

Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

• A.Scaling out
• B.Scaling up
• C.Scaling max
• D.Scaling rhythmically

Comment: *

Name: *

Email: *

Verification: *

How can a 5 GB table be downloaded into a single file MOST efficiently?

• A.Keep the default MAX_FILE_SIZE to 16 MB
• B.Set the default MAX_FILE_SI2E to 5 GB.
• C.Set the SINGLE parameter to TRUE.
• D.Use a regular expression in the stage specifications of the COPY command.

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake technique can be used to improve the performance of a query?

• A.Clustering
• B.Indexing
• C.Fragmenting
• D.Using INDEX__HINTS

Comment: *

Name: *

Email: *

Verification: *

How can a data provider ensure that a data consumer is going to have access to the required objects?

• A.Enable the data sharing feature in the account and validate the view.
• B.Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
• C.Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
• D.Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

Comment: *

Name: *

Email: *

Verification: *