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 Architect

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

  • Full Access (109 questions)
  • Six months 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 user has the appropriate privilege to see unmasked data in a column.
If the user loads this column data into another column that does not have a masking policy, what will occur?
  1. A
    Unmasked data will be loaded in the new column.
  2. B
    Masked data will be loaded into the new column.
  3. C
    Unmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data.
  4. D
    Unmasked data will be loaded into the new column and no users will be able to see the unmasked data.

Correct Answer:
A

Question #7
How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?
  1. A
    Create multiple clustering keys for a table.
  2. B
    Create multiple materialized views with different cluster keys.
  3. C
    Create super projections that will automatically create clustering.
  4. D
    Create a clustering key that contains all columns used in the access paths.

Correct Answer:
B

Question #8
Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A.
What is required to allow data sharing between these two companies?
  1. A
    Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
  2. B
    Ensure that all views are persisted, as views cannot be shared across cloud platforms.
  3. C
    Setup data replication to the region and cloud platform where the consumer resides.
  4. D
    Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.

Correct Answer:
C

Question #9
What are some of the characteristics of result set caches? (Choose three.)
  1. A
    Time Travel queries can be executed against the result set cache.
  2. B
    Snowflake persists the data results for 24 hours.
  3. C
    Each time persisted results for a query are used, a 24-hour retention period is reset.
  4. D
    The data stored in the result cache will contribute to storage costs.
  5. E
    The retention period can be reset for a maximum of 31 days.
  6. F
    The result set cache is not shared between warehouses.

Correct Answer:
BCE

Question #10
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)
  1. A
    Changing the name of the organization
  2. B
    Creating an account
  3. C
    Viewing a list of organization accounts
  4. D
    Changing the name of an account
  5. E
    Deleting an account
  6. F
    Enabling the replication of a database

Correct Answer:
BDE

Previous Questions Next Questions

All Pages