- All Exams Instant Download
Data sharing is supported only between provider and consumer accounts in same region
Data sharing is supported only between provider and consumer accounts in same regionA . TRUE B. FALSEView AnswerAnswer: B Explanation: please read the below link https://docs.snowflake.com/en/user-guide/secure-data-sharing-across-regions-plaforms.html
The query profile looks as below. If you would like to further tune the query, what is the best thing to do?
You ran a query and the query SELECT * FROM inventory WHERE BIBNUMBER = 2805127; The query profile looks as below. If you would like to further tune the query, what is the best thing to do? A . Execute the below query to enable auto clustering B. alter table...
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 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...
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...
Refreshing a secondary database is not allowed in the following circumstances
Refreshing a secondary database is not allowed in the following circumstancesA . Materialized views B. Primary database contains transient tables C. Databases created from shares D. Primary database has external tableView AnswerAnswer: C,D Explanation: Creating or refreshing a secondary database is blocked if an external table exists in the primary...
Below are the rest APIs provided by Snowpipe
Below are the rest APIs provided by SnowpipeA . insertFiles B. insertReport C. loadDataView AnswerAnswer: A,B Explanation: Endpoint: insertFiles Informs Snowflake about the files to be ingested into a table. A successful response from this endpoint means that Snowflake has recorded the list of files to add to the table....
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...
