先試後買

A. Enable search optimization on equality predicates for COUNTRY and EMPLOYMENT_STATUS.

B. Build a materialized view for latest active employee records per country.

C. Enable Query Acceleration Service (QAS).

D. Add clustering keys on COUNTRY and EMPLOYMENT_STATUS.

A. Tasks cannot be cloned.

B. The Architect has insufficient privileges to alter tasks on the cloned database.

C. Cloned tasks are suspended by default and must be manually resumed.

D. The objects that the tasks reference are not fully qualified.

A. GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;

B. GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;

C. GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;

D. GRANT ROLE PUBLIC TO ROLE INTERN;

E. GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;

A. The use of a PUT command

B. Submitting multiple SQL statements in a single call

C. The use of a CALL command to a stored procedure which returns a table

D. The use of a GET command

E. The use of a ROLLBACK command

A. The VALIDATION_MODE parameter does not support COPY statements that transform data during a load.

B. The value return_all_errors of the option VALIDATION_MODE is causing a compilation error.

C. The VALIDATION_MODE parameter supports COPY statements that load data from external stages only.

D. The VALIDATION_MODE parameter does not support COPY statements with CSV file formats.

A. Set buffer.flush.time = 1.

B. Maximize the number of micro-partitions.

C. Set buffer.count.records = 1.

D. Set buffer.size.bytes = 10 MB.

A. The consumer role will see the table only after this grant is given on the consumer side:grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;

B. The consumer role will automatically see the new table and no additional grants are needed.

C. The consumer role will see the table only after this grant is given on the provider side:use role accountadmin;grant usage on database EDW to share PSHARE_EDW_4TEST ;grant usage on schema EDW.ACCOUNTING to share PSHARE_EDW_4TEST ;Grant select on table EDW.ACCOUNTING.Table_6 to database PSHARE_EDW_4TEST_DB ;

D. The consumer role will see the table only after this grant is given on the provider side:use role accountadmin;Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;

A. The CHANGES clause

B. The MERGE command

C. A STREAM object

D. The CHANGE_DATA_CAPTURE command

E. The UPSERT command

A. Create a task using Snowflake scripting that will import the files, and then call a User-Defined Function (UDF) to produce the final result set.

B. Use Snowpipe to ingest the two files, then create a materialized view to produce the final result set.

C. Create a JavaScript stored procedure to read. join, and aggregate the data directly from the external stage, and then store the results in a table.

D. Create a materialized view to read, Join, and aggregate the data directly from the external stage, and use the view to produce the final result set

A. The consumer automatically sees the new table.

B. The consumer sees the table after USAGE is granted on the database and schema and SELECT is granted on the table to the consumer database.

C. The consumer sees the table after granting IMPORTED PRIVILEGES again on the consumer side.

D. The consumer sees the table only after SELECT is granted on the new table to the share on the provider side.

A. 1. Ask the customer to create a new Snowflake account in Azure EAST US 2 (Virginia)2. Create a share and add the database privileges to the share3. Alter the share and add the customer's Snowflake account to the share

B. 1. Create a new Snowflake account in Azure East US 2 (Virginia)2. Set up replication between AWS us- west-2 (Oregon) and Azure East US 2 (Virginia) for the database objects to be shared3. Create a share and add the database privileges to the share4. Alter the share and add the customer's Snowflake account to the share

C. 1. Create a reader account in Azure East US 2 (Virginia)2. Create a share and add the database privileges to the share3. Add the reader account to the share4. Share the reader account's URL and credentials with the customer

D. 1. Create a share and add the database privileges to the share2. Create a new listing on the Snowflake Marketplace3. Alter the listing and add the share4. Instruct the customer to subscribe to the listing on the Snowflake Marketplace