You're reading from Becoming a Salesforce Certified Technical Architect Prepare for the review board by practicing example-led architectural strategies and best practices

Product type Paperback

Published in Feb 2021

Publisher Packt

ISBN-13 9781800568754

Length 628 pages

Edition 1st Edition

Tools

Salesforce

Concepts

Software Architecture

Author (1):

Tameem Bahri

View More author details

Table of Contents (21) Chapters

Preface

1. Section 1: Your Journey to Becoming a CTA

2. Chapter 1: Starting Your Journey as a CTA FREE CHAPTER

3. Chapter 2: Core Architectural Concepts – Data

4. Chapter 3: Core Architectural Concepts – Integration and Cryptography

5. Chapter 4: Core Architectural Concepts – Identity and Access Management

6. Section 2: Knowledge Domains Deep Dive

7. Chapter 5: Developing a Scalable System Architecture

8. Chapter 6: Formulating a Secure Architecture in Salesforce

9. Chapter 7: Designing a Scalable Salesforce Data Architecture

10. Chapter 8: Creating a Lean Solution Architecture

11. Chapter 9: Forging an Integrated Solution

12. Chapter 10: Development Life Cycle and Deployment Planning

13. Chapter 11: Communicating and Socializing Your Solution

14. Section 3: Putting It All Together

15. Chapter 12: Practice the Review Board – First Mock

16. Chapter 13: Present and Defend – First Mock

17. Chapter 14: Practice the Review Board – Second Mock

18. Chapter 15: Present and Defend – Second Mock

19. Other Books You May Enjoy

Appendix: Tips and Tricks, and the Way Forward

The nature of data warehouses and data lakes

A data warehouse (DW or DWH) is a central repository of current and historical data that's been integrated from one or more disparate sources. The DWH (also referred to as enterprise data warehouse (EDW)) is a system that's used for data analysis and reporting. It is usually considered the core of an enterprise business intelligence strategy.

Data stored in a DWH comes from multiple systems, including operational systems (such as CRM systems). The data may need to undergo a set of data cleansing activities before it can be uploaded into the DWH to ensure data quality.

Some DWH tools have built-in ETL capabilities, while others rely on external third-party tools (we will cover ETL tools and other integration middleware in Chapter 3, Core Architectural Concepts – Integration and Security). This ETL capability will ensure that the ingested data has a specific quality and structure. Data might be staged in a specific staging...