Snowflake ARA-R01 Quiz 1 Topic 1 Questions 1-5

Question: 1

Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)

AThey can include ORDER BY clauses.

BThey cannot include nested subqueries.

CThey can include context functions, such as CURRENT_TIME().

DThey can support MIN and MAX aggregates.

EThey can support inner joins, but not outer joins.

Show Answer

Question: 2

A company has a table with that has corrupted data, named Dat

a. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel.

What command will accomplish this?

ACREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);

BCREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);

CCREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);

DCREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

Show Answer

Question: 3

Following objects can be cloned in snowflake

APermanent table

BTransient table

CTemporary table

DExternal tables

EInternal stages

Show Answer

Question: 4

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEM

AHow can this access be provided?

AGRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER USER_01;

BGRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;

CGRANT ROLE NEW_ROLE TO USER USER_01;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

DGRANT ROLE NEW_ROLE TO USER_01;
GRANT CREATE MATERIALIZED VIEW ON EDW.STG_SCHEMA TO NEW_ROLE;

Show Answer

Question: 5

A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate redundancy when managing logins.

What Snowflake functionality should be used to meet these requirements? (Choose two.)

ASet up replication to allow users to connect from outside the company VPN.

BProvision a unique company Tri-Secret Secure key.

CUse private connectivity from a cloud provider.

DSet up SSO for federated authentication.

EUse a proxy Snowflake account outside the VPN, enabling client redirect for user logins.

Show Answer

Snowflake ARA-R01 Quiz:1 Topic:1 Questions:1-5