Salesforce Certified Data Cloud Accredited Professional Practice Test - Questions Answers, Page 6

The data types can be changed during ingestion before the Data Source Object (DSO) is created. A DSO is a container for ingested data that defines the schema, format, and metadata of the data. Data types can be changed in the Data Explorer before creating a DSO by using the Edit Schema option. Once a DSO is created, the data types cannot be changed.

Reference:Create a Data Source Object

COALESCE is the function that returns the first value from a list that isn't empty. It takes a list of values as arguments and returns the first non-empty value. For example, COALESCE(NULL, '', 'Hello', 'World') returns 'Hello'. If all values are empty, it returns NULL.

Reference:COALESCE

When B2C Commerce Data Stream is created from the Order Bundle, 30 days of historical data is loaded. The Order Bundle is a preconfigured data bundle that contains order-related data from B2C Commerce Cloud. Data Stream is a feature that allows you to stream data from B2C Commerce Cloud to Data Cloud in near real time.

Reference:B2C Commerce Data Stream

The maximum limit of the number of records for Full Refresh Extract Method is 10 million. Full Refresh Extract Method is an option for extracting data from Marketing Cloud to Data Cloud. It extracts all records from a data extension regardless of when they were created or modified. If the number of records exceeds 10 million, an error occurs and no records are extracted.

Reference:Extract Methods

Numeric is the only type of measures that support aggregate functions. Measures are numeric fields that can be aggregated using functions such as SUM, AVG, MIN, MAX, or COUNT. For example, you can use a measure to calculate the total revenue or the average order value from your data. Date, Text, and Boolean are not types of measures, but types of dimensions. Dimensions are fields that can be used to group or filter data, but not to perform calculations.

Reference:Measures and Dimensions

Only one metric can be present in one segment container. A segment container is a logical grouping of segments that share the same metric and granularity. A metric is a calculated insight that defines and calculates a multidimensional measure on your data. A granularity is the level of detail at which you want to analyze your data, such as daily, weekly, or monthly. You can create multiple segment containers with different metrics and granularities, but each segment container can only have one metric.

Reference:Segment Containers

The maximum number of calculated insights that can be created per tenant is 50. A calculated insight is a metric that defines and calculates a multidimensional measure on your data. You can use calculated insights to create segments and analyze your data in Data Cloud. You can also use calculated insights to create dashboards and reports in Tableau CRM.

Reference:Calculated Insights

Text Measures and Date Time Measures cannot be used in Segmentation. Segmentation is the process of creating filtered audience segments based on calculated insights. Calculated insights are metrics that define and calculate multidimensional measures on your data. Only Numeric Measures can be used as calculated insights, because they can be aggregated using functions such as SUM, AVG, MIN, MAX, or COUNT. Text Measures and Date Time Measures are not types of measures, but types of dimensions. Dimensions are fields that can be used to group or filter data, but not to perform calculations.

Reference:Measures and Dimensions

These are two characteristics of Formulas. Formulas are a feature that allows you to create custom fields in the data model using simple logic on a row-based operation. For example, you can use a formula to create a field that concatenates the first name and last name of an individual. Formulas are easy to use and self-service, meaning that you can create them without coding or complex queries. You can use formulas to enrich your data and create more meaningful segments and insights.

Reference:Formulas