Problemas
best explains how the data files in the table can be used to send a targeted e-mail to only those customers who have purchased products that use AA batteries to let them know about the new accessory? A Use the customer IDs in the purchases file to search the customers file to generate a list of e-mail addresses B Use the product IDs in the purchases file to search the products file to generate a list of product names that use AA batteries C Use the customers file to generate a list of customer IDs, then use the list of customer IDs to search the products file to generate a list of product names that use AA batteries D Use the products file to generate a list of product IDs that use AA batteries, then use the list of product IDs to search the purchases file to generate a list of customer IDs, then use the list of customer IDs to search the customers file to generate a list of e -mail addresses
Solución
Nataliamaestro · Tutor durante 5 años
Verificación de expertos
4.2 (333 votos)
Responder
The correct answer is 'D'.
Explicar
## Step 1<br />The problem is about how to use data files to send a targeted email to customers who have purchased products that use AA batteries. The goal is to identify these customers and their email addresses.<br /><br />## Step 2<br />Option A suggests using the customer IDs in the purchases file to search the customers file to generate a list of email addresses. However, this method does not ensure that the customers have purchased products that use AA batteries.<br /><br />## Step 3<br />Option B suggests using the product IDs in the purchases file to search the products file to generate a list of product names that use AA batteries. This method does not provide any information about the customers who have purchased these products.<br /><br />## Step 4<br />Option C suggests using the customers file to generate a list of customer IDs, then using the list of customer IDs to search the products file to generate a list of product names that use AA batteries. This method does not ensure that the customers have purchased these products.<br /><br />## Step 5<br />Option D suggests using the products file to generate a list of product IDs that use AA batteries, then using the list of product IDs to search the purchases file to generate a list of customer IDs, then using the list of customer IDs to search the customers file to generate a list of email addresses. This method ensures that the customers have purchased products that use AA batteries and provides their email addresses.
Haz clic para calificar: