- All Exams Instant Download
What happens when a cloned table is replicated to a secondary database? (Select TWO)
What happens when a cloned table is replicated to a secondary database? (Select TWO)A . A read-only copy of the cloned tables is stored. B. The replication will not be successful. C. The physical data is replicated D. Additional costs for storage are charged to a secondary account E. Metadata...
In which use cases does Snowflake apply egress charges?
In which use cases does Snowflake apply egress charges?A . Data sharing within a specific region B. Query result retrieval C. Database replication D. Loading data into SnowflakeView AnswerAnswer: B Explanation: Snowflake applies egress charges in cases where data is transferred out of Snowflake's infrastructure, such as when retrieving query...
Will the developer be able to modify the table to read the masked data?
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?A . Yes, because a table owner has full control and can unset...
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).A . Load files that are approximately 25 MB or smaller. B. Remove all dates and timestamps. C. Load files that are approximately 100-250 MB (or larger) D. Avoid using embedded characters...
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
Which of the following are true of multi-cluster Warehouses? Select all that apply below.A . A multi-cluster Warehouse can add clusters automatically based on query activity B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity C. A multi-cluster Warehouse can scale down when query activity...
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)A . ROLES B. POLICY_REFERENCES C. QUERY_HISTORY D. RESOURCE_MONIT ORS E. ACCESS_HISTORYView AnswerAnswer: B,E Explanation: To evaluate the details of dynamic data masking in Snowflake, you can use the following account usage views: POLICY_REFERENCES: This view...
True or False: Snowflake supports federated authentication in all editions.
True or False: Snowflake supports federated authentication in all editions.A . True B. FalseView AnswerAnswer: B Explanation: Snowflake supports federated authentication only in the Enterprise and higher editions. Federated authentication allows users to authenticate with Snowflake using their existing identity provider (IdP) credentials, enabling single sign-on (SSO) and simplifying the...
True or False: It is possible to load data into Snowflake without creating a named File Format object.
True or False: It is possible to load data into Snowflake without creating a named File Format object.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
Which of the following terms best describes Snowflake’s database architecture?
Which of the following terms best describes Snowflake’s database architecture?A . Columnar shared nothing B. Shared disk C. Multi-cluster, shared data D. Cloud-native shared memoryView AnswerAnswer: C Explanation: https://www.snowflake.com/product/architecture/ Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency...
Which of the following statements will return the required information?
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?A . SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS; B. SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user()) C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY; D....
