Exam for engine

NO.73 A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the peformance? Choose 2

NO.74 Certification Aid wants to implement a custom profile center using SOAP API. Which SOAP API methods are relevant to achieve this? Choose 2.

NO.75 A developer is writing a query to select unique subscribers who opened any emails sent since the beginning of the previous day.
Which querywould provide that result?

NO.76 NTO had an Enterprise 2.0 account; subscribers unsubscribes from the business unit only. A developer is identifying subscribers who unsubscribed from any of the NTO child business units. Which method would identify the most accurate status for subscribers of each business unit?

NO.77 A developer wants to include an AMPscript if/else statement in an email to satisfy the condition “if the subscriber’s tier is not premier then display heading encouraging them to upgrade.” The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?

NO.78 A developer is building an integration with the Marketing Cloud API. In which two ways should the Client ID and Client Secret credentials be stored? Choose 2

NO.79 A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

NO.80 A particular data extension need to be configured to store six months of data.
How shoulddata retention be added to the data extension in Email Studio?

NO.81 A developer is troubleshooting why a parent-level data extension cannot be accessed by a child business unit.
What should the developer check to validate the data available can be accessed for child business unit queries?

NO.82 Northern Trail Outfitters’ account is configured with two child BU(s): US and Global. The account has a data extension In the Shared Data Extensions folder named ‘MemberData’. This data extension contains basic address information, as well as Boolean fields labeled ‘US’ and ‘Global’ indicating to which business unit the subscriber belongs. Automation needs to be created in the US business unit to query all records in New York who are members of the business unit US.
SELECT * FROM MemberData WHERE State = ‘NY’ AND US = 1
What would cause this query to report the following error: “An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views.”?

NO.83 A developer wants to personalize a welcome email with the recipient’s first name from the Customers data extension, which is different from the targeted sending data extension named NewSubscribers. Both data extensionscontain the unique identifier in a field named CustomerKey. Which AMPscript Syntax would populate the first name personalization as requested?

NO.84 A developer wants a link to be dynamic based on subscriber attributes. Rather than create numerous links, the developer uses AMPscript to set the link’s value as a variable. The variable will be used within the <a> tag. What should the developer do within the <a> tag to ensure clicks are tracked for the variable? Choose 2

NO.85 A developer wants to add an image to Content Builder via the API and retrieve the image’s published URL.
Which method should the developer use?

NO.86 A developer wants to create a CloudPage which is linked from an email. %%[SET @point = RequestParameter(x) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point)>2 THEN SET @value = 2 ELSEIF Length(@point) >3 THEN SET@value = 3 ELSEIF Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x = ‘Tacos’?

NO.87 A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flied contains this information per these rules: -Phone is not black (Data Type = Phone) -PhoneExist is true (Data Type = Boolean) -ValidPhone is ‘true’ (Data Type = Formula(Boolean)) -ContactType equals ‘Phone’ (Data Type = Text). Which field could be used to select a subset of records in the synchronization configuration?

NO.88 A developer identified duplicate contacts and initiated a Contact Delete process for 10 milion subscribers. How could the process be expedited?

NO.89 A developer is configuring a File Drop Automation and wants to use a Filename Pattern to allow for timestamps on the file. The file name will always start with the month and day (e.g. MAY15) the file is dropped onto the SFTP site.
Which two configurations should be used for the automation to successfully start? Choose 2 answers

NO.90 A developer, who is new to Marketing Cloud, needs to design a landing page for a new customer. They choose to use Server-Side JavaScript (SSJS) due to their extensive knowledge of JavaScript from previous projects.
Which two features would the developer be able to leverage in their Server-Side code? Choose 2 answers

NO.91 A developer needs to import a file into a data extension which contains transactional dat a. The file includes a column labeled Purchase_Price with values varying from ‘$.05’ to ‘$100’.
What Data Type should be used to prevent loss of data’

NO.92 When do synchronous REST API calls to Marketing Cloud time out? Choose 2.

NO.93 In what order is AMPscript evaluated before an email is sent?

NO.94 A developer wants to include an AMPscript if/else statement in an email to satisfy the condition “if the subscriber’s tier is not premier then display heading encouraging them to upgrade.” The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?