What actions are permitted when using the Snowflake SQL REST API? (Select TWO).

• A.The use of a ROLLBACK command
• B.The use of a PUT command
• C.Submitting multiple SQL statements in a single call
• D.The use of a GET command
• E.The use of a CALL command to a stored procedure which returns a table

Comment: *

Name: *

Email: *

Verification: *

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy.
Which requirements will be addressed with this approach? (Choose two.)

• A.There needs to be fewer objects per tenant.
• B.Security and Role-Based Access Control (RBAC) policies must be simple to configure.
• C.Compute costs must be optimized.
• D.Tenant data shape may be unique per tenant.
• E.Storage costs must be optimized.

Comment: *

Name: *

Email: *

Verification: *

What Snowflake features should be leveraged when modeling using Data Vault?

• A.Snowflake's support of multi-table inserts into the data model's Data Vault tables
• B.Data needs to be pre-partitioned to obtain a superior data access performance
• C.Scaling up the virtual warehouses will support parallel processing of new source loads
• D.Snowflake's ability to hash keys so that hash key joins can run faster than integer joins

Comment: *

Name: *

Email: *

Verification: *

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects.
The STAGING schema has 50 days of retention.
The Architect runs the following statement:
CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The Architect receives the following error: Time travel data is not available for schema STAGING. The requested time is either beyond the allowed time travel period or before the object creation time.
The Architect then checks the schema history and sees the following:
CREATED_ON|NAME|DROPPED_ON
2021-06-02 23:00:00 | STAGING | NULL
2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00
How can cloning the STAGING schema be achieved?

• A.Undrop the STAGING schema and then rerun the CLONE statement.
• B.Modify the statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-05-01 10:00:00');
• C.Rename the STAGING schema and perform an UNDROP to retrieve the previous STAGING schema version, then run the CLONE statement.
• D.Cloning cannot be accomplished because the STAGING schema version was not active during the proposed Time Travel time period.

Comment: *

Name: *

Email: *

Verification: *

The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements? (Choose two.)

• A.Consolidate data in the company's data lake and use EXTERNAL TABLES.
• B.Create a raw database for landing and persisting raw data entering the data pipelines.
• C.Create a set of profile-specific databases that aligns data with usage patterns.
• D.Create a single star schema in a single database to support all consumers' requirements.
• E.Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.

Comment: *

Name: *

Email: *

Verification: *