ssis面试题_SSIS面试问题

ssis面试题

These SSIS interview questions cover many of the top topics that you will be asked when applying for your next SSIS developer job. Each question has links to articles that cover the topic in depth.

这些SSIS面试问题涵盖了许多在申请下一个SSIS开发人员工作时会被问到的重要话题。 每个问题都有指向深入讨论该主题的文章的链接。

介绍 (Introduction)

Looking for a job related to SQL Server Integration Services (SSIS)? An SSIS developer in USA has an average salary of 78,414 USD, which is a good salary compared of other related jobs according the PayScale website:

寻找与SQL Server集成服务（SSIS）相关的工作？ 美国的SSIS开发人员的平均薪水为78,414美元，与PayScale 网站上的其他相关工作相比，是不错的薪水：

Job	Salary per year (USD)
SSIS Developer	78,414
Java Developer	73,285
DBA	71,775
C++ Developer	69,948
C# Developer	68,535
PHP Developer	62,819

工作	年薪（美元）
SSIS开发人员	78,414
Java开发人员	73,285
数据库管理员	71,775
C ++开发人员	69,948
C＃开发人员	68,535
PHP开发人员	62,819

The question is. How can I get a job as an SSIS developer?

问题是。 如何获得SSIS开发人员的工作？

In this article, we will talk about interview questions to learn SSIS for newbies and also for experienced users and have enough knowledge to pass the interview questions and get a nice job.

在本文中，我们将讨论面试问题，以便为新手和有经验的用户学习SSIS，并具有足够的知识通过面试问题并获得出色的工作。

SSIS认证考试 (Certification exams for SSIS)

There are official certification exams from Microsoft to be an expert in SSIS. The following certifications exams can be useful to validate your knowledge and if you do not have the knowledge, you can look for the courses, books, training material related to these exams:

Microsoft拥有官方认证考试，可以成为SSIS的专家。 以下认证考试对于验证您的知识很有用，如果您不具备这些知识，则可以查找与这些考试相关的课程，书籍和培训材料：

• Exam 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 考试70-467使用Microsoft SQL Server设计商业智能解决方案
• Exam 70-767 Implementing a Data Warehouse using SQL 考试70-767使用SQL实施数据仓库

These exams not only cover SSIS, but other areas like SSAS and SSRS. The skills required to pass these exams are deep.

这些考试不仅涵盖SSIS，而且涵盖SSAS和SSRS等其他领域。 通过这些考试所需的技能很深。

If you pass these exams, you can pass any interview question for sure. They are difficult exams that requires