What type of query will benefit from the query acceleration service?

• A.Queries without filters or aggregation
• B.Queries with large scans and selective filters
• C.Queries where the GROUP BY has high cardinality
• D.Queries of tables that have search optimization service enabled

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.
What should the user do?

• A.Add a clustering key to the table.
• B.Add the search optimization service to the table.
• C.Create a materialized view based on the query.
• D.Enable the query acceleration service for the virtual warehouse.

Comment: *

Name: *

Email: *

Verification: *

The following settings are configured:
THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.
THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.
For how many days will the data be retained at the object level?

• A.2
• B.3
• C.5
• D.7

Comment: *

Name: *

Email: *

Verification: *

A user has 10 files in a stage containing new customer data.
The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

• A.The operation will fail with the error uncertain files in stage.
• B.All data from all of the files on the stage will be appended to the table
• C.Only data about new customers from the new files will be appended to the table
• D.All data from only the newly-added files will be appended to the table.

Comment: *

Name: *

Email: *

Verification: *

Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?

• A.MODIFY, MONITOR and OPERATE privileges
• B.ownership and usage privileges
• C.APPLYBUDGET and audit privileges
• D.MANAGE LISTING ADTOTOLFillment and resolve all privileges

Comment: *

Name: *

Email: *

Verification: *