ARA-C01 practice questions 171–180

1. Question 171 · 193 in bank

   An Architect has run the following commands:

   

   The catalog_sales table is very large, and the task_wh is a size X-Small. The actual insert statement will take approximately 40 hours. The Architect then executes the following command: EXECUTE TASK insert_task; How long will the insert execute?

   • A1 minute
   • B5 minutes
   • C1 hour
   • D40 hours

   Show answer

   Answer: A

   Next question

2. Question 172 · 193 in bank

   An Architect executes the following statements in order: create table emp(id integer); insert into emp values (1),(2); create temporary table emp(id integer); insert into emp values (1) ; The Architect then executes the following statements: select count(*) from emp; drop table emp; select count(*) from emp; What will be the result?

   • ACOUNT (*) 2 COUNT (*) 1
   • BCOUNT (*) 1 COUNT (*) 2
   • CCOUNT (*) 2 COUNT (*) 2
   • DThe final query will result in an error.

   Show answer

   Answer: D

   Next question

3. Question 173 · 193 in bank

   An Architect is creating a new database role for a team of Data Analysts. The Architect is considering using the OR REPLACE keywords in the CREATE DATABASE ROLE command to ensure the role is created even if it already exists. What should the Architect consider before using the OR REPLACE keywords?

   • AThe dropped database role cannot be recreated.
   • BThe OR REPLACE keywords are unsupported when creating a database role.
   • CRecreating a database role drops it from any shares that it is granted to.
   • DThe database role can only be dropped by a user with a role that has the MANAGE GRANTS privilege.

   Show answer

   Answer: C

   Next question

4. Question 174 · 193 in bank

   An Architect is designing an account strategy that will include hosting Snowflake Notebooks using the Container Runtime environment in Snowpark Container Services. Enabling which Snowflake feature will aggregate the configurations needed to support installation from a Python Package Index (PyPI) package repository over a public network?

   • AOutbound private connectivity
   • BA network rule
   • CExternal access integration
   • DA SECRET

   Show answer

   Answer: C

   Next question

5. Question 175 · 193 in bank

   An Architect is supporting an Internet Protocol Security (IPsec) team to facilitate the management of the user identities that will be used to set up an additional Snowflake environment. The Architect recommended setting up a corporate-wide user identity management system. How can the impact of the new Snowflake environment be MINIMIZED?

   • ASet up Multi-Factor Authentication (MFA) on both the Identity Provider (IdP) and Snowflake.
   • BEnsure that all account-level roles in Snowflake mirror the groups in the Identity Provider (IdP).
   • CSet up user provisioning and federated authentication between Snowflake and the Identity Provider (IdP) using Snowflake integrations.
   • DCreate and manage user identities in Snowflake, using scripts to export user identities and authentication data required by the identity management system.

   Show answer

   Answer: C

   Next question

6. Question 176 · 193 in bank

   An Architect wants to construct an ETL pipeline that reads data from an external stage using an external table. This pipeline will perform multiple transformations on the changed data, incorporate data from dimension tables through joins, and ultimately load the processed data into a target table. What should the Architect do to accomplish this task automatically?

   • AUse streams and tasks.
   • BUse dynamic tables.
   • CUse materialized views.
   • DUse Snowpipe with the auto-ingest option enabled.

   Show answer

   Answer: B

   Next question

7. Question 177 · 193 in bank

   A Snowflake account has the following parameters: 1. MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level. 2. DATA_RETENTION_TIME_IN_DAYS is set to 4 on database DB1, and 6 on Schema1 in Database DB1. 3. DATA_RETENTION_TIME_IN_DAYS is set to 5 on Database DB2, and 8 on Schema2 in Database DB2. What will be the result?

   • ADatabase DB1 and Schema1 will be retained for 5 days. Database DB2 and Schema2 will be retained for 5 days.
   • BDatabase DB1 and Schema1 will be retained for 4 days. Database DB2 and Schema2 will be retained for 5 days.
   • CDatabase DB1 will be retained for 4 days and Schema1 will be retained for 6 days. Database DB2 will be retained for 5 days and Schema2 will be retained for 8 days.
   • DDatabase DB1 will be retained for 5 days and Schema1 will be retained for 6 days. Database DB2 will be retained for 5 days and Schema2 will be retained for 8 days.

   Show answer

   Answer: D

   Next question

8. Question 178 · 193 in bank

   A data ingestion pipeline loads data to a table randomly throughout the day. A requirement states that the data must be processed through a transformation pipeline within 10 minutes from the time that it lands in Snowflake. What is the MOST cost-effective way to meet this requirement?

   • AUse a third-party orchestration tool to execute the transformation pipeline at 5 minute intervals.
   • BCreate a series of views that contain the transformation logic, so that the user can query the views and have access to new data as soon as it arrives.
   • CCreate a task that runs at 5 minute intervals and executes a merge statement that queries the table. Then process any rows that have arrived since the last time the pipeline was executed.
   • DCreate a stream on the landing table. Then create a task to run a transformation pipeline at 5 minute intervals using the SYSTEM$STREAM_HAS_DATA function.

   Show answer

   Answer: D

   Next question

9. Question 179 · 193 in bank

   A company with an account on AWS in the us-east-1 region needs to share data with vendors who also have Snowflake accounts on AWS in the same region. The company maintains non-sensitive data in its database for each vendor. The company does not need to store or track telemetry data from consumer accounts. Which method of data collaboration will allow the company to monetize the data shares and track data usage over time, using the LEAST amount of operational overhead?

   • AA direct share with access granted to all vendor accounts
   • BA data share associated with a paid listing with access granted to all vendor accounts
   • CAn approved application on a paid listing with access granted to all vendor accounts
   • DA reader account with users created for all vendors

   Show answer

   Answer: B

   Next question

10. Question 180 · 193 in bank

    Select 2

    An Architect is defining transaction rules to adhere to ACID (Atomicity, Consistency, Isolation, Durability) properties for a project to ensure that executed statements are either committed or rolled back. Based on this scenario, what characteristics of transactions should be considered? (Choose two).

    • AThe AUTOCOMMIT setting can be changed inside a stored procedure.
    • BExplicit transactions should contain DDL, DML, and query statements.
    • CExplicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.
    • DAn explicit transaction can be started by executing a BEGIN WORK statement and can be ended by executing a COMMIT WORK statement.
    • EAn explicit transaction can be started by executing a BEGIN TRANSACTION statement and can be ended by executing an END TRANSACTION statement.

    Show answer

    Answer: CD

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

ARA-C01 practice, question 171. 193 questions available.