- All Exams Instant Download
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 enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be...
What can be used to view warehouse usage over time? (Select Two).
What can be used to view warehouse usage over time? (Select Two).A . The load HISTORY viewB . The Query history viewC . The show warehouses commandD . The WAREHOUSE_METERING__HISTORY ViewE . The billing and usage tab in the Snowflake web UlView AnswerAnswer: D, E
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
Which of the following compute resources or features are managed by Snowflake? (Select TWO).A . Execute a COPY commandB . Updating dataC . SnowpipeD . AUTOMATIC__CLUSTERINGE . Scaling up a warehouseView AnswerAnswer: A, D
Which of the following describes external functions in Snowflake?
Which of the following describes external functions in Snowflake?A . They are a type of User-defined Function (UDF).B . They contain their own SQL code.C . They call code that is stored inside of Snowflake.D . They can return multiple rows for each row receivedView AnswerAnswer: A Explanation: External functions...
Which data type can be used to store geospatial data in Snowflake?
Which data type can be used to store geospatial data in Snowflake?A . VariantB . ObjectC . GeometryD . GeographyView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point
Which statement about billing applies to Snowflake credits?
Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimumB . Credits are used to pay for cloud data storage usageC . Credits are consumed based on the number of credits billed for each hour that a warehouse runsD . Credits are consumed...
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: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html
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
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...
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?A . Compute layerB . Storage layerC . Cloud infrastructure layerD . Cloud services layerView AnswerAnswer: D
