Free Access to Snowflake.ARA-C01.v2024-12-26.q155 with Valid Practice Test (Page 12)

Question 51

Snowflake data replication can be used to replicate data between cloud providers.

A.TRUE
B.FALSE

Question 52

You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS.
What feature of Snowflake is the most appropriate to use

A.Materialized View
B.SnowPipe
C.Secure View

Question 53

A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity, an Architect performed the following steps:
* Confirmed Private Link URLs are working by logging in with a username/password account
* Verified DNS resolution by running nslookups against Private Link URLs
* Validated connectivity using SnowCD
* Disabled public access using a network policy set to use the company's IP address range However, the following error message is received when using SSO to log into the company account:
IP XX.XXX.XX.XX is not allowed to access snowflake. Contact your local security administrator.
What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link? (Choose two.)

A.Alter the Azure security integration to use the Private Link URLs.
B.Add the IP address in the error message to the allowed list in the network policy.
C.Generate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.
D.Update the configuration of the Azure AD SSO to use the Private Link URLs.
E.Open a case with Snowflake Support to authorize the Private Link URLs' access to the account.

Question 54

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.
Which actions can the company take with the inbound share? (Choose two.)

A.Clone a table from a share.
B.Grant modify permissions on the share.
C.Create a table from the shared database.
D.Create additional views inside the shared database.
E.Create a table stream on the shared table.

Question 55

Which of the following are characteristics of how row access policies can be applied to external tables?
(Choose three.)

A.An external table can be created with a row access policy, and the policy can be applied to the VALUE column.
B.A row access policy can be applied to the VALUE column of an existing external table.
C.A row access policy cannot be directly added to a virtual column of an external table.
D.External tables are supported as mapping tables in a row access policy.
E.While cloning a database, both the row access policy and the external table will be cloned.
F.A row access policy cannot be applied to a view created on top of an external table.

Correct Answer: A,B,C

Explanation
These three statements are true according to the Snowflake documentation and the web search results. A row access policy is a feature that allows filtering rows based on user-defined conditions. A row access policy can be applied to an external table, which is a table that reads data from external files in a stage. However, there are some limitations and considerations for using row access policies with external tables.
* An external table can be created with a row access policy by using the WITH ROW ACCESS POLICY clause in the CREATE EXTERNAL TABLE statement. The policy can be applied to the VALUE column, which is the column that contains the raw data from the external files in a VARIANT data type1.
* A row access policy can also be applied to the VALUE column of an existing external table by using the ALTER TABLE statement with the SET ROW ACCESS POLICY clause2.
* A row access policy cannot be directly added to a virtual column of an external table. A virtual column is a column that is derived from the VALUE column using an expression. To apply a row access policy to a virtual column, the policy must be applied to the VALUE column and the expression must be repeated in the policy definition3.
* External tables are not supported as mapping tables in a row access policy. A mapping table is a table that is used to determine the access rights of users or roles based on some criteria. Snowflake does not support using an external table as a mapping table because it may cause performance issues or errors4.
* While cloning a database, Snowflake clones the row access policy, but not the external table. Therefore, the policy in the cloned database refers to a table that is not present in the cloned database. To avoid this issue, the external table must be manually cloned or recreated in the cloned database4.
* A row access policy can be applied to a view created on top of an external table. The policy can be applied to the view itself or to the underlying external table. However, if the policy is applied to the view, the view must be a secure view, which is a view that hides the underlying data and the view definition from unauthorized users5.
References:
* CREATE EXTERNAL TABLE | Snowflake Documentation
* ALTER EXTERNAL TABLE | Snowflake Documentation
* Understanding Row Access Policies | Snowflake Documentation
* Snowflake Data Governance: Row Access Policy Overview
* Secure Views | Snowflake Documentation

Question 51

Question 52

Question 53

Question 54

Question 55

Download PDF File