ScatterPie Analytics Interview Questions and Answers

Use window function to find 2nd highest salary in SQL

• Use the ROW_NUMBER() function to assign a unique row number to each row based on the salary in descending order

• Filter the results where the row number is 2 to get the 2nd highest salary

To connect to a SharePoint database, you can use SharePoint's REST API or Microsoft Graph API.

• Use SharePoint's REST API to interact with SharePoint data through standard HTTP requests.

• Authenticate using OAuth tokens to access SharePoint resources securely.

• Utilize Microsoft Graph API for a unified endpoint to access data across Microsoft services.

• Ensure proper permissions are set up for the application accessing the SharePoint database.

I have experience working on projects with end-to-end architecture, including design, development, testing, and deployment.

• Designed and implemented scalable AWS architectures using services like EC2, S3, Lambda, API Gateway, etc.

• Developed applications using AWS SDKs and integrated with other AWS services.

• Performed testing and debugging of applications on AWS infrastructure.

• Deployed applications on AWS using CI/CD pipelines like AWS CodePipeline or Jenkins.

• Monitored and optimi...read more

Cost optimization on Snowflake involves utilizing features like virtual warehouses, auto-suspend, and resource monitoring.

• Utilize virtual warehouses efficiently based on workload requirements

• Enable auto-suspend to automatically pause warehouses when not in use

• Monitor resource usage and adjust configurations accordingly

Expected CTC at Scatterpie

• Research industry standards for AWS Developer roles at Scatterpie

• Consider your experience, skills, and qualifications

• Factor in location, company size, and benefits package

• Negotiate based on market trends and personal value

Blend combines data from different data sources in a single view, while join combines data from the same data source.

• Blend is used when data comes from different data sources, join is used when data comes from the same data source

• Blend creates a relationship between data sources without actually merging the data, join merges the data based on a common field

• Blend can be used to combine data from different databases like SQL and Excel, join is used to combine data from the same...read more

Tableau architecture is a visual analytics platform that helps users to understand data through interactive visualizations.

• Tableau consists of three main components: Data Connection, Data Engine, and VizQL Server.

• Data Connection allows users to connect to various data sources such as databases, spreadsheets, and cloud services.

• Data Engine processes and optimizes data queries for faster performance.

• VizQL Server translates data queries into visualizations that can be displayed ...read more