AP-215 — Salesforce Marketing Cloud Intelligence Accredited Professional

Full question text, answer options, and explanations for this practice set — a spoiler-free alternative is the interactive quiz above for scored, shuffled practice.

1. 1. What is the primary function of a Data Stream in Marketing Cloud Intelligence (formerly Datorama)?

   • A. A scheduled report that exports data to an external system
   • B. A configured connection that ingests data from a specific source into Intelligence(correct)
   • C. A real-time data pipeline for streaming events
   • D. A transformation rule that cleans incoming data

   Explanation: A Data Stream in Marketing Cloud Intelligence is a configured connection to a data source (such as Google Analytics, Facebook Ads, or a CSV file) that ingests data on a scheduled or triggered basis. Each Data Stream maps source data to the Intelligence data model.

2. 2. A marketer wants to connect Marketing Cloud Intelligence to their Google Ads account to ingest campaign performance data. Which Data Stream type should they use?

   • A. API Data Stream with custom endpoint
   • B. Google Ads native connector (TotalConnect)(correct)
   • C. CSV file upload via SFTP
   • D. Salesforce Marketing Cloud connector

   Explanation: Marketing Cloud Intelligence includes TotalConnect, a library of pre-built native connectors for popular advertising and analytics platforms including Google Ads. TotalConnect handles authentication and API calls automatically, requiring only credentials and account selection.

3. 3. Which two methods can be used to ingest custom or proprietary data into Marketing Cloud Intelligence when no native connector exists? (Choose 2)

   • A. CSV/Excel file upload via SFTP or manual upload(correct)
   • B. Marketing Cloud Intelligence REST API for programmatic data push(correct)
   • C. Direct SQL query against a connected external database
   • D. Salesforce Flow integration for automatic field sync

   Explanation: For custom data sources without native connectors, Intelligence supports CSV/Excel file ingestion via SFTP or manual upload, and the Intelligence REST API allows programmatic data push from any system. Direct SQL database connections are not supported natively.

4. 4. After connecting a Facebook Ads Data Stream, a marketer notices that campaign spend data is being duplicated — the same day's data appears twice. What is the most likely cause?

   • A. The Data Stream is configured with an incorrect date range
   • B. Two Data Streams are connected to the same Facebook Ads account(correct)
   • C. The deduplication key has not been configured on the Data Stream
   • D. Facebook Ads API is returning historical data with each sync

   Explanation: If two Data Streams are connected to the same Facebook Ads account with overlapping data, Intelligence will ingest the data twice, causing duplication. The solution is to remove or deactivate the duplicate Data Stream or configure non-overlapping date filters.

5. 5. A company uploads a CSV file to Marketing Cloud Intelligence. The file contains a column called 'CampaignID' that should link rows across multiple uploaded files. Which Intelligence concept maps this column for cross-stream joining?

   • A. Primary Dimension(correct)
   • B. Harmonisation Key
   • C. Cross-Stream Connector
   • D. Data Model Link Field

   Explanation: In Marketing Cloud Intelligence, a Primary Dimension is the key field mapped during Data Stream configuration that identifies a record (such as Campaign ID). When the same Primary Dimension is mapped across multiple streams, Intelligence can join and harmonise data across sources.

6. 6. Which two data refresh frequencies are available for automated Data Stream ingestion in Marketing Cloud Intelligence? (Choose 2)

   • A. Hourly refresh(correct)
   • B. Daily refresh(correct)
   • C. Real-time streaming (sub-second)
   • D. Weekly refresh

   Explanation: Marketing Cloud Intelligence supports hourly and daily automated Data Stream refreshes. Real-time sub-second streaming is not available; for near-real-time needs, the API push approach can be used but is not a built-in scheduler option.

7. 7. In Marketing Cloud Intelligence, what is the difference between a Dimension and a Measurement?

   • A. Dimensions are numeric aggregatable values; Measurements are categorical descriptors
   • B. Dimensions are categorical attributes (e.g., Campaign Name); Measurements are numeric values (e.g., Spend)(correct)
   • C. Dimensions are date fields; Measurements are text fields
   • D. Dimensions are used for filtering only; Measurements are used for display only

   Explanation: In the Intelligence data model, Dimensions are categorical descriptors (e.g., Campaign Name, Channel, Country) used for grouping and filtering. Measurements are numeric values (e.g., Impressions, Clicks, Spend) that can be aggregated with functions like SUM, AVG.

8. 8. A company runs campaigns across Google Ads and Facebook Ads. Both platforms use different naming for campaign status: Google uses 'ENABLED'/'PAUSED' while Facebook uses 'ACTIVE'/'INACTIVE'. Which Intelligence feature maps these to a unified value?

   • A. Data Stream field mapping
   • B. Harmonisation Rules(correct)
   • C. Calculated Dimensions
   • D. Cross-Channel Data Model

   Explanation: Harmonisation Rules in Marketing Cloud Intelligence map differing source values to a standardised unified value. For example, a rule can map Google's 'ENABLED' and Facebook's 'ACTIVE' to a common 'Active' value in the Intelligence data model, enabling cross-channel comparison.

9. 9. What is a Calculated Measurement in Marketing Cloud Intelligence?

   • A. A measurement automatically calculated by the native connector
   • B. A custom metric derived from existing measurements using a formula(correct)
   • C. A measurement that is estimated when actual data is unavailable
   • D. A measurement imported from an external analytics platform

   Explanation: A Calculated Measurement is a custom metric defined by the user using a formula applied to existing measurements. For example, Cost Per Click (CPC) = Spend / Clicks, or ROAS = Revenue / Spend. These are computed at query time.

10. 10. A marketer has ingested data from three advertising channels, each with different campaign name conventions. They want to group campaigns across channels into unified 'Product Lines' for reporting. Which two Intelligence features can achieve this? (Choose 2)

    • A. Harmonisation Rules with pattern matching on campaign name(correct)
    • B. Calculated Dimensions using IF/THEN logic on Campaign Name(correct)
    • C. Data Stream field renaming
    • D. Dashboard filter groups

    Explanation: Harmonisation Rules with pattern matching can map campaign names matching certain patterns (e.g., containing 'ProductA') to a unified 'Product Line' dimension value. Calculated Dimensions using conditional logic (IF campaign name CONTAINS 'ProductA' THEN 'Product Line A') achieve the same outcome with formula-based logic.

11. 11. A company's Facebook Ads report shows Spend in USD, but their Google Ads report shows Spend in EUR. They want a unified Spend in USD. Where is currency conversion configured in Marketing Cloud Intelligence?

    • A. Data Stream currency setting per stream
    • B. Workspace settings — Currency and Timezone(correct)
    • C. Dashboard currency selector
    • D. Calculated Measurement using a manual conversion rate

    Explanation: Currency and timezone are configured at the Workspace level in Marketing Cloud Intelligence settings. Intelligence applies the workspace currency setting to normalise multi-currency data streams to a single reporting currency using exchange rates.

12. 12. A marketer notices that after ingesting a new CSV file, some rows are not appearing in dashboards. The file contains 500 rows but only 480 appear. What should the marketer check first?

    • A. The Data Stream's date range filter excluding 20 rows
    • B. Rejected rows in the Data Stream's ingestion log due to mapping errors or missing required fields(correct)
    • C. The dashboard filter excluding certain campaign names
    • D. Harmonisation Rules removing rows with unmapped values

    Explanation: When rows are missing after ingestion, the first step is to check the Data Stream's ingestion log for rejected rows. Rows are rejected when required field mappings are missing, field types do not match, or values cannot be parsed. The ingestion log shows the number and reason for rejections.

13. 13. In Marketing Cloud Intelligence, what is a Widget?

    • A. A Data Stream configuration component
    • B. A visual element on a dashboard displaying a specific metric or chart(correct)
    • C. An automated report sent via email
    • D. A calculated measurement formula editor

    Explanation: A Widget in Marketing Cloud Intelligence is a visual component placed on a dashboard. Each Widget represents a specific data visualisation (chart, table, KPI tile) configured with measurements, dimensions, and filters.

14. 14. A marketer wants to display campaign spend, impressions, and ROAS side by side for quick comparison on a single dashboard widget. Which widget type is most appropriate?

    • A. Pie Chart
    • B. Combo Chart (bar + line)
    • C. KPI Tile
    • D. Data Table(correct)

    Explanation: A Data Table widget allows multiple metrics (Spend, Impressions, ROAS) to be displayed as columns with dimension rows (e.g., Campaign Name), making it ideal for side-by-side multi-metric comparison. KPI Tiles show a single metric; charts show trends or distributions.

15. 15. Which two features allow a user to dynamically change the data shown in a Marketing Cloud Intelligence dashboard without editing widget configurations? (Choose 2)

    • A. Dashboard-level Date Range filter(correct)
    • B. Dashboard-level Dimension filter (e.g., filter by Channel)(correct)
    • C. Editing the Harmonisation Rule for the dashboard
    • D. Changing the workspace currency setting

    Explanation: Dashboard-level filters for Date Range and Dimensions allow users to dynamically slice the dashboard data without modifying widget configurations. These filters apply to all widgets on the dashboard simultaneously.

16. 16. What is the purpose of the Einstein Insights feature in Marketing Cloud Intelligence?

    • A. To predict future campaign spend using machine learning
    • B. To automatically surface significant changes and anomalies in marketing data(correct)
    • C. To optimise Journey Builder send times using AI
    • D. To score contacts by predicted conversion probability

    Explanation: Einstein Insights in Marketing Cloud Intelligence automatically analyses data and surfaces significant changes, anomalies, and trends using AI. For example, it may alert that a campaign's CTR dropped 40% or that a new channel is outperforming others, without requiring manual analysis.

17. 17. A marketing team wants to share a Marketing Cloud Intelligence dashboard with stakeholders who do not have Intelligence logins. Which feature enables external dashboard sharing?

    • A. Dashboard Export to PDF sent via email
    • B. Public Dashboard URL (shareable link)(correct)
    • C. Dashboard Embed Code for external websites
    • D. Salesforce Experience Cloud integration

    Explanation: Marketing Cloud Intelligence supports generating a Public Dashboard URL that allows external stakeholders to view a dashboard without an Intelligence login. The link can be shared directly and the dashboard is view-only for recipients.

18. 18. A brand wants to compare their paid social campaign performance against industry benchmarks. Which two Intelligence features support benchmark comparison in dashboards? (Choose 2)

    • A. Custom benchmark values manually entered as a Calculated Measurement(correct)
    • B. Intelligence Benchmark Data Streams from industry databases(correct)
    • C. Einstein Insights benchmark deviation alerts
    • D. Salesforce CDP benchmark integration

    Explanation: Benchmarks can be incorporated by manually entering benchmark values as Calculated Measurements (e.g., Industry Average CTR = 0.02) for comparison in widgets, or by connecting to Intelligence Benchmark Data Streams that provide industry benchmark data from partner databases.

19. 19. A developer wants to push custom event data into Marketing Cloud Intelligence programmatically from an external system. Which API should they use?

    • A. Salesforce Marketing Cloud REST API
    • B. Marketing Cloud Intelligence REST API(correct)
    • C. Salesforce Data Cloud Ingestion API
    • D. Marketing Cloud SOAP API

    Explanation: The Marketing Cloud Intelligence REST API (formerly Datorama API) allows developers to programmatically push data into Intelligence Data Streams, retrieve processed data, and manage Intelligence entities. It is separate from the main Marketing Cloud REST API.

20. 20. Which Marketing Cloud Intelligence feature automates the scheduled delivery of a dashboard as an image or PDF to stakeholders via email?

    • A. Scheduled Data Stream sync
    • B. Scheduled Dashboard Export / Report Subscription(correct)
    • C. Automation Studio integration
    • D. Journey Builder email activity

    Explanation: Marketing Cloud Intelligence supports Scheduled Dashboard Export (also called Report Subscriptions), which automatically sends a snapshot of a dashboard as a PDF or image to specified email recipients on a configured schedule.

21. 21. A developer is using the Marketing Cloud Intelligence API to retrieve aggregated campaign data. Which two authentication steps are required? (Choose 2)

    • A. Obtain an API Token from the Intelligence Settings > API Access section(correct)
    • B. Pass the API Token in the Authorization header of each request(correct)
    • C. Exchange a Salesforce Connected App client ID/secret for an OAuth2 token
    • D. Use a username/password basic auth header

    Explanation: The Marketing Cloud Intelligence API uses token-based authentication. Developers obtain a permanent API Token from the Intelligence platform settings and include it in the Authorization header (Authorization: Token <your_token>) with each API request.

22. 22. A company wants to automatically update Marketing Cloud Intelligence Data Streams when their CRM exports new data nightly. What is the recommended approach?

    • A. Configure a CRM connector in Intelligence TotalConnect
    • B. Place the nightly export CSV on an SFTP server and configure an SFTP Data Stream in Intelligence(correct)
    • C. Use Salesforce Flow to push data directly into Intelligence
    • D. Schedule an Automation Studio activity to export to Intelligence

    Explanation: For automated nightly CRM data ingestion, the recommended approach is to configure the CRM to export data as CSV to an SFTP server, then configure an SFTP-triggered Data Stream in Intelligence that picks up new files as they arrive. This is a standard, low-code integration pattern.

23. 23. In Marketing Cloud Intelligence, what is a Workspace?

    • A. A single dashboard in Intelligence
    • B. The top-level container for all Intelligence data, Data Streams, dashboards, and users for an organisation(correct)
    • C. A data model schema definition
    • D. A set of Harmonisation Rules applied to a single Data Stream

    Explanation: A Workspace in Marketing Cloud Intelligence is the top-level tenant container that holds all Data Streams, data models, dashboards, Harmonisation Rules, users, and settings for an organisation. Each Intelligence subscription typically has one primary Workspace.

24. 24. Which two user permission levels are available in Marketing Cloud Intelligence for controlling data access? (Choose 2)

    • A. Admin — full platform access including Data Stream configuration and user management(correct)
    • B. Viewer — read-only access to dashboards with no data or configuration access(correct)
    • C. Analyst — can query raw data via API but cannot view dashboards
    • D. Publisher — can create dashboards but not configure Data Streams

    Explanation: Marketing Cloud Intelligence has tiered permission roles. Admin users have full access including Data Stream configuration, Harmonisation Rules, and user management. Viewer (or Reporter) users have read-only access to view dashboards without configuration privileges.

25. 25. A company has Marketing Cloud Intelligence integrated with Marketing Cloud Engagement. A marketer wants to see email campaign performance data from Marketing Cloud Engagement within Intelligence dashboards. Which Data Stream type provides this integration?

    • A. A manual CSV export from Email Studio imported into Intelligence
    • B. The Marketing Cloud Engagement native connector in Intelligence TotalConnect(correct)
    • C. A Salesforce CRM connector pulling from Marketing Cloud Engagement data
    • D. An Automation Studio export to SFTP ingested by Intelligence

    Explanation: Marketing Cloud Intelligence includes a native Marketing Cloud Engagement connector in TotalConnect that directly connects to Marketing Cloud Engagement and ingests email, SMS, and journey performance data, enabling unified cross-channel reporting without manual exports.