ADA-C01 Exam Questions
88 real ADA-C01 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1Delivery Configuration and Management
What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?
OAuth 2.0ACCOUNTADMIN rolesecurity integrationaccess control - Question #2Account Management and Security
The following SQL command was executed: Use role SECURITYADMIN; Grant ownership On future tables In schema PROD. WORKING To role PROD_WORKING_OWNER; Grant role PROD_WORKING_OWNER t...
future grantsownershiprole hierarchytable privileges - Question #3Account Management and Security
What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)
organization accountsaccount creationaccount namingORGADMIN - Question #4Resource Management and Cost Optimization
A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been d...
warehouse sizingmulti-cluster warehousesmall INSERTscost optimization - Question #5Data Sharing and Collaboration
What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Choose two.)
Data ExchangeIMPORT SHAREconsumer accountACCOUNTADMIN - Question #6Data Sharing and Collaboration
An Administrator wants to delegate the administration of a company's data exchange to users who do not have access to the ACCOUNTADMIN role. How can this requirement be met?
data exchangeprivilege delegationMODIFY privilegerole management - Question #7Disaster Recovery and Business Continuity
A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP...
Time Traveldata replicationretention policysecondary database - Question #8Resource Management and Cost Optimization
When does auto-suspend occur for a multi-cluster virtual warehouse?
multi-cluster warehouseauto-suspendminimum clusterswarehouse management - Question #9Account Management and Security
A company has set up a new Snowflake account. An Identity Provider (IdP) has been configured for both Single Sign-On (SSO) and SCIM provisioning. What maintenance is required to en...
SCIM provisioningOAuth Bearer TokenSSOIdentity Provider - Question #10Resource Management and Cost Optimization
What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)
resource monitorscredit quotatrigger thresholdswarehouse governance - Question #11Data and Access Management
DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA. Schema1. The SYSA...
database cloningprivilege inheritancesecure viewsRBAC - Question #12Resource Management and Cost Optimization
An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perfor...
resource monitorcredit quotatrigger configurationwarehouse suspension - Question #13Data Sharing and Collaboration
A data provider wants to share data from multiple databases with a data consumer account. How can this be accomplished?
multi-database sharingREFERENCE_USAGEsecure viewsdata provider - Question #14Data Sharing and Collaboration
A requirement has been identified to allow members of a corporate Data Product team to bring in data sets from the Snowflake Marketplace. The members of this team use the role DP_T...
Snowflake MarketplaceIMPORT SHARErole privilegesdata consumer - Question #15
The following commands were executed: Grant usage on database PROD to role PROD_ANALYST; Grant usage on database PROD to role PROD_SUPERVISOR; Grant ALL PRIVILEGES on schema PROD....
- Question #16Data and Access Management
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...
inbound sharingRBAC on shared viewssecure viewsaccess control - Question #17Disaster Recovery and Business Continuity
What are characteristics of data replication in Snowflake? (Choose three.)
database replicationENABLE REPLICATIONcross-account replicationshared databases - Question #18Data and Access Management
An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or st...
task privilegesOPERATE privilegetask managementschema USAGE - Question #19Disaster Recovery and Business Continuity
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...
database replicationORGADMINENABLE REPLICATION TO ACCOUNTScross-account setup - Question #20Performance Monitoring and Tuning
What is a characteristic of Snowflake's transaction locking and concurrency modeling?
transaction lockingconcurrencydeadlock preventionMVCC - Question #21Account Management and Security
A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows: USE ROLE SECURITYADMIN; CREATE ROLE ROLE_MANAGED_ACCESS; GRANT ROLE ROLE...
managed access schemaALTER SCHEMASECURITYADMINdisable managed access - Question #22Account Management and Security
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)
ORGADMINACCOUNTADMINorganization managementcross-account privileges - Question #23Account Management and Security
Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?
MFA bypassALTER USERauthenticationMINS_TO_BYPASS_MFA - Question #24Performance Monitoring and Tuning
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database. For this warehouse, why should the Adm...
AUTO_SUSPENDdata cachevirtual warehousedashboard performance - Question #25Account Management and Security
What SCIM integration types are supported in Snowflake? (Choose three.)
SCIMidentity provisioningOktaAzure AD - Question #26Data and Access Management
A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements: USE ROLE SECURITYADMIN;...
future grantsschema privilegesrole hierarchyaccess control - Question #27Data Sharing and Collaboration
A large international company with many operating regions requires data to be shared bi- directionally among all offices (head office to regional offices and regional offices among...
data replicationcross-cloud sharingbi-directional sharingPII compliance - Question #28Account Management and Security
What are benefits of using Snowflake organizations? (Choose two.)
Snowflake organizationsmulti-account managementcloud regionsusage monitoring - Question #29Account Management and Security
A Snowflake account is configured with SCIM provisioning for user accounts and has bi- directional synchronization for user identities. An Administrator with access to SECURITYADMI...
SCIM provisioningrole grantsUSERADMINuser provisioning - Question #30Data Sharing and Collaboration
Which type of listing in the Snowflake Marketplace can be added and queried immediately?
Snowflake Marketplacelisting typesstandard listingdata sharing - Question #31Resource Management and Cost Optimization
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant. An application with the accountant role should...
warehouse privilegesMONITORUSAGEcompute credits - Question #32Data and Access Management
What is required for stages, without credentials, to limit data exfiltration after a storage integration and associated stages are created?
storage integrationdata exfiltrationstagesALTER ACCOUNT - Question #33Performance Monitoring and Tuning
A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the maximum num...
multi-cluster warehousequery optimizationwarehouse scalingcluster limits - Question #34Resource Management and Cost Optimization
A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters bu...
multi-cluster warehouseMIN_CLUSTERSAUTO_SUSPENDwarehouse efficiency - Question #35Account Management and Security
A user with the proper role issues the following commands when setting up and activating network policies: CREATE OR REPLACE NETWORK POLICY foo_policy ALLOWED_IP_LIST = ( '1.1.1.0/...
network policyIP blockinguser-level policypolicy precedence - Question #36Resource Management and Cost Optimization
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 pro...
transient tablestorage costsTime Travelstaging table - Question #37Data and Access Management
What access control policy will be put into place when future grants are assigned to both database and schema objects?
future grantsschema privilegesdatabase privilegesprivilege precedence - Question #38Performance Monitoring and Tuning
An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned. The Administrator then runs the query to compl...
EXPLAIN commandpartition pruningQuery Profilejoin pruning - Question #39Performance Monitoring and Tuning
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
materialized viewsquery optimizerquery rewriteperformance - Question #40Account Management and Security
Which Snowflake objects can be managed using SCIM integration? (Choose two.)
SCIMuser managementrole managementidentity provisioning - Question #41Data and Access Management
Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?
masking policydynamic data maskingrole-based maskingsecure views - Question #42Data Sharing and Collaboration
What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?
secure viewsdata sharingsession parametersSIMULATED_DATA_SHARING_CONSUMER - Question #43Account Management and Security
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 ev...
MFAuser managementMINS_TO_BYPASS_MFAauthentication bypass - Question #44Disaster Recovery and Business Continuity
A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider. The primary database object is : PROD_AWS_EAST. Loc...
database replicationcross-region replicationsecondary database refreshreplication commands - Question #45Account Management and Security
What roles can be used to create network policies within Snowflake accounts? (Choose three.)
network policiesRBACrole privilegesCREATE NETWORK POLICY - Question #46Resource Management and Cost Optimization
In general, the monthly billing for database replication is proportional to which variables? (Choose two.)
replication billingdata transfer costsDML operationscost variables - Question #47Account Management and Security
Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?
network policyIP allowlistaccess controlDDL syntax - Question #48Data and Access Management
Review the output of the SHOW statement below which displays the current grants on the table DB1. S1. T1: This statement is executed: USE ROLE ACCOUNTADMIN; DROP ROLE A; What will...
DROP ROLEprivilege managementownership transferRBAC - Question #49Data and Access Management
A company's Snowflake account has multiple roles. Each role should have access only to data that resides in the given role's specific region. When creating a row access policy, whi...
row access policyrole-based filteringdata securitypolicy syntax - Question #50Data and Access Management
An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows. What select c...
table samplingSYSTEM samplingBERNOULLI samplingmicro-partitions