When adding secure views to a share in Snowflake, which function is required to authorize users from another account to access rows in a base table?
Which actions are considered breaking changes to data shared with consumers through the Snowflake Marketplace?
Choose two
C. ompany A uses Snowflake to manage audio files containing call recordings. Company A hired Company B, which also uses Snowflake, to transcribe the audio files for additional analysis.
C. ompany A’s Administrator created a share. What object should be added to the share to give Company B access to the files?
An Administrator must create a sample from the LINEITEM table. The sample must not be repeatable, and the sampling function must select data in blocks of rows.
Which SELECT command generates a sample of 20% of the table?
MY_TABLE is a table that has not been updated or changed for several days. On 01 January 2021 at 07:01, a user ran a query that updated this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries allow the user to view the historical data that was in the table before this query ran?
Choose three
What are the minimum grants needed on the database, schema, and table to correctly create and manage a stream?
Which of the following are characteristics of Dynamic Data Masking?
Choose two
DatabaseA contains one schema, Schema1, which has many tables and views. The ANALYST role has privileges to select from every object in DatabaseA.Schema1. The SYSADMIN role clones DatabaseA as DatabaseA_clone.
Which privileges does the ANALYST role have on tables and views in DatabaseA_clone?
Choose two
A company has configured Snowflake replication between two Snowflake accounts, both running Snowflake Enterprise Edition. Replication applies to database APP_DB, which contains only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently 30 days in both accounts. An Administrator must extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be fulfilled?
A Snowflake Administrator must configure Time Travel for a presentation area containing fact and dimension tables that receives substantial meaningless and erroneous IoT data. Time Travel is part of the company’s data-quality process, where the ingestion pipeline must revert to a known, high-quality data state if anomalies are found in the most recent load. Because of latencies in the data-acquisition process, data from the prior 30 days might need to be retrieved.
|
PDF + Testing Engine
|
|---|
|
$42.5 |
|
Testing Engine
|
|---|
|
$32.5 |
|
PDF (Q&A)
|
|---|
|
$26.25 |
Snowflake Free Exams |
|---|
|