PROFESSIONAL-DATA-ENGINEER Question #179: Real Exam Question with Answer & Explanation

Question

You want to analyze hundreds of thousands of social media posts daily at the lowest cost and with the fewest steps. You have the following requirements: You will batch-load the posts once per day and run them through the Cloud Natural Language API. You will extract topics and sentiment from the posts. You must store the raw posts for archiving and reprocessing. You will create dashboards to be shared with people both inside and outside your organization. You need to store both the data extracted from the API to perform analysis as well as the raw social media posts for historical archiving. What should you do?

Options

• AStore the social media posts and the data extracted from the API in BigQuery.
• BStore the social media posts and the data extracted from the API in Cloud SQL.
• CStore the raw social media posts in Cloud Storage, and write the data extracted from the API into BigQuery.
• DFeed to social media posts into the API directly from the source, and write the extracted data from the API into BigQuery.