- All Exams Instant Download
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...
What will be recommended approach for deletion?
You want to automatically delete the files from stage after a successful load using the COPY INTO command. What will be recommended approach for deletion?A . Set PURGE=TRUE in the COPY INTO command B. Set REMOVE=TRUE in the COPY INTO Command C. No need to do anything, snowflake does it...
To convert JSON null value to SQL null value, you will use
To convert JSON null value to SQL null value, you will useA . STRIP_NULL_VALUE B. IS_NULL_VALUE C. NULL_IFView AnswerAnswer: A Explanation: STRIP_NULL_VALUE Converts a JSON “null” value to a SQL NULL value. All other variant values are passed unchanged. Please remember this is semi structured data function and is different...
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:
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?A . Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can execute B. Only if the system estimates there’s enough query load...
You can define a clustering key directly on top of VARIANT columns
You can define a clustering key directly on top of VARIANT columnsA . TRUE B. FALSEView AnswerAnswer: B Explanation: You cannot use a VARIANT column in clustering key. However, you can specify an expression to extract value in clustering key.
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....
You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.
You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required. What type of table you will...
What datatype Snowflake will use for EMPLOYEE_ID?
You have created a table as below CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR); What datatype Snowflake will use for EMPLOYEE_ID?A . FIXED B. INTEGER C. NUMBERView AnswerAnswer: A Explanation: Please try this for yourself. Note that this advanced certification requires working experience, so some of these hands-on will help in...
What is the recommended strategy to choose the right sized warehouse to achieve best performance based on query processing?
What is the recommended strategy to choose the right sized warehouse to achieve best performance based on query processing?A . Run homogenous queries on the same warehouse B. Run heterogenous queries on the same warehouseView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#how-does-query-compositio n-impact-warehouse-processing To achieve the best results, try to execute relatively homogeneous...
