Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Snowflake SnowPro Advanced Administrator

Snowflake SnowPro Advanced Administrator Exam Practice Questions (P. 2)

  • Full Access (65 questions)
  • One Year of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?
  1. A
    The STORE_ID should be numeric.
  2. B
    The table is not big enough to take advantage of the clustering key.
  3. C
    Sales across stores are not uniformly distributed.
  4. D
    The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

Correct Answer: C ?️

Question #7
Which type of listing in the Snowflake Marketplace can be added and queried immediately?
  1. A
    Monetized listing
  2. B
    Standard listing
  3. C
    Regional listing
  4. D
    Personalized listing

Correct Answer: B ?️

Question #8
An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?
  1. A
    Apply RBAC directly onto the partner's shared secure views.
  2. B
    Individually grant imported privileges onto the schema in the share.
  3. C
    Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.
  4. D
    Create views over the incoming shared database and apply the desired RBAC onto these views.

Correct Answer: D ?️

Question #9
A Snowflake organization MYORG consists of two Snowflake accounts:

The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.
Management wants to have the PROD_DB database replicated to ACCOUNT2.
Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?
  1. A
  2. B
  3. C
    No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.
  4. D
    It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

Correct Answer: B ?️

Question #10
MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries will allow the user to view the historical data that was in the table before this query was executed? (Choose three.)
  1. A
    SELECT * FROM my_table WITH TIME_TRAVEL(OFFSET => -60*30);
  2. B
    SELECT * FROM my_table AT(TIMESTAMP => '2021-01-01 07:00:00'::timestamp);
  3. C
    SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);
  4. D
    SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';
  5. E
    SELECT * FROM my_table AT(OFFSET => -60*30);
  6. F
    SELECT * FROM my_table BEFORE(STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

Correct Answer: BEF ?️

Previous Questions Next Questions

All Pages