- All Exams Instant Download
Validation mode can take the below options
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.
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 function
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 disk
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"}
{"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 accountadmin
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...
You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.
You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve. What may be the most possible cause of this.A...
