Salesforce Certified Data 360 Consultant free question 7 / 10 · Domain 5: Data Enhancements, Sharing, and Analysis
An org uses two data spaces, default and brand_b. An analyst creates a calculated insight with SQL. The analyst has access to both data spaces and chose brand_b as the data space on the creation screen. Which statement about the DMO names written in the SQL and the objects that can be referenced matches the Help article?
- DMO names are case sensitive. You can reference only the objects contained in brand_b
- DMO names are not case sensitive. You can reference only the objects contained in brand_b
- DMO names are not case sensitive. You can reference objects in both data spaces you can access
- DMO names are case sensitive. You can reference objects in both data spaces you can access
Show the answer and explanation
Answer: A
Why this is correct
The article says DMO names in calculated insights are case sensitive, and when you create one with SQL it asks you to check that each DMO reference matches the API name, using the Object API Name column on the Data Model tab. Also, the creation screen lets you choose only data spaces you can access, and a calculated insight can use only the objects contained in the data space you chose. A data space is a boundary for separating data by brand or region, so the material for an insight stays within it.
Why the other options are wrong
"DMO names are not case sensitive. You can reference only the objects contained in brand_b" … Limiting references to brand_b is right, but the article says DMO names in calculated insights are case sensitive. Writing them with ordinary SQL habits can give a reference that does not match the API name.
"DMO names are not case sensitive. You can reference objects in both data spaces you can access" … Both parts are wrong. DMO names are case sensitive, and even if the analyst can access both data spaces, only objects in the data space chosen at creation can be used.
"DMO names are case sensitive. You can reference objects in both data spaces you can access" … Case sensitivity is right, but even with several accessible data spaces, you can reference only objects in the data space chosen on the creation screen. Access decides which data spaces you can choose from.
Related settings
The Data Cloud Architect permission set is what lets you create calculated insights with SQL. A SQL statement can be up to 131,021 characters, and you cannot continue until Check Syntax confirms it is valid. If it contains a currency measure, use the TRY_CONVERT_CURRENCY function. After creating it, you enable it by choosing a schedule and start date and time.