- All Exams Instant Download
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)A . UsersB . TablesC . DatabasesD . Internal StagesView AnswerAnswer: B, C, D Explanation: The Information Schema and Account Usage Share in Snowflake provide metadata and historical usage data for various objects...
What is a key feature of Snowflake architecture?
What is a key feature of Snowflake architecture?A . Zero-copy cloning creates a mirror copy of a database that updates with the originalB . Software updates are automatically applied on a quarterly basisC . Snowflake eliminates resource contention with its virtual warehouse implementationD . Multi-cluster warehouses allow users to run...
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . InformaticaB . Power BlC . AdobeD . Data RobotView AnswerAnswer: D Explanation: Data Robot is recognized as a machine learning and data science partner within the Snowflake Partner Ecosystem. It provides an enterprise AI platform...
Where would a Snowflake user find information about query activity from 90 days ago?
Where would a Snowflake user find information about query activity from 90 days ago?A . account__usage . query history viewB . account__usage.query__history__archive ViewC . information__schema . cruery_history viewD . information__schema - query history_by_ses s i on viewView AnswerAnswer: B Explanation: To find information about query activity from 90 days ago,...
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...
