0% Administrator- Free Exam This Snowflake Administrator Free practice exam is designed to provide you with an idea about our content that contains real-like exam questions that need to be completed in 60 minutes. Passing score is 75%. 1 / 10 ADA-3007-5-7 Which Snowflake objects can be managed using SCIM integration? (Select TWO). Shares Users Warehouses Stages Roles Your given answer is wrong. Your given answer is correct. SolutionUsers.Roles. 2 / 10 ADA-3016-12-16 What are characteristics of data replication in Snowflake? (Select THREE). To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account. Databases created from shares can be replicated. Replication can only occur within the same cloud provider. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization. Users must be granted REPLICATIONADMIN privileges in order to enable replication. Your given answer is wrong. Your given answer is correct. SolutionThe ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issuedfrom the primary account.Databases created from shares can be replicated.Users can have unlimited primary databases and they can be replicated to an unlimited number ofaccounts if all accounts are within the same organization. 3 / 10 ADA-3009-6-9 A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directionalsynchronization for user identities. An Administrator with access to SECURITYADMIN uses the SnowflakeUI to create a user by issuing the following commands:use role USERADMIN;create or replace role DEVELOPER_ROLE;create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSEdefault_role = DEVELOPER_ROLE;The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. Whenattempted, the following command fails:use DEVELOPER_ROLE;Why does this command fail? The new role can only take effect after USERADMIN has logged out. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account. Your given answer is wrong. Your given answer is correct. SolutionUSERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER. 4 / 10 ADA-3008-5-8 An Administrator has been asked to support the company's application team need to build a loyalty programfor its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER.CREATE TABLE customer_data (customer_first_name string,customer_last_name string,customer_address string,customer_email string,... some other columns,);The application team would like to access the customer data, but the email field must be obfuscated.How can the Administrator protect the sensitive information, while maintaining the usability of the data? Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view. Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data. Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table. Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data. Your given answer is wrong. Your given answer is correct. SolutionUse the CURRENT_ROLE context function to integrate with a masking policy on the fields that containsensitive data. 5 / 10 ADA-3011-8-11 In general, the monthly billing for database replication is proportional to which variables? (Select TWO). The number and size of warehouses defined in the primary account The frequency of the secondary database refreshes from the primary database The frequency of changes to the primary database as a result of data loading or DML operations The amount of table data in the primary database that changes as a result of data loading or DML operations The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts Your given answer is wrong. Your given answer is correct. SolutionThe frequency of changes to the primary database as a result of data loading or DML operations.The amount of table data in the primary database that changes as a result of data loading or DMLoperations. 6 / 10 ADA-3010-7-10 A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount ofdata from micro-partitions. The same user wants to run another query that uses the same data set.Which action would provide optimal performance for the second SQL query? Prevent the virtual warehouse from suspending between the running of the first and second queries. Use the RESULT_SCAN function to post-process the output of the first query. Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session. Assign additional clusters to the virtual warehouse. Your given answer is wrong. Your given answer is correct. SolutionUse the RESULT_SCAN function to post-process the output of the first query. 7 / 10 ADA-3012-8-12 An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable andthe sampling function should take the data by blocks of rows.What select command will generate a sample of 20% of the table? select * from LINEITEM table sample block (20 rows); select * from LINEITEM sample system (20); select * from LINEITEM table sample system (20) seed (1); select * from LINEITEM sample bernoulli (20); Your given answer is wrong. Your given answer is correct. Solutionselect * from LINEITEM sample system (20); 8 / 10 ADA-3015-11-15 In which scenario will use of an external table simplify a data pipeline? When accessing a Snowflake table that references data files located in cloud storage When accessing a Snowflake table from an external database within the same region When continuously writing data from a Snowflake table to external storage When accessing a Snowflake table from a relational database Your given answer is wrong. Your given answer is correct. SolutionWhen accessing a Snowflake table that references data files located in cloud storage. 9 / 10 ADA-3014-11-14 When a role is dropped, which role inherits ownership of objects owned by the dropped role? The role executing the command The SYSADMIN role The role above the dropped role in the RBAC hierarchy The SECURITYADMIN role Your given answer is wrong. Your given answer is correct. SolutionThe role above the dropped role in the RBAC hierarchy. 10 / 10 ADA-3013-9-13 An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that containsmultiple 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? Individually grant imported privileges onto the schema in the share. Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables. Apply RBAC directly onto the partner's shared secure views. Create views over the incoming shared database and apply the desired RBAC onto these views. Your given answer is wrong. Your given answer is correct. SolutionCreate views over the incoming shared database and apply the desired RBAC onto these views. Your score is 0% Restart quiz Rate this Practice examAppreciate if you spare couple of minutes to give feedback on our quality and your overall experience with us.It will help us to understand and server you better. Send feedback
