- All Exams Instant Download
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
What happens when a Data Provider revokes privileges to a Share on an object in their source database?A . The object immediately becomes unavailable for all Data Consumers B. Any additional data arriving after this point in time will not be visible to Data Consumers C. The Data Consumers stop...
What is the minimum duration charged when starting a virtual warehouse?
What is the minimum duration charged when starting a virtual warehouse?A . 1 second B. 1 minute C. 1 hour D. 1 dayView AnswerAnswer: B
Which copy INTO command outputs the data into one file?
Which copy INTO command outputs the data into one file?A . SINGLE=TRUE B. MAX_FILE_NUMBER=1 C. FILE_NUMBER=1 D. MULTIPLE=FAISEView AnswerAnswer: B
Which of the following items does the Cloud services Layer manage? Choose 4 answers
Which of the following items does the Cloud services Layer manage? Choose 4 answersA . user authentication B. Metadata C. Query compilation and optimization D. external blob storage E. Data securityView AnswerAnswer: A,B,C,E
How would you determine the size of the virtual warehouse used for a task?
How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution B. Querying (select) the size of the stream content...
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
True or False: Users are able to see the result sets of queries executed by other users that share their same role.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?A . 4 B. 8 C. 16 D. 32View AnswerAnswer: B Explanation: Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:...
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.
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).A . Compute Credits = 50 Credits Cloud Services = 10 B. Compute Credits = 80 Credits Cloud Services = 5 C. Compute Credits = 10 Credits Cloud Services = 9 D. Compute Credits = 120 Credits...
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.A . True B. FalseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/jdbc.html Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed...
