HikeLetter | PMP Training & Certification Online Course | Project Management Learning

1

A retail analyst is preparing a weekly sales report. What is the primary purpose of data profiling?

A. Understand data structure, quality, and patterns B. Encrypt all network traffic C. Create user passwords D. Replace data governance

2

A retail analyst is preparing a weekly sales report. Which action best improves data quality at ingestion?

A. Validate fields and reject or quarantine invalid records B. Ignore schema mismatches C. Delete all metadata D. Mix units without conversion

3

A retail analyst is preparing a weekly sales report. What is a relational database best suited for?

A. Structured data with relationships and queries B. Only unstructured video C. Storing model prompts without organization D. Replacing all object storage

4

A retail analyst is preparing a weekly sales report. Why is a data catalog useful?

A. It helps users discover datasets and understand their meaning and ownership B. It automatically guarantees all data is correct C. It removes the need for permissions D. It replaces backups

5

A retail analyst is preparing a weekly sales report. What does data lineage describe?

A. Where data came from and how it changed B. The physical age of a server C. A user's login history only D. The color of a dashboard

6

A retail analyst is preparing a weekly sales report. Which chart is often suitable for comparing values across categories?

A. Bar chart B. A random text cloud C. A network packet capture D. A password list

7

A retail analyst is preparing a weekly sales report. What is a key benefit of SQL?

A. It provides a standard way to query and manipulate relational data B. It is only used for image generation C. It prevents every data error automatically D. It replaces identity management

8

A retail analyst is preparing a weekly sales report. What is a data warehouse commonly used for?

A. Analytics and reporting across integrated datasets B. Real-time device firmware updates only C. Password reset workflows D. Replacing all operational applications

9

A retail analyst is preparing a weekly sales report. When is a data lake useful?

A. When storing large volumes of varied raw data for later processing B. Only when every field is already perfectly structured C. To eliminate metadata D. To avoid access controls

10

A retail analyst is preparing a weekly sales report. What is an important first step in a data project?

A. Clarify the business question and success criteria B. Select a chart before understanding the question C. Copy all available data indiscriminately D. Skip stakeholder alignment

Google Cloud Associate Data Practitioner

Overview

Course Description

Course Questions