Q. We have a requirement like this. For every 10 days there is a data load happens in our database using a SSIS package. My requirement is once the ETL finished successfully then a SSRS report has to be emailed to the corresponding group of members. How can you do that? Q. How to ...
SQL developers are often asked to build new databases from the ground up. This is a process that involves many technical skills, such as indexing and performance tuning. Showcasing any previous experience you have building databases will show hiring managers you have the right experience to become...
To learn SQL Server, you first need to have the Microsoft SQL Server and the SQL Server Management Studio installed on your system. You should even look at the sample databases for queries. Proper training is required to get a good grasp on the internal build and architecture. Mindmajix prov...
Another interview I had with a database professional, turned out to be a dull conversation. The person came in to apply for a senior function, and he definitely had the experience for it. His personality was good, and would fit the team perfectly. But every answer we asked him, he answe...
I asked the clerk why a manager was needed for the process, since they didn't seem to check anything important. The clerk just shrugged and said "That's just the process we have to follow. The computer handles all the refunds anyway." At some point in time this process probably made ...
8. Using Built-In Functions –SQL 2014 new functions (Conversion, Logical) 9. Grouping and Aggregating Data –Using Aggregate functions |MSDN –Using GROUP BY clause |MSDN –Using HAVING clause |MSDN 10. Using Sub-Queries –Self-Contained Subqueries |TechNet ...
1. Implement interactive queries for big data with Spark SQL –Execute queries using Spark SQL –Cache Spark DataFrames for iterative queries –Save Spark DataFrames as Parquet files, –Connect BI tools to Spark clusters –Optimize join types such as broadcast versus merge joins ...
Or we could be asked this as a following question, since they both give the same result. We could use the dis module to see what's going on: 2 0 LOAD_CONST 0 (<code object a at 0x0000029C4D3C2DB0, file "<dis>", line 2>) 2 LOAD_CONST 1 ('a') 4 MAKE_FUNCTION 0 6 STOR...
Or we could be asked this as a following question, since they both give the same result. We could use the dis module to see what's going on: 2 0 LOAD_CONST 0 (<code object a at 0x0000029C4D3C2DB0, file "<dis>", line 2>) 2 LOAD_CONST 1 ('a') 4 MAKE_FUNCTION 0 6 STOR...
⚠️You can use these for preparing for an interview but most of the questions and exercises don't represent an actual interview. Please readFAQ pagefor more details 🛑 If you are interested in pursuing a career as DevOps engineer, learning some of the concepts mentioned here would be ...