- All Exams Instant Download
Removing files from a stage after you are done loading the files improves performance when subsequently loading data
Removing files from a stage after you are done loading the files improves performance when subsequently loading dataA . TRUE B. FALSEView AnswerAnswer: A Explanation: Managing Unloaded Data Files Staged files can be deleted from a Snowflake stage using the REMOVE command to remove the files in the stage after...
When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary database
When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary databaseA . TRUE B. FALSEView AnswerAnswer: A Explanation: Replication of clone table replicates the data as well. This increases your data storage cost.
Assigning ACCOUNTADMIN as the default role for the account administrators is a best practice
Assigning ACCOUNTADMIN as the default role for the account administrators is a best practiceA . TRUE B. FALSEView AnswerAnswer: B Explanation: To help prevent account administrators from inadvertently using the ACCOUNTADMIN role to create objects, assign these users additional roles and designate one of these roles as their default (i.e....
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....
