What are the advantages of using Snowflake organizations?
Choose two
Which statement enables a Snowflake Administrator to retrieve the network policy applied to the Snowflake account?
What is the default data-retention period for transient databases, schemas, and tables in Snowflake Enterprise Edition and higher?
Which are characteristics of data replication in Snowflake?
Choose three
Which benefits result from creating and maintaining resource monitors in Snowflake?
Choose three
A Snowflake customer is incurring higher-than-expected costs while migrating data-warehouse workloads from on premises to Snowflake. The migration workloads run on one warehouse and consist of many small INSERT statements rather than bulk-loading large extracts. That warehouse is configured as a single 2XL cluster because many parallel INSERT statements are scheduled during nightly loads.
How can the Administrator lower costs while minimizing the overall time required to load data-warehouse history?
What requirements apply when creating a new account in a Snowflake organization?
Choose two
The following commands have been run:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?
|
PDF + Testing Engine
|
|---|
|
$42.5 |
|
Testing Engine
|
|---|
|
$32.5 |
|
PDF (Q&A)
|
|---|
|
$26.25 |
Snowflake Free Exams |
|---|
|