[Aug 07, 2023] Get Free Updates Up to 365 days On Developing ARA-C01 Braindumps [Q111-Q129] : Latest Exam Prep : http://certify.vceprep.com

NEW QUESTION 111
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?

Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can execute

Only if the system estimates there’s enough query load to keep the cluster busy for at least 6 minutes.

Only if the system estimates there’s enough query load to keep the cluster busy for at least 4 minutes.

NEW QUESTION 112
Snowflake recommends starting slowly with SEARCH OPTIMIZATION(i.e. adding search optimization to only a few tables at first) and closely monitoring the costs and benefits.

TRUE

FALSE

NEW QUESTION 113
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the table which they will query using complex aggregation logic. You know that querying with those columns will take a lot of time because the table is not clustered on those columns.
What is the most optimal solution that you will suggest to the business team?

CREATE A MATERIALIZED VIEW AND CLUSTER THE VIEW ON THOSE COLUMNS

CREATE A SECURE VIEW

CREATE A REGULAR VIEW

NEW QUESTION 114
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME() or CURRENT_TIMESTAMP() what will occur?

All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

All rows loaded using a specific COPY statement will have the same timestamp value.

NEW QUESTION 115
Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage cost

Search Optimization Service

Materialized View

Clustering the Table

NEW QUESTION 116
What will the below query return
SELECT TOP 10 GRADES FROM STUDENT;

The top 10 highest grades

The 10 lowest grades

Non-deterministic list of 10 grades

NEW QUESTION 117
When a database gets cloned, what accesses are replicated

All objects in the database and their child objects(schemas, tables etc)

Only the data base object access

Only the child object access

No access gets replicated

NEW QUESTION 118
What does Percentage scanned from cache in the query profile signify?

The percentage of data scanned from the local disk cache

The percentage of data scanned from the METADATA cache

The percentage of data scanned from the QUERY cache

NEW QUESTION 119
How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

A task scheduled in a UTC-based schedule will have no issues with the time changes.

Task schedules can be designed to follow specified or local time zones to accommodate the time changes.

A task will move to a suspended state during the daylight savings time change.

A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

NEW QUESTION 120
One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?

14 hours

2 days

2 hours

24 hours

NEW QUESTION 121
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.)

Define row access policies.

Use the Business Critical edition of Snowflake.

Create a secure view.

Use the Enterprise edition of Snowflake.

Use Dynamic Data Masking.

Create a materialized view.

NEW QUESTION 122
For this object, Snowflake executes code outside Snowflake; the executed code is known as remote service.
What is this object called?

External procedure

External function

External Script

External job

NEW QUESTION 123
Following objects can be cloned in snowflake

Permanent table

Transient table

Temporary table

External tables

Internal stages

NEW QUESTION 124
Search optimization does not support Materialized views and External Tables

TRUE

FALSE

NEW QUESTION 125
How do you refresh a materialized view?

ALTER VIEW <MV_NAME> REFRESH

REFRESH MATERIALIZED VIEW <MV_NAME>

Materialized views are automatically refreshed by snowflake and does not require manual intervention

NEW QUESTION 126
Remote service in external function can be an AWS Lambda function

TRUE

FALSE

NEW QUESTION 127
Below are the rest APIs provided by Snowpipe

insertFiles

insertReport

loadData

NEW QUESTION 128
A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files are added to the cloud provider.
What is the MOST cost-effective way to bring this data into a Snowflake table?

An external table

A pipe

A stream

A copy command at regular intervals

NEW QUESTION 129
Which semi structured data function interprets an input string as a JSON document, producing a VARIANT value.

PARSE_JSON

PARSE_XML

STRIP_JSON