ADA-C01 무료 덤프문제 온라인 액세스

What SCIM integration types are supported in Snowflake? (Select THREE).

• A.Amazon Web Services (AWS)
• B.Azure Active Directory (Azure AD)
• C.Google Cloud Platform (GCP)
• D.Duo Security Provisioning Connector
• E.Custom
• F.Okta

A Snowflake Administrator needs to retrieve the list of the schemas deleted within the last two days from the DB1 database.
Which of the following will achieve this?

• A.SELECT * FROM DB1.INFORMATION_SCHEMA.SCHEMATA;
• B.SHOW SCHEMAS IN DATABASE DB1;
• C.SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SCHEMATA;
• D.SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.DATABASES;

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?

• A.Create it as a permanent table with a retention time of 0 days.
• B.Create it as a temporary table with a retention time of 0 days.
• C.Create it as an external table, which will not incur Time Travel costs.
• D.Create it as a transient table with a retention time of 0 days.

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?

• A.Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
• B.Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
• C.Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
• D.Alter the user and set MINS TO BYPASS MFA to a value that will disable MFA long enough for the user to log in.

In general, the monthly billing for database replication is proportional to which variables? (Select TWO).

• A.The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts
• B.The number and size of warehouses defined in the primary account
• C.The amount of table data in the primary database that changes as a result of data loading or DML operations
• D.The frequency of changes to the primary database as a result of data loading or DML operations
• E.The frequency of the secondary database refreshes from the primary database