An Architect with the ORGADMIN role wants to change a Snowflake account from an Enterprise edition to a Business Critical edition.
How should this be accomplished?

• A.Run an ALTER ACCOUNT command and create a tag of EDITION and set the tag to Business Critical.
• B.Use the account's ACCOUNTADMIN role to change the edition.
• C.Failover to a new account in the same region and specify the new account's edition upon creation.
• D.Contact Snowflake Support and request that the account's edition be changed.

Comment: *

Name: *

Email: *

Verification: *

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

• A.A task scheduled in a UTC-based schedule will have no issues with the time changes.
• B.Task schedules can be designed to follow specified or local time zones to accommodate the time changes.
• C.A task will move to a suspended state during the daylight savings time change.
• D.A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.
• E.A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

Comment: *

Name: *

Email: *

Verification: *

How does a standard virtual warehouse policy work in Snowflake?

• A.It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.
• B.It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.
• C.It prevents or minimizes queuing by starting additional clusters instead of conserving credits.
• D.It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.

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: *

Database DB1 has schema S1 which has one table, T1.
DB1 --> S1 --> T1
The retention period of EG1 is set to 10 days.
The retention period of s: is set to 20 days.
The retention period of t: Is set to 30 days.
The user runs the following command:
Drop Database DB1;
What will the Time Travel retention period be for T1?

• A.10 days
• B.20 days
• C.30 days
• D.37 days

Comment: *

Name: *

Email: *

Verification: *