CRM-Analytics-and-Einstein-Discovery-Consultant Practice Test
Salesforce Spring 25 Release 49 Questions
A CRM Analytics consultant at Cloud Kicks is trying to upload data using an External Data
API and the CSV file with the data was uploaded successfully. Upon analyzing the data
using a lens, they find they are unable to perform any mathematical operations as all the data and fields are treated as dimensions.
What is causing the problem?
A. JSON metadata file was not uploaded along with the CSV data file.
B. The field value added in the CSV file was contained within double quotes.
C. Proper transformations need to be performed at the external source prior to External
Data API callout.
A. JSON metadata file was not uploaded along with the CSV data file.
Explanation:
When uploading data via the External Data API, a JSON metadata file defines the field data types (dimension, measure, etc.).
If the JSON metadata file is not provided, CRM Analytics defaults all fields to dimension type, which prevents mathematical aggregations.
Option B (double quotes) usually affects string parsing but does not cause all fields to be treated as dimensions.
Option C is about transforming data at the source, but the key issue is field type definition during ingestion.
Therefore, to enable numeric operations, the consultant must upload a proper JSON metadata file alongside the CSV, specifying field types correctly.