ARA-C01 by Snowflake Actual Free Exam Questions And Answers

Question 1

A Developer is having a performance issue with a Snowflake query. The query receives up to 10 different values for one parameter and then performs an aggregation over the majority of a fact table. It then joins against a smaller dimension table. This parameter value is selected by the different query users when they execute it during business hours. Both the fact and dimension tables are loaded with new data in an overnight import process.
On a Small or Medium-sized virtual warehouse, the query performs slowly. Performance is acceptable on a size Large or bigger warehouse. However, there is no budget to increase costs. The Developer needs a recommendation that does not increase compute costs to run this query.
What should the Architect recommend?

A. Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The query results will then be cached and ready to respond quickly when the users re-issue the query.

B. Enable the search optimization service on the table. When the users execute the query, the search optimization service will automatically adjust the query execution plan based on the frequently-used parameters.

C. Create a dedicated size Large warehouse for this particular set of queries. Create a new role that has USAGE permission on this warehouse and has the appropriate read permissions over the fact and dimension tables. Have users switch to this role and use this warehouse when they want to access this data.

D. Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The task will be scheduled to align with the users' working hours in order to allow the warehouse cache to be used.

Discussion 0

Correct Answer: B Vote an answer

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

Question 2

An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows:
1) Use Tri-Secret Secure in Snowflake
2) Share some information stored in a view with another Snowflake customer
3) Hide portions of sensitive information from some columns
4) Use zero-copy cloning to refresh the non-production environment from the production environment To meet these requirements, which design elements must be implemented? (Choose three.)

A. Use the Enterprise edition of Snowflake.

B. Create a secure view.

C. Use the Business-Critical edition of Snowflake.

D. Use Dynamic Data Masking.

E. Define row access policies.

F. Create a materialized view.

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question 3

An Architect for a multi-national transportation company has a system that is used to check the weather conditions along vehicle routes. The data is provided to drivers.
The weather information is delivered regularly by a third-party company and this information is generated as JSON structure. Then the data is loaded into Snowflake in a column with a VARIANT data type. This table is directly queried to deliver the statistics to the drivers with minimum time lapse.
A single entry includes (but is not limited to):
- Weather condition; cloudy, sunny, rainy, etc.
- Degree
- Longitude and latitude
- Timeframe
- Location address
- Wind
The table holds more than 10 years' worth of data in order to deliver the statistics from different years and locations. The amount of data on the table increases every day.
The drivers report that they are not receiving the weather statistics for their locations in time.
What can the Architect do to deliver the statistics to the drivers faster?

A. Divide the table into several tables for each location by using the location address information from the JSON dataset in order to process the queries in parallel.

B. Create an additional table in the schema for longitude and latitude. Determine a regular task to fill this information by extracting it from the JSON dataset.

C. Divide the table into several tables for each year by using the timeframe information from the JSON dataset in order to process the queries in parallel.

D. Add search optimization service on the variant column for longitude and latitude in order to query the information by using specific metadata.

Discussion 0

Correct Answer: D Vote an answer

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

Question 4

A company uses the COPY INTO <table> command with the following sequence:
* A file is staged on March 1
* The table is loaded on March 2
* On June 30, the company attempts to reload the same file into the same table, but the file is skipped Which options can load the file? (Select TWO).

A. Set the FORCE option to TRUE.

B. Set the PURGE option to TRUE.

C. Set the ALLOW_DUPLICATE option to TRUE.

D. Set the VALIDATION_MODE option to FALSE.

E. Set the LOAD_UNCERTAIN_FILES option to TRUE.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question 5

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. Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.

B. Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.

C. 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.

D. Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.

Discussion 0

Correct Answer: C Vote an answer

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

Question 6

Following objects can be cloned in snowflake

A. Permanent table

B. Internal stages

C. Temporary table

D. External tables

E. Transient table

Discussion 0

Correct Answer: A,D,E Vote an answer

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

Question 7

Which of the below commands will use warehouse credits?

A. SHOW TABLES LIKE 'SNOWFL%';

B. SELECT COUNT(*) FROM SNOWFLAKE;

C. SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

D. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question 8

An Architect needs to meet a company requirement to ingest files from the company's AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company's Snowflake account be initiated? (Select TWO).

A. Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.

B. Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

C. Configure the client application to issue a COPY INTO <TABLE> command to Snowflake when new files have arrived in Amazon S3 Glacier storage.

D. Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.

E. Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

Discussion 0

Correct Answer: B,E Vote an answer

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

Snowflake SnowPro Advanced Architect Certification - ARA-C01 Exam Practice Test

Contact Us

Useful Links

Latest Updated