- All Exams Instant Download
What tasks can be completed using the copy command? (Select TWO)
What tasks can be completed using the copy command? (Select TWO)A . Columns can be aggregatedB . Columns can be joined with an existing tableC . Columns can be reorderedD . Columns can be omittedE . Data can be loaded without the need to spin up a virtual warehouseView AnswerAnswer:...
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?A . StandardB . PremiumC . EnterpriseD . Business CriticalView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html
Which of the following objects can be shared through secure data sharing?
Which of the following objects can be shared through secure data sharing?A . Masking policyB . Stored procedureC . TaskD . External tableView AnswerAnswer: D Explanation: Secure data sharing in Snowflake allows users to share various objects between Snowflake accounts without physically copying the data, thus not consuming additional storage....
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...
According to recommended best practice, what should be done to reduce the Queue volume?
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse. According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO). A. Use multi-clustered warehousing to scale out...
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 semi-structured file formats are supported when unloading data from a table? (Select TWO).
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).A . ORCB . XMLC . AvroD . ParquetE . JSONView AnswerAnswer: D, E Explanation: Semi-structured JSON, Parquet Snowflake supports unloading data in several semi-structured file formats, including Parquet and JSON. These formats allow for efficient storage...
True or False: A Virtual Warehouse can be resized while suspended.
True or False: A Virtual Warehouse can be resized while suspended.A . TrueB . FalseView AnswerAnswer: A Explanation: Virtual Warehouses in Snowflake can indeed be resized while they are suspended. Resizing a warehouse involves changing the number of compute resources (servers) allocated to it, which can be done to adjust...
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryptionB . An HTTPS server with WebDAVC . A Google Cloud storage bucketD . A Windows server file share on AzureView AnswerAnswer: D...
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...
