- All Exams Instant Download
Which command can be run to list all shares that have been created in your account or are available to consume by your account
Which command can be run to list all shares that have been created in your account or are available to consume by your accountA . SHOW SHARESB . LIST SHARESC . DESCRIBE SHARESView AnswerAnswer: A Explanation: SHOW SHARES Lists all shares available in the system: Outbound shares (to consumers) that...
Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?
The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?A . The warehouse MY_WH will be made active every five minutes to check the stream.B . The warehouse...
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)A . Extended Time Travel (up to 90 days)B . Customer-managed encryption keys through Tri-Secret SecureC . Periodic rekeying of encrypted dataD . AWS, Azure, or Google Cloud private connectivity to SnowflakeE...
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view usesA . TRUEB . FALSEView AnswerAnswer: A Explanation: A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view...
Which actions can the company take with the inbound share?
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)A . Clone a table from a share.B . Grant modify...
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScan
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScanA . Reading the last 10 minutes of history every 8 minutesB . Read the last 24 hours of history every minuteC . Read the last 7 days of history every hourView AnswerAnswer: A Explanation: This endpoint...
Loading data using snowpipe REST API is supported for external stage only
Loading data using snowpipe REST API is supported for external stage onlyA . TRUEB . FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:
When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)
When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)A . CSVB . XMLC . AvroD . JSONE . ParquetView AnswerAnswer: C,D
How do you validate the data that is unloaded using COPY INTO command
How do you validate the data that is unloaded using COPY INTO commandA . After unloading, load the data into a relational table and validate the rowsB . Load the data into a CSV file to validate the rowsC . Use validation_mode='RETURN_ROWS'; with COPY commandView AnswerAnswer: C Explanation: Validating Data...
How can this query be interpreted?
An Architect runs the following SQL query: How can this query be interpreted?A . FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.B . FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.C . FILEROWS is a file. FILE_ROW_NUMBER is the file format location.D . FILERONS...
