Latest Snowflake ARA-C01 Actual Free Exam Questions & Community Discussion, Page 5

Question #49

A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.
What can be done to improve performance?

A. Alter the target table to include additional fields pulled from the JSON records. This would include a create_date field with a datatype of varchar. When this field is used in the filter, partition pruning will occur.

B. Alter the target table to Include additional fields pulled from the JSON records. This would Include a create_date field with a datatype of time stamp. When this field Is used in the filter, partition pruning will occur.

C. Incorporate the use of multiple tables partitioned by date ranges. When a user or process needs to query a particular date range, ensure the appropriate base table Is used.

D. Validate the size of the warehouse being used. If the record count is approaching 100s of millions, size XL will be the minimum size required to process this amount of data.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #50

Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)

A. Deleting an account

B. Enabling the replication of a database

C. Creating an account

D. Changing the name of an account

E. Changing the name of the organization

F. Viewing a list of organization accounts

Discussion 0

Correct Answer: B,C,F Vote an answer

Question #51

An Architect is designing Snowflake architecture to support fast Data Analyst reporting. To optimize costs, the virtual warehouse is configured to auto-suspend after 2 minutes of idle time. Queries are run once in the morning after refresh, but later queries run slowly.
Why is this occurring?

A. When the warehouse was suspended, the cache was dropped.

B. The warehouse was not created with USE_CACHE = TRUE.

C. The warehouse is not large enough.

D. The warehouse was not configured as a multi-cluster warehouse.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #52

A table contacts_data contains a VARIANT column with nested JSON data.
Which queries correctly retrieve the first name value "Snow"? (Select TWO).

A. SELECT o:Customer.Name.First::STRING FROM contacts_data;

B. SELECT o:['customer']:['name']:['first']::STRING FROM contacts_data;

C. SELECT o[customer][name][first]::STRING FROM contacts_data;

D. SELECT o['customer']['name']['first']::STRING FROM contacts_data;

E. SELECT o:customer.name.first::STRING FROM contacts_data;

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #53

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

A. ENFORCE_SESSION_POLICY

B. DATA_RETENTION_TIME_IN_DAYS

C. MAX_CONCURRENCY_LEVEL

D. TIMESTAMP_INPUT_FORMAT

E. PERIODIC_DATA_REKEYING

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #54

A global company with operations in North America, Europe, and Asia needs to secure its Snowflake environment with a focus on data privacy, secure connectivity, and access control. The company uses AWS and must ensure secure data transfers that comply with regional regulations.
How can these requirements be met? (Select TWO).

A. Configure detailed logging and monitoring of all network traffic using Snowflake native capabilities.

B. Configure network policies to restrict access based on corporate IP ranges.

C. Configure SAML 2.0 to authenticate users in the Snowflake environment.

D. Use public endpoints with SSL encryption to secure data transfers.

E. Use AWS PrivateLink for private connectivity between Snowflake and AWS VPCs.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #55

Which requirements indicate that a multi-account Snowflake strategy should be used? (Select TWO).

A. A requirement to use different Snowflake editions.

B. A requirement to use RBAC to govern DevOps processes across environments.

C. A requirement to minimize complexity of changing database names across environments.

D. A requirement to use Snowflake in a single cloud or region.

E. A requirement for easy object promotion using zero-copy cloning.

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #56

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME.
What is the reason for this?

A. The query has overly complex logic.

B. The query is reading from remote storage.

C. The query is queued for execution.

D. The query is processing a very large dataset.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #57

A Snowflake Architect is designing a multiple-account design strategy.
This strategy will be MOST cost-effective with which scenarios? (Select TWO).

A. The company must use a specific network policy for certain users to allow and block given IP addresses.

B. The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.

C. The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.

D. The company wants to clone a production database that resides on AWS to a development database that resides on Azure.

E. The company needs to support different role-based access control features for the development, test, and production environments.

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #58

What transformations are supported in the below SQL statement? (Select THREE).
CREATE PIPE ... AS COPY ... FROM (...)

A. Columns can be omitted.

B. Incoming data can be joined with other tables.

C. Columns can be reordered.

D. The ON ERROR - ABORT statement command can be used.

E. Data can be filtered by an optional where clause.

F. Type casts are supported.

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #59

How does a standard virtual warehouse policy work in Snowflake?

A. It prevents or minimizes queuing by starting additional clusters instead of conserving credits.

B. It starts only if the system estimates that there is a query load that will keep the cluster busy for at least
6 minutes.

C. It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.

D. It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #60

A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe.
What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?

A. OWNERSHIP on the named pipe, USAGE on the named stage, target database, and schema, and INSERT and SELECT on the target table

B. CREATE on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table

C. USAGE on the named pipe, named stage, target database, and schema, and INSERT and SELECT on the target table

D. OWNERSHIP on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Snowflake ARA-C01 Actual Free Exam Questions & Community Discussion

Download Free Snowflake ARA-C01 Demo