A data analyst has a DataFrame of system metrics and wants to compute the correlation between CPU usage and memory usage. They have already cleaned the data. Which pandas method should they use?

df['cpu'].corrwith(df['memory'])

A security analyst wants to create a bar chart showing the number of alerts per day for the last week. They have a DataFrame 'alerts' with a 'timestamp' column. Which code snippet correctly aggregates and plots the data?

alerts['timestamp'].value_counts().plot(kind='bar')

alerts.groupby(alerts['timestamp'].dt.date).size().plot(kind='bar')

alerts.resample('D', on='timestamp').count().plot(kind='bar')

alerts.plot(kind='bar', x='timestamp')

An analyst receives a JSON file containing nested records of user activity. They need to flatten this into a pandas DataFrame where each nested object becomes a separate row with the parent's fields repeated. Which pandas function should they use?

pd.json_normalize(data, record_path='activity')

pd.read_json(data, orient='records')

pd.concat(data, ignore_index=True)

GIAC Python Coder

Domain 4Objective 1

Data Analysis with Python GPYC Practice Questions (Page 7)

Part of the Data Analysis domain, which makes up ~9% of our current practice bank. GIAC (SANS) does not publish an official question count, but from its 120-minute exam (~50–80 total, ~5–7 in this domain), expect 5–7 from this objective — we provide 33 practice questions to prepare you well beyond it. (estimate)

33questions here

7free pages

5concepts

Questions 31–33

31application · medium
A data analyst has a DataFrame of system metrics and wants to compute the correlation between CPU usage and memory usage. They have already cleaned the data. Which pandas method should they use?
Select an answer first
32application · medium
A security analyst wants to create a bar chart showing the number of alerts per day for the last week. They have a DataFrame 'alerts' with a 'timestamp' column. Which code snippet correctly aggregates and plots the data?
Select an answer first
33application · medium
An analyst receives a JSON file containing nested records of user activity. They need to flatten this into a pandas DataFrame where each nested object becomes a separate row with the parent's fields repeated. Which pandas function should they use?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to GPYC

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by GIAC (SANS). “GPYC” is a trademark of its owner, used for identification only.

Data Analysis with Python GPYC Practice Questions (Page 7)

Questions 31–33

A data analyst has a DataFrame of system metrics and wants to compute the correlation between CPU usage and memory usage. They have already cleaned the data. Which pandas method should they use?

A security analyst wants to create a bar chart showing the number of alerts per day for the last week. They have a DataFrame 'alerts' with a 'timestamp' column. Which code snippet correctly aggregates and plots the data?

An analyst receives a JSON file containing nested records of user activity. They need to flatten this into a pandas DataFrame where each nested object becomes a separate row with the parent's fields repeated. Which pandas function should they use?

Keep studying — Data Analysis