Question: 1
Olivia has 15 people on her data analytics team. Her team's charter requires that all team members have read access to the finance, human resources, sales, and customer service areas of the corporate data warehouse.
What is the best way to provision access to her team?
Choose the best answer.
Question: 2
What is the median of the following numbers?
13, 2, 65, 3, 5, 4, 7, 3, 4, 7, 8, 2, 4, 4, 60, 23, 43, 2
Question: 3
Oliver is designing an ETL process to copy sales data into a data warehouse on a hourly basis.
What approach should Oliver choose that would be most efficient and minimize the chance of losing historical data?
Question: 4
James wants to analyze profit based on sales of five different product categories.
His source data set consists of 5.8 million rows with columns including region, product category, product name, and sales price.
How should he manipulate the data to facilitate his analysis?
Choose the best answer.
Question: 5
According to the empirical rule, what percent of thee values in a sample fall within three standard deviations of the mean in a normal distribution?
