Câu 20: Salesforce Certified Tableau Consultant

A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version. The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website. The client uses “Some Records Match” for the Referential Integrity setting because a match is not guaranteed. The client wants to improve the performance of the dashboard while also getting an accurate count of site visitors. Which modifications to the data tables and join should the consultant recommend?

1. A. Add an “Unknown” option to the Browser Table, reference its BrowserID in the Site Visitor Table, and leave the Referential Integrity set to “Some Records Match”.
2. B. Continue to use NULL as the BrowserID in the Site Visitor Table and leave the Referential Integrity set to “Some Records Match”.
3. C. Continue to use NULL as the BrowserID in the Site Visitor Table and change the Referential Integrity to “All Records Match”.
4. D. Add an “Unknown” option to the Browser Table, reference its BrowserID in the Site Visitor Table, and change the Referential Integrity to “All Records Match”. — đáp án hiện tại