- All Exams Instant Download
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)A . SCIMB . Federated authenticationC . TLS 1.2D . Key-pair authenticationE . OAuthF . OCSP authenticationView AnswerAnswer: B, D, E Explanation: Snowflake supports several methods for authenticating users, including federated authentication, key-pair authentication, and...
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: B, D Explanation: To view warehouse usage...
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Which services does the Snowflake Cloud Services layer manage? (Select TWO).A . Compute resourcesB . Query executionC . AuthenticationD . Data storageE . MetadataView AnswerAnswer: C, E Explanation: The Snowflake Cloud Services layer manages a variety of services that are crucial for the operation of the Snowflake platform. Among these...
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.A . TrueB . FalseView AnswerAnswer: B Explanation: Snowflake does not require source data files to be no larger than 16MB. In fact, Snowflake recommends that for optimal load performance, data files should be...
How did Snowflake fulfill this query?
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?A . Query against the result set cacheB . Query against a virtual warehouse cacheC . Query against the most-recently created micro-partitionD . Query against the metadata...
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?A . Create a zero-copy clone of the worksheet and grant permissions to teammatesB . Create a private Data Exchange so that any teammate can use the worksheetC...
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,...
