ARA-C01 무료 덤프문제 온라인 액세스

Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?

• A.External table
• B.Search optimization
• C.Result cache
• D.Materialized view

Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

• A.Choose columns that are frequently used in join predicates.
• B.Choose cluster columns that are most actively used in selective filters.
• C.Choose lower cardinality columns to support clustering keys and cost effectiveness.
• D.Choose cluster columns that are actively used in the GROUP BY clauses.
• E.Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.

A group of Data Analysts have been granted the role analyst role. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data.
How should these requirements be met?

• A.Make every schema in the database a managed access schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.
• B.Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.
• C.Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.
• D.Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?

• A.Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
• B.Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
• C.All rows loaded using a specific COPY statement will have the same timestamp value.
• D.All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

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