Free Snowflake ARA-C01 Exam Dumps Questions & Answers

What are characteristics of Dynamic Data Masking? (Select TWO).

• A.  The role that creates the masking policy will always see unmasked data In query results
• B.  A single masking policy can be applied to columns in different tables.
• C.  A masking policy that Is currently set on a table can be dropped.
• D.  A masking policy can be applied to a column with the GEOGRAPHY data type.
• E.  A masking policy can be applied to the value column of an external table.

An Architect wants to create an externally managed Iceberg table in Snowflake.
What parameters are required? (Select THREE).

• A.  Data file path
• B.  External volume
• C.  Metadata file path
• D.  External stage
• E.  Storage integration
• F.  Catalog integration

A company needs to share its product catalog data with one of its partners. The product catalog data is stored in two database tables: product_category, and product_details. Both tables can be joined by the product_id column. Data access should be governed, and only the partner should have access to the records.
The partner is not a Snowflake customer. The partner uses Amazon S3 for cloud storage.
Which design will be the MOST cost-effective and secure, while using the required Snowflake features?

• A.  Create a database user for the partner and give them access to the required data sets.
• B.  Create a reader account for the partner and share the data sets as secure views.
• C.  Use Secure Data Sharing with an S3 bucket as a destination.
• D.  Publish product_category and product_details data sets on the Snowflake Marketplace.

Which parameters can only be set at the account level? (Select TWO).

• A.  TIMESTAMP_INPUT_FORMAT
• B.  ENFORCE_SESSION_POLICY
• C.  DATA_RETENTION_TIME_IN_DAYS
• D.  PERIODIC_DATA_REKEYING
• E.  MAX_CONCURRENCY_LEVEL

What step will im the performance of queries executed against an external table?

• A.  Partition the external table.
• B.  Use an internal stage instead of an external stage to store the source files.
• C.  Convert the source files' character encoding to UTF-8.
• D.  Shorten the names of the source files.