- All Exams Instant Download
Loading data using snowpipe REST API is supported for external stage only
Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:
Which of the below objects cannot be replicated from one region to the other?
Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated
By default, the maximum file size that can be unloaded to a single file in snowflake is
By default, the maximum file size that can be unloaded to a single file in snowflake isA . 10 MB B. 16 MB C. 5 GB for Azure, AWS and GCPView AnswerAnswer: B Explanation: Unloading to a Single File By default, COPY INTO location statements separate table data into a...
For which use cases, will you use cross-cloud and cross-region replication?
For which use cases, will you use cross-cloud and cross-region replication?A . Business continuity and disaster recovery B. Secure data sharing across regions/cloud C. Data portability and account migrations D. All of theseView AnswerAnswer: D Explanation: All of these are uses cases for cross-cloud/region replication
What is the most optimal solution that you will suggest to the business team?
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...
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...
