ARA-C01 practice questions 131–140

1. Question 131 · 193 in bank

   A company has a very large table that is being queried by two groups. Each group uses unique WHERE clauses in their queries. The first group consistently achieves high-performance results, while the second group experiences poor query performance. Analysis of the Query Profile reveals that the first group’s queries access a limited number of micro-partitions, in contrast to the second group’s queries that scan all micro-partitions in the table. What should be done to ensure that performance is MAXIMIZED for both sets of queries?

   • ACreate a materialized view of the table and assign a cluster key to the view that supports the WHERE clause of the poorly-performing queries.
   • BClone the table and assign a cluster key to the cloned table that supports the WHERE clause of the poorly-performing queries.
   • CModify the table using the CLUSTER BY parameter, including all columns that are referenced in both groups’ WHERE clauses.
   • DHave the second group increase the size of the virtual warehouse when running queries.

   Show answer

   Answer: B

   Next question

2. Question 132 · 193 in bank

   A company has a single Snowflake account for both its production and non-production environments. An Architect needs to design a solution defining the different database layers with a process that also includes a periodic data refresh from production to non-production with data governance in place to protect columns that contain sensitive data. How should the layers be configured, and what process should be followed?

   • ADatabase layers: RAW->Presentation->Integration Schedule tasks that share the identified tables using data sharing from production to non-production. Define Dynamic Data Masking on columns with sensitive data in the production environment, based on the defined roles.
   • BDatabase layers: RAW->Presentation->Integration Schedule tasks that clone the identified tables from production to non-production. Define Dynamic Data Masking on the columns that have sensitive data in the production environment, based on the defined roles.
   • CDatabase layers: RAW->Integration->Presentation Schedule tasks that clone the identified tables from production to non-production. Define Dynamic Data Masking on columns that have sensitive data in the production environment, based on the defined roles.
   • DDatabase layers: RAW->Integration->Presentation Schedule tasks that clone the identified tables from production to non-production. Define row access policies on the columns that have sensitive data in the production environment, based on the defined roles.

   Show answer

   Answer: C

   Next question

3. Question 133 · 193 in bank

   The company, myorg, has multiple Snowflake accounts. An Architect found one of the accounts, account1, does not have replication enabled. Executing which query will enable replication on account1?

   • ASELECT SYSTEM$DISABLE_DATABASE_REPLICATION('myorg.account1'), 'false';
   • BSELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('myorg.account1', 'true');
   • CSELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('myorg.account1', 'SYSTEM$DISABLE_DATABASE_REPLICATION', "false");
   • DSELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('myorg.account1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', "true");

   Show answer

   Answer: D

   Next question

4. Question 134 · 193 in bank

   An account has default settings for all parameters set. The MERGE command is used to update or delete target rows that join multiple source rows. What will be the outcome of the MERGE statement?

   • AAn error will be returned that includes values from one of the target rows that caused the error.
   • BThe merge will complete successfully, and the results of the merge will be nondeterministic.
   • CThe merge will be performed based on the first match of the multiple source rows with the target row.
   • DThe merge will be performed based on the last match of the multiple source rows with the target row.

   Show answer

   Answer: B

   Next question

5. Question 135 · 193 in bank

   Select 3

   An Architect needs to design an architecture that will allow a company to upload small data files from a local directory into a Snowflake internal stage. Which tools should the Architect use to meet this requirement? (Choose three.)

   • AUse the PUT command with the .NET driver.
   • BUse the PUT command with the JDBC driver.
   • CUse the PUT command in SnowSQL.
   • DUse the aws s3 cp in the AWS CLI.
   • EUse the PUT command with the Ruby on Rails driver.
   • FUse Snowsight.

   Show answer

   Answer: ACF

   Next question

6. Question 136 · 193 in bank

   Select 2

   In a managed access schema, what are characteristics of the roles that can manage object privileges? (Choose two.)

   • AUsers with the SYSADMIN role can grant object privileges in a managed access schema.
   • BUsers with the SECURITYADMIN role or higher can grant object privileges in a managed access schema.
   • CUsers who are database owners can grant object privileges in a managed access schema.
   • DUsers who are schema owners can grant object privileges in a managed access schema.
   • EUsers who are object owners can grant object privileges in a managed access schema.

   Show answer

   Answer: BD

   Next question

7. Question 137 · 193 in bank

   A healthcare company needs a data sharing solution that will allow them to collaborate with an insurance company to analyze their patient treatment outcomes and improve service offerings. The solution must have the following requirements: 1. Data can be provided and consumed by both companies. 2. Sensitive data must be protected. 3. A data provider can define how the data consumer interacts with the data through query templates. Which solution will meet these requirements with the LEAST operational overhead?

   • ADirect shares
   • BData Clean Rooms
   • CListings
   • DData Exchange

   Show answer

   Answer: B

   Next question

8. Question 138 · 193 in bank

   An Architect notes that a large table is having poor query performance. The Query Profile shows that the table is accessed by multiple teams within the company. Each team retrieved specific subsets of data using point-lookup queries on different columns. What can be done to ensure that the query is performant for all teams?

   • ABuild multiple materialized views with cluster keys on each column. The teams can access the data by querying the materialized view that meets their requirements.
   • BBuild multiple materialized views with cluster keys on each column. Snowflake will automatically replace the base table with the materialized view that optimizes the query.
   • CUse the search optimization service on the underlying table.
   • DCreate clustering keys using the combination of columns used in the filter and lookup conditions.

   Show answer

   Answer: C

   Next question

9. Question 139 · 193 in bank

   An Architect needs to design a solution for building environments for development, test, and pre-production, all located in a single Snowflake account. The environments should be based on production data. Which solution would be MOST cost-effective and performant?

   • AUse zero-copy cloning into transient tables.
   • BUse zero-copy cloning into permanent tables.
   • CUse CREATE TABLE...AS SELECT (CTAS) statements.
   • DUse a Snowflake task to trigger a stored procedure to copy data.

   Show answer

   Answer: A

   Next question

10. Question 140 · 193 in bank

    Select 2

    An Architect is designing a single account strategy so that all the environments (production, test, and development) reside in the same account for simplified management. What are the advantages of this strategy over a multi-account strategy? (Choose two.)

    • AIt is easy to reference production data during the development cycle.
    • BIt is easy to create secure shares and share them internally within the same account.
    • CObjects may be promoted between environments through the use of zero-copy cloning.
    • DAll objects reside within one account with one set of Role-Based Access Control (RBAC) privileges and one location for all data.
    • EManaging production and non-production environments in the same account eliminates the need to make modifications to the development cycle when promoting code through the environments.

    Show answer

    Answer: CD

    Next question

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

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