- All Exams Instant Download
Which stage type can be altered and dropped?
Which stage type can be altered and dropped?A . Database stageB . External stageC . Table stageD . User stageView AnswerAnswer: B Explanation: External stages can be altered and dropped in Snowflake. An external stage points to an external location, such as an S3 bucket, where data files are stored....
What is the purpose of an External Function?
What is the purpose of an External Function?A . To call code that executes outside of SnowflakeB . To run a function in another Snowflake databaseC . To share data in Snowflake with external partiesD . To ingest data from on-premises data sourcesView AnswerAnswer: A Explanation: The purpose of an...
Which command can be used to view the list of files that has been uploaded to the staged?
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?A . list @mytable;B . list @%raytable;C . list @ %m.ystage;D . list @mystage;View AnswerAnswer: D Explanation: The command...
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 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...
