ExamGecko
Login
Home / Snowflake / ARA-C01 / List of questions
Ask Question

Snowflake ARA-C01 Practice Test - Questions Answers, Page 7

Add to Whishlist

List of questions

Question 61

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 62

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 63

Report Export Collapse

The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization's system.

What is the BEST way to find recent and ongoing login attempts to Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 64

Report Export Collapse

An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.

What should the Architect do to enable the Snowflake search optimization service on this table?

Become a Premium Member for full access
  Unlock Premium Member

Question 65

Report Export Collapse

A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below:

Snowflake ARA-C01 image Question 65 73052 09232024004401000000

Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses. Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries.

The Architect must design a clustering key for this table to improve the query performance.

Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?

Become a Premium Member for full access
  Unlock Premium Member

Question 66

Report Export Collapse

Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 67

Report Export Collapse

A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate redundancy when managing logins.

What Snowflake functionality should be used to meet these requirements? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 68

Report Export Collapse

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

Become a Premium Member for full access
  Unlock Premium Member

Question 69

Report Export Collapse

What integration object should be used to place restrictions on where data may be exported?

Become a Premium Member for full access
  Unlock Premium Member

Question 70

Report Export Collapse

The following DDL command was used to create a task based on a stream:

Snowflake ARA-C01 image Question 70 73057 09232024004401000000

Assuming MY_WH is set to auto_suspend -- 60 and used exclusively for this task, which statement is true?

Become a Premium Member for full access
  Unlock Premium Member
Total 162 questions
Go to page: of 17
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously. Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)
An Architect needs to improve the performance of reports that pull data from multiple Snowflake tables, join, and then aggregate the data. Users access the reports using several dashboards. There are performance issues on Monday mornings between 9:00am-11:00am when many users check the sales reports. The size of the group has increased from 4 to 8 users. Waiting times to refresh the dashboards has increased significantly. Currently this workload is being served by a virtual warehouse with the following parameters: AUTO-RESUME = TRUE AUTO_SUSPEND = 60 SIZE = Medium What is the MOST cost-effective way to increase the availability of the reports?
An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running. Why is this occurring?
What is a valid object hierarchy when building a Snowflake environment?
An Architect is designing a solution that will be used to process changed records in an orders table. Newly-inserted orders must be loaded into the f_orders fact table, which will aggregate all the orders by multiple dimensions (time, region, channel, etc.). Existing orders can be updated by the sales department within 30 days after the order creation. In case of an order update, the solution must perform two actions: 1. Update the order in the f_0RDERS fact table. 2. Load the changed order data into the special table ORDER _REPAIRS. This table is used by the Accounting department once a month. If the order has been changed, the Accounting team needs to know the latest details and perform the necessary actions based on the data in the order_repairs table. What data processing logic design will be the MOST performant?
A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)
A Snowflake Architect is setting up database replication to support a disaster recovery plan. The primary database has external tables. How should the database be replicated?
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)
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?