A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?
A. The STORE_ID should be numeric.
B. Sales across stores are not uniformly distributed.
C. The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.
D. The table is not big enough to take advantage of the clustering key.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
What are benefits of using Snowflake organizations? (Select TWO).
A. Administrators can change Snowflake account editions on-demand based on need.
B. Administrators have the ability to create accounts in any available cloud provider or region.
C. User administration is simplified across all accounts within the organization.
D. Administrators can monitor and understand usage across all accounts in the organization.
E. Administrators can simplify data movement across all accounts within the organization.
正解:B,D
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
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. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?
A. Location : AWS_EAST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;
B. Location : AWS_WEST
Command : ALTER DATABASE PROD AWS WEST REFRESH;
C. Location : AWS EAST
Command: ALTER DATABASE PROD_AWS_WEST REFRESH;
D. Location : AWS_WEST
Command : REFRESH DATABASE PROD_AWS WEST REFRESH;
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).
A. SYSADMIN
B. SECURITYADMIN
C. ACCOUNTADMIN
D. IMPORT PRIVILEGES and SHARED DATABASE
E. IMPORT SHARE and CREATE DATABASE
正解:C,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
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 that only certain roles can see certain secure views.
How can this be accomplished?
A. Apply RBAC directly onto the partner's shared secure views.
B. Create views over the incoming shared database and apply the desired RBAC onto these views.
C. Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.
D. Individually grant imported privileges onto the schema in the share.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
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 number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Select TWO).
A. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
B. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.
C. Increase the minimum number of clusters started in the multi-cluster configuration to 5.
D. Increase the multi-cluster maximum to 20 or more clusters.
E. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.
正解:B,E
解説: (Pass4Test メンバーにのみ表示されます)
Murayama -
最小限の対策で合格をめざすADA-C01参考書だぜ。問題数も増えた感じで内容も充実している。無事、合格することができました。感謝感激です。