ARA-C01

What conditions should be true for a table to consider search optimizationA . The table size is at least 100 GB B. The table is not clustered OR The table is frequently queried on columns other than the primary cluster key C. The table can be of any sizeView AnswerAnswer:...

One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage). What may be the cause of this?A . The amount of memory available for the servers used...

While loading data into a table from stage, which are the valid copyOptionsA . CONTINUE B. SKIP_FILE C. SKIP_FILE_<NUM> D. SKIP_FILE_<NUM>% E. ABORT_STATEMENT F. ERROR_STATEMENTView AnswerAnswer: A,B,C,D,E Explanation:

For this object, Snowflake executes code outside Snowflake; the executed code is known as remote service. What is this object called? A. External procedure B. External function C. External Script D. External jobView AnswerAnswer: B Explanation: An external function calls code that executes outside Snowflake; the executed code is known...

Validation mode can take the below optionsA . RETURN_<n>_ROWS B. RETURN_ERRORS C. RETURN_ALL_ERRORS D. RETURN_SEVERE_EERORS_ONLYView AnswerAnswer: A,B,C Explanation: VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests...

Which semi structured data function interprets an input string as a JSON document, producing a VARIANT value.A . PARSE_JSON B. PARSE_XML C. STRIP_JSONView AnswerAnswer: A Explanation: Try a hands-on exercise to understand this create or replace table vartab (n number(2), v variant); insert into vartab select column1 as n, parse_json(column2)...

Remote service in external function can be an AWS Lambda functionA . TRUE B. FALSEView AnswerAnswer: A Explanation: remote service A remote service is stored and executed outside Snowflake, and returns a value. For example, remote services can be implemented as: An AWS Lambda function. An HTTPS server (e.g. Node.js)...

Bytes spilled to remote storage in query profile indicates volume of data spilled to remote diskA . TRUE B. FALSEView AnswerAnswer: A Explanation: This question may come in various format in the exam, so let us not mug it up. Let us understand what it means. When you run large...

{"stuId":2000,"stuCourse":"Snowflake"} How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2A . with stu_demography as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000, "stuName":"Amy"}')), B. stu_course as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case...

In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadminA . TRUE B. FALSEView AnswerAnswer: A Explanation: Role hierarchy is an important concept that you should read thoroughly. More than one question may appear in the exam on this topic. Please remember in snowflake you cannot...