[Salesforceデザイナー資格]Data Architecture and Management デザイナー

Posted by

概要

本記事は、Salesforceのデザイナー資格であるData Architecture and Managementを受験するにあたって勉強した際の簡単なメモとなります。
私が受験した時のバージョンはWinter’20でしたので、その時点での試験範囲に基づいております。

試験範囲

試験範囲については、リリースごとに変わる可能性があるので最新情報を確認する必要があります。詳細は下記から参照してください。
http://tandc.salesforce.com/examguide_cert_data_archi_manage_designer.pdf

勉強内容

基本的な勉強方法は、上記の試験範囲に沿って必要な情報が公開されているヘルプサイトやブログ、Trailheadを参考にインプットをしました。

Data Modeling (20%)

BigObject

https://developer.salesforce.com/docs/atlas.en-us.bigobjects.meta/bigobjects/big_object.htm

https://developer.salesforce.com/docs/atlas.en-us.bigobjects.meta/bigobjects/big_object_example_queueable.htm

Roll up summary

https://help.salesforce.com/articleView?id=fields_about_roll_up_summary_fields.htm&type=5

https://help.salesforce.com/articleView?id=fields_defining_summary_fields.htm&type=5

Relation

https://help.salesforce.com/articleView?id=overview_of_custom_object_relationships.htm&type=5

External Object

https://help.salesforce.com/articleView?id=external_object_define.htm&type=5

https://help.salesforce.com/articleView?err=1&id=ext_data_sync_database.htm&type=5

Data Skew

https://trailhead.salesforce.com/content/learn/modules/large-data-volumes/design-your-data-model

Person Account

https://help.salesforce.com/articleView?id=account_person.htm&type=5

Custom Index

https://help.salesforce.com/articleView?id=000325247&language=en_US%C2%A0&type=1&mode=1

Data Archiving Strategy

http://www.salesforce.org/ask-architect-5-steps-effective-salesforce-data-management-strategy/

https://www.salesforce.org/ask-an-architect-5-steps-to-an-effective-salesforce-data-management-strategy/

Data Storage

https://help.salesforce.com/articleView?id=overview_storage.htm&type=5

https://help.salesforce.com/articleView?id=000318951&type=1&mode=1

Set Audit Field

https://help.salesforce.com/articleView?id=000334139&type=1&mode=1

Outbound Message

https://help.salesforce.com/articleView?err=1&id=workflow_managing_outbound_messages.htm&type=5

Conceptual Design(15%)

Lightning Data

https://appexchange.salesforce.com/appxStore?type=Data

Data.com vs Lightning Data Service

https://help.salesforce.com/articleView?id=000317679&type=1&mode=1

Merge

https://help.salesforce.com/articleView?id=contacts_merge_classic.htm&type=5

Data.com Prospector and Clean

https://help.salesforce.com/articleView?id=000318293&type=1&mode=1

Duplicate Rule

https://help.salesforce.com/articleView?id=duplicate_rules_map_of_reference.htm&type=5

Translation workbench

https://help.salesforce.com/articleView?id=customize_wbench.htm&type=5

Mater Data Management(10%)

特に参考サイトなし・・・

Metadata Management(7%)

Event monitoring

https://trailhead.salesforce.com/en/content/learn/modules/event_monitoring/event_monitoring_intro

Custom Metadata Types

https://help.salesforce.com/articleView?id=custommetadatatypes_package_install.htm&type=5

Package Custom Metadata Types and Record

https://help.salesforce.com/articleView?id=custommetadatatypes_package_install.htm&type=5

Define Custom Settings

https://help.salesforce.com/articleView?id=custommetadatatypes_package_install.htm&type=5

Metadata API

https://help.salesforce.com/articleView?id=custommetadatatypes_package_install.htm&type=5

Audit Trail

https://help.salesforce.com/articleView?id=custommetadatatypes_package_install.htm&type=5

Data Archiving(10%)

Export Buckup data from Salesforce

https://help.salesforce.com/articleView?id=admin_exportdata.htm&type=5

https://developer.salesforce.com/blogs/2015/03/salesforce-backup-and-restore-essentials-part-1-backup-overview-api-options-and-performance.html

Outbound Message Actions

https://help.salesforce.com/articleView?id=workflow_managing_outbound_messages.htm&type=5

Field Set

https://help.salesforce.com/articleView?id=fields_about_field_sets.htm&type=5

Buckup and restore

https://developer.salesforce.com/blogs/2015/03/salesforce-backup-and-restore-essentials-part-1-backup-overview-api-options-and-performance.html

PK Chunking

https://developer.salesforce.com/blogs/engineering/2015/03/use-pk-chunking-extract-large-data-sets-salesforce.html

Field History Tracking

https://help.salesforce.com/articleView?id=tracking_field_history.htm&type=5

Suspend Event

https://developer.salesforce.com/blogs/engineering/2013/05/extreme-force-com-data-loading-part-3-suspending-events-that-fire-on-insert.html

Deferred Sharing Calculation

https://developer.salesforce.com/blogs/engineering/2013/08/extreme-force-com-data-loading-part-6-taking-advantage-of-deferred-sharing-calculation.html

Dataloader CLI

https://help.salesforce.com/articleView?id=command_line_intro.htm&type=5

Data backup and recovery Best Practice

https://help.salesforce.com/articleView?id=000334121&language=en_US&type=1&mode=1

Data Governance(7%)

Data Covernance Best Practice

https://www.salesforce.com/video/1779731/

Reporting and Analytics(10%)

Performance Turning

https://developer.salesforce.com/blogs/engineering/2013/03/long-and-short-term-approaches-for-tuning-force-com-performance.html

Custom Index

https://developer.salesforce.com/blogs/engineering/2015/06/know-thy-salesforce-field-indexes-fast-reports-list-views-soql.html

Run Report Faster

https://developer.salesforce.com/docs/atlas.en-us.salesforce_reportperformance_cheatsheet.meta/salesforce_reportperformance_cheatsheet/reportperformance_cheatsheet.htm

Improve Report Performance

https://help.salesforce.com/articleView?id=improving_report_performance.htm&type=5

Sales Dashboard

https://www.salesforce.com/blog/2019/01/sales-management-dashboards.html

Report Consideration

https://help.salesforce.com/articleView?id=platform_connect_considerations_reports.htm&type=5

Schedule Dashboard

https://help.salesforce.com/articleView?id=dashboards_schedule_refresh.htm&type=5

Limit of Custom ReportTypes

https://help.salesforce.com/articleView?id=reports_report_type_guidelines.htm&type=5

Data Migration(10%)

Duplicate Rules

https://help.salesforce.com/articleView?id=duplicate_rules_map_of_reference.htm&type=5

Data loading

https://developer.salesforce.com/blogs/engineering/2013/06/extreme-force-com-data-loading-part-4-sequencing-load-operations.html

Data aggregation

https://developer.salesforce.com/docs/atlas.en-us.salesforce_large_data_volumes_bp.meta/salesforce_large_data_volumes_bp/ldv_deployments_case_studies_data_aggregation.htm

 Limits and allocation

https://developer.salesforce.com/docs/atlas.en-us.salesforce_app_limits_cheatsheet.meta/salesforce_app_limits_cheatsheet/salesforce_app_limits_overview.htm

Large Data Volumes

https://developer.salesforce.com/page/The_Salesforce_Bulk_API_-_Maximizing_Parallelism_and_Throughput_Performance_When_Integrating_or_Loading_Large_Data_Volumes

Lock Error

https://help.salesforce.com/articleView?id=000338933&type=1&mode=1

Create Audit Fields Permission

https://help.salesforce.com/articleView?id=000334139&type=1&mode=1

Large Data Loading

https://developer.salesforce.com/blogs/engineering/2013/04/extreme-force-com-data-loading-part-2-load-into-a-lean-salesforce-configuration.html

Performance tuning(11%)

https://developer.salesforce.com/blogs/engineering/2013/03/long-and-short-term-approaches-for-tuning-force-com-performance.html

Performance Test

https://help.salesforce.com/articleView?id=000335652&type=1&mode=1

https://www.salesforce.com/video/306187/

Deffered Sharing Calculation

https://developer.salesforce.com/blogs/engineering/2013/08/extreme-force-com-data-loading-part-6-taking-advantage-of-deferred-sharing-calculation.html

LDV

https://resources.docs.salesforce.com/sfdc/pdf/draes.pdf

SOQL Query Selective

https://help.salesforce.com/articleView?id=000325257&language=en_US&type=1&mode=1

http://resources.docs.salesforce.com/rel1/doc/en-us/static/pdf/salesforce_query_search_optimization_developer_cheatsheet.pdf