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. 1)

  • 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 #1
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?
  1. A
    Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.
  2. B
    Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
  3. C
    Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
  4. D
    Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.

Correct Answer: A ?️

Question #2
Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?
  1. A
  2. B
  3. C
  4. D

Correct Answer: C ?️

Question #3
An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?
  1. A
    Create it as an external table, which will not incur Time Travel costs.
  2. B
    Create it as a transient table with a retention time of 0 days.
  3. C
    Create it as a temporary table with a retention time of 0 days.
  4. D
    Create it as a permanent table with a retention time of 0 days.

Correct Answer: B ?️

Question #4
What are benefits of using Snowflake organizations? (Choose two.)
  1. A
    Administrators can change Snowflake account editions on-demand based on need.
  2. B
    Administrators can monitor and understand usage across all accounts in the organization.
  3. C
    Administrators can simplify data movement across all accounts within the organization.
  4. D
    User administration is simplified across all accounts within the organization.
  5. E
    Administrators have the ability to create accounts in any available cloud provider or region.

Correct Answer: BE ?️

Question #5
What is a characteristic of Snowflake's transaction locking and concurrency modeling?
  1. A
    A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
  2. B
    If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.
  3. C
    Transaction locking in Snowflake is enforced exclusively at the row and table levels.
  4. D
    Queries executed within a given transaction see that transaction's uncommitted changes.

Correct Answer: A ?️

Next Questions

All Pages