- All Exams Instant Download
Which of the following statements will accommodate this request?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD; B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING; C. GRANT MODIFY...
If the user runs the same copy into command what will happen?
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer...
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query time B. Partitions scanned is equal to partitions total C. An AggregateOperacor node is present D. The query...
Which command can be used to view the list of files that has been uploaded to the staged?
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?A . list @mytable; B. list @%raytable; C. list @ %m.ystage; D. list @mystage;View AnswerAnswer: D
What are ways to create and manage data shares in Snowflake? (Select TWO)
What are ways to create and manage data shares in Snowflake? (Select TWO)A . Through the Snowflake web interface (Ul) B. Through the DATA_SHARE=TRUE parameter C. Through SQL commands D. Through the enable__share=true parameter E. Using the CREATE SHARE AS SELECT * TABLE commandView AnswerAnswer: C,D
What does the STRIP_OUTER_ARRAY file format do?
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?A . It removes the last element of the outer array. B. It removes the outer array structure and loads...
The fail-safe retention period is how many days?
The fail-safe retention period is how many days?A . 1 day B. 7 days C. 45 days D. 90 daysView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?A . Yes, because a table owner has full control and can unset...
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?A . Pipes B. Streams C. Tasks D. ProceduresView AnswerAnswer: B Explanation: https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20 each%20change.
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.A . True B. FalseView AnswerAnswer: A
