What are characteristics of data replication in Snowflake? (Choose three.)

• A. Users must be granted REPLICATIONADMIN privileges in order to enable replication.
• B. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.
• C. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
• D. Databases created from shares can be replicated.
• E. To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.
• F. Replication can only occur within the same cloud provider.

說明：（僅 Fast2test 成員可見）

What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

• A. Multiple triggers can be configured across various virtual warehouse thresholds.
• B. Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
• C. The cost of running a resource monitor is only 10% of a credit, per day of operation.
• D. Resource monitors add no additional load to virtual warehouse compute.
• E. Resource monitors can be applied to more than one virtual warehouse.
• F. Multiple resource monitors can be applied to a single virtual warehouse.

說明：（僅 Fast2test 成員可見）

An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

• A. Create it as a permanent table with a retention time of 0 days.
• B. Create it as a transient table with a retention time of 0 days.
• C. Create it as a temporary table with a retention time of 0 days.
• D. Create it as an external table, which will not incur Time Travel costs.

說明：（僅 Fast2test 成員可見）

An organization's sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE_NO
FROM CUSTOMERS
WHERE LAST_UPDATED BETWEEN TO_DATE(CURRENT_TIMESTAMP) AND (TO_DATE(CURRENT_TIMESTAMP)-7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

• A. Assign everyone on the sales team to the same virtual warehouse.
• B. Wrap the query in a User-Defined Function (UDF) to match syntax execution.
• C. Leverage the CURRENT_DATE function for date calculations.
• D. Assign everyone on the sales team to the same security role.

說明：（僅 Fast2test 成員可見）

The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD.WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number);
Which role(s) can alter or drop table XYZ?

• A. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
• B. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
• C. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
• D. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.

說明：（僅 Fast2test 成員可見）