Atlassian数据相关面经_Atlassian数据相关面试真题及高频题

1.Designing a Ticket Labeling System

2.Experience with Large Datasets

3.Data Scientist Uniqueness

4.Designing Ticket Priority for a Support Engineer

5.Familiarizing with a New Dataset

6.Calculate Trello Purchase Rate in 2019

7.Count Trello Purchases in 2019

8.Count Unique Visitors for Trello in 2019

9.Python Exception Handling

10.SQL Query with Conditions

11.Classify Collections with Parent-Child Relationships

12.Handle Files Belonging to Multiple Collections

13.Calculate Collection Sizes from Files

14.Case Study Analysis

15.SQL Technical Interview Questions

16.Identify users with 10 or more purchases

17.Calculate the number of total mobile orders

18.AWS Data Engineering Project Discussion

19.Stabilizing an Analytic System

20.Python Coding for Analyzing List Elements

21.SQL Query Variants

1. Designing a Ticket Labeling System

How would you design a labeling system for tickets? How would you measure the success of your design and how would you share your insights with stakeholders?

2. Experience with Large Datasets

Do you have experience dealing with large datasets and in what situations would you choose Python over SQL?

3. Data Scientist Uniqueness

What do you think is your uniqueness as a data scientist?

4. Designing Ticket Priority for a Support Engineer

How would you design the priority of tickets in a support ticket pool to help support engineers plan their work? How would you prove that your design of priority is successful, what metrics would you use, and if there is no change, what could be the issue?

5. Familiarizing with a New Dataset

How would you go about familiarizing yourself with a new dataset?