Anblicks Interview Questions, Process, and Tips

Q1. How do you do bulk report migration ?
Ans. 
Bulk report migration can be done using Power BI REST API or PowerShell scripts.
• Use Power BI REST API to automate the migration process

• Create PowerShell scripts to handle bulk report migration

• Leverage tools like Power BI Management cmdlets for bulk operations
Answered by AI
Add your answer
Q2. How will you handle errors on pg
Ans. 
I will handle errors on pg by implementing error handling techniques and logging mechanisms.
• Implement try-catch blocks to catch and handle errors

• Use logging frameworks to log errors for troubleshooting

• Display user-friendly error messages to guide users on how to resolve issues
Answered by AI
Add your answer
Q3. Difference between distinct and null, parallel period and same period last year
Ans. 
Distinct vs Null: unique values vs absence of value. Parallel period vs Same period last year: comparing current vs previous time periods.
• Distinct values are unique values in a dataset, while null represents the absence of a value.

• Parallel period compares data from the same time period in different years, while Same period last year compares data from the previous year.

• For example, if we are comparing sales data for Ja...read more
Answered by AI
Add your answer
Q4. How do you refresh dimensions using api
Ans. 
You can refresh dimensions using Power BI REST API by sending a POST request to the appropriate endpoint.
• Use the POST method to send a request to the refresh endpoint

• Include the dataset ID and table name in the request body

• Authenticate the request using an access token or API key
Answered by AI
Add your answer

Q1. SQL Query to get Salary greater than manager salary
Ans. 
SQL query to retrieve salaries greater than manager salary
• Use a SELECT statement to retrieve the salaries

• Join the employee table with the manager table to compare salaries

• Add a WHERE clause to filter salaries greater than manager's salary
Answered by AI
Add your answer
Q2. Count of alphabets in a string
Ans. 
Count the number of alphabets in a given string.
• Iterate through each character in the string and check if it is an alphabet using isalpha() function.

• Increment a counter for each alphabet found.

• Return the final count of alphabets.

• Example: Input - 'Hello123', Output - 5 (alphabets: H, e, l, l, o)
Answered by AI
Add your answer

Coding questions and aptitude questions will be asked

Q1. Explain spark architecture
Ans. 
Spark architecture is a distributed computing framework that consists of a driver program, cluster manager, and worker nodes.
• Spark architecture includes a driver program that manages the execution of tasks and interacts with the cluster manager.

• Cluster manager allocates resources and schedules tasks on worker nodes.

• Worker nodes execute the tasks and return the results to the driver program.

• Spark architecture supports f...read more
Answered by AI
Add your answer
Q2. Explain broadcast joun
Ans. 
Broadcast join is a method used in distributed computing to combine data from multiple sources by broadcasting smaller tables to all nodes.
• Broadcast join is commonly used in distributed systems like Apache Spark to improve performance by reducing data shuffling.

• It involves broadcasting the smaller table to all nodes in the cluster, so that each node can perform the join operation locally.

• This method is efficient when o...read more
Answered by AI
Add your answer

Q1. Data pipelines architecture of your work
Ans. 
My data pipelines architecture involves a combination of batch and real-time processing using tools like Apache Spark and Kafka.
• Utilize Apache Spark for batch processing of large datasets

• Implement Kafka for real-time data streaming

• Use Airflow for scheduling and monitoring pipeline tasks
Answered by AI
Add your answer
Q2. Python data structures
Add your answer

Q1. AWS skills & python
Add your answer