01. In Orchard Lane Bakery's Ads data stream, each placement is mapped as a Media Buy that belongs to one campaign and one site. Each campaign runs on several sites, and each site carries placements from several campaigns.
How does the data model relate Campaign to Site?
a) One-to-many, with one campaign per site
b) Many-to-many, through Media Buy as an indirect link
c) Unrelated, so they can't be shown together in one widget
d) Many-to-many through a direct link, like Media Buy and Creative
02. Mossgate Interiors' print partner sends a weekly TotalConnect file exported from its own system. The file uses ~~ between values instead of a comma or a tab, and some weeks it arrives as a workbook with the delivery data on the second sheet. Preview Source shows every row read as one long column.
Which transformer should the implementation specialist configure?
a) The File transformer
b) The Header transformer, splitting the header into separate fields
c) The Table transformer, setting the table's start and end columns
d) The Data transformer, editing the values contained in each row
03. Brightwater Media maps a client's CRM (Opportunities) data stream with a formula that sets Opportunity Status to OPEN or CLOSED. One opportunity was won and set to CLOSED on its last Modified Date, 15 May, and nothing about it has changed since.
What does a report for 1–30 June show for this opportunity?
a) Its last Stage for June, carried forward indefinitely
b) Its last Stage for June, stretched up to the next change
c) No data for June, though it still appears up to 15 May
d) No data in any date range, June included
04. Lantern Bay Outfitters names every media buy with a four-letter region code, the year and the quarter, such as NRTH_2024_Q3. The implementation consultant is writing mapping formulas that pull the region and the year into separate fields.
Which two formula results are accurate?
(Choose 2 answers.)
a) SUBSTRING('NRTH_2024_Q3',5,9) returns 2024_
b) SUBSTRING('NRTH_2024_Q3',0,4) returns NRTH
c) SUBSTRING('NRTH_2024_Q3',1,4) returns NRTH
d) SUBSTRING('NRTH_2024_Q3',5,9) returns 2024
05. Sunvale Foods maps a Media Type field with IF(csv['Media Buy Name'] contains '_DIG', 'Digital', 'Print'). Its existing names use uppercase codes, but a new agency writes them in lowercase, such as Spring_dig_Banner, and those rows come back as Print.
Which change returns Digital for both naming styles?
a) Apply UPPER() to the Media Buy Name inside the condition
b) Apply LOWER() to the Media Buy Name inside the condition
c) Apply PROPER() to the Media Buy Name inside the condition
d) Apply TRIM() to the Media Buy Name inside the condition
06. Each morning a QA analyst at Marbleleaf Pet Supply opens a pivot table built from a data stream to compare that stream's daily totals with the source report. The analyst wants the same table delivered automatically after the morning data stream workflow finishes, without logging in.
What should the consultant set up?
a) A goal on the stream's spend that sends notifications when it misses a benchmark
b) Enable Execute only as part of a workflow on the data stream
c) Export the pivot table into a report that runs as part of the workflow
d) Save the pivot table and download its full results
07. Lindqvist Travel maps customer survey results to a generic data stream type it created in its Sweden workspace. The Sweden workspace is included in the company's executive workspace.
In the executive workspace, Ads dimensions from Sweden are available, but survey dimensions such as Survey Score Band are missing. What should the Admin do?
a) Add the survey stream to the executive workspace's Data Streams tab
b) Share the generic data stream type itself with the executive workspace
c) Push the survey dimensions into the executive workspace as calculated dimensions instead
d) Reprocess the survey stream so its dimensions reach the combined data pool
08. A cosmetics brand's Ads streams carry creative names such as Spring_Video_15s. The proposed design creates a calculated dimension, Format, with EXTRACT([Creative_Name],'_',1), and then a second calculated dimension that applies GROUPCONCAT to Format by Campaign Name, so a table can list the formats used in each campaign.
Can this design deliver the table?
a) No, since EXTRACT counts positions from 1, so Format would return the size segment instead
b) Yes, provided the Ads streams are reprocessed so that Format is written to the database first
c) Yes, since GROUPCONCAT is the grouping function calculated dimensions offer and it runs on the database
d) No, since GROUPCONCAT in a calculated dimension can't take another calculated dimension
09. Hartwell Agency's planners use the Media Naming Builder on an existing creative-name pattern. They add one set of combinations, then a second set for a new campaign, and export the names for the trafficking team, who plan to tidy some of them in the file.
Which two statements are true?
(Choose 2 answers.)
a) The second set of combinations appears as a new group under the first
b) Both sets of combinations are merged into a single group
c) Changing names in the exported Excel file can affect the patterns
d) Exporting the names updates the pattern's validation file with the new values
10. Ivory Lane's Google Ads API data stream receives conversions that the platform restates up to two weeks after the click. The client wants each scheduled run to retrieve enough past days to pick up those restatements.
Which data stream refresh setting defines how many days back each run retrieves?
a) Statistic Span Days
b) Include today's data in retrieval
c) Schedule Frequency
d) Sliding Window