- All Exams Instant Download
VALIDATION_MODE does not support COPY statements that transform data during a load
VALIDATION_MODE does not support COPY statements that transform data during a loadA . TRUE B. FALSEView AnswerAnswer: A Explanation: VALIDATION_MODE does not support COPY statements that transform data during a load. If the parameter is specified, the COPY statement returns an error. Use the VALIDATE table function to view all...
CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?
You have create a table in snowflake as below CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?A . VARCHAR(10) B. VARCHAR C. VARCHAR(16777216) D. STRINGView AnswerAnswer: C Explanation: Please run these commands in snowflake and...
What may be the cause of this?
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...
Which privilege grants ability to set a Column-level Security masking policy on a table or view column.
Which privilege grants ability to set a Column-level Security masking policy on a table or view column.A . APPLY MASKING POLICY B. APPLY MASK C. ALTER COLUMN MASKView AnswerAnswer: A Explanation: APPLY MASKING POLICY Global Grants ability to set a Column-level Security masking policy on a table or view column....
What will the below query return
What will the below query return SELECT TOP 10 GRADES FROM STUDENT;A . The top 10 highest grades B. The 10 lowest grades C. Non-deterministic list of 10 gradesView AnswerAnswer: C Explanation: An ORDER BY clause is not required; however, without an ORDER BY clause, the results are non-deterministic because...
The insertReport endpoint can be thought of like the UNIX command tail
The insertReport endpoint can be thought of like the UNIX command tailA . TRUE B. FALSEView AnswerAnswer: A Explanation: An event occurs when data from a file submitted via insertFiles has been committed to the table and is available to queries. The insertReport endpoint can be thought of like the...
What conditions should be true for a table to consider search optimization
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:...
What may be the cause of this?
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 copyOptions
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:
What is this object called?
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...