Understand How Data Is Retrieved Within a Relational Data Model (I.e. Basic SQL). MARKETING-CLOUD-ENGAGEMENT-CONSULTANT Practice Questions (Page 1)

Questions 1–5

1. 1application · easy

   A consultant is reviewing a data model where the Subscribers table has SubscriberKey as its primary key, and the Orders table has OrderID as its primary key and SubscriberKey as a foreign key. Which statement accurately describes this relationship?

   • AEach order can belong to many subscribers, and each subscriber can have many orders.
   • BSubscribers and orders are unrelated because they have different primary keys.
   • CEach order belongs to exactly one subscriber, but a subscriber can have many orders.
   • DEach subscriber belongs to exactly one order, but an order can have many subscribers.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which SQL operator is used to test for NULL values?

   • A= NULL
   • BLIKE NULL
   • CIS NULL
   • D== NULL
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which SQL statement retrieves only the EmailAddress column from the Subscribers table?

   • ARETRIEVE EmailAddress FROM Subscribers;
   • BSELECT EmailAddress FROM Subscribers;
   • CSELECT * FROM Subscribers;
   • DSELECT Subscribers FROM EmailAddress;
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   In a SQL query, which clause is used to filter rows based on a condition?

   • AHAVING
   • BORDER BY
   • CGROUP BY
   • DWHERE
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   In a relational data model, what is a primary key?

   • AA column that links to another table's primary key
   • BA column that stores the same value in multiple rows
   • CA column or set of columns that uniquely identifies each row in a table
   • DA column that can contain NULL values
   Reveal Solution Discussion Select an answer first