{"id":84,"date":"2022-12-11T08:29:23","date_gmt":"2022-12-11T08:29:23","guid":{"rendered":"https:\/\/exampracticetests.com\/c\/DA0-001\/comptia-data-da0-001-question76\/"},"modified":"2022-12-11T08:29:23","modified_gmt":"2022-12-11T08:29:23","slug":"comptia-data-da0-001-question76","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/c\/DA0-001\/comptia-data-da0-001-question76\/","title":{"rendered":"CompTIA Data+ DA0-001 &#8211; Question76"},"content":{"rendered":"<div class=\"question\">A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:<br \/>\nCustomer Table<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full\" src=\"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-content\/uploads\/exam\/img_77_0027.jpg\" \/><br \/>\nIn-store Transactions<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full\" src=\"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-content\/uploads\/exam\/img_77_0028.jpg\" \/><br \/>\nWhich of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?<br \/><strong><br \/>A.<\/strong> INNER: 6 rows; LEFT: 9 rows<br \/><strong>B.<\/strong> INNER: 9 rows; LEFT: 6 rows<br \/><strong>C.<\/strong> INNER: 9 rows; LEFT: 15 rows<br \/><strong>D.<\/strong> INNER: 15 rows; LEFT: 9 rows<\/div>\n<p><\/p>\n<style> .hidden-div{ display:none } <\/style>\n<p>\t\t\t\t\t\t\t<button onclick=\"getElementById('hidden-div').style.display = 'block'\"> Show Answer <\/button> <button onclick=\"getElementById('hidden-div').style.display = 'none'\">Hide Answer<\/button><\/p>\n<div class=\"hidden-div\" id=\"hidden-div\"><span style=\"\"><\/p>\n<div class=\"answer\">Correct Answer: <strong>D<\/strong><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN: Customer Table In-store Transactions Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[3,79],"class_list":["post-84","post","type-post","status-publish","format-standard","hentry","category-comptia-data-da0-001","tag-comptia-data-da0-001","tag-question-76"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/posts\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/c\/DA0-001\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}