|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/msbi-interview-questions/
课程评论：没有评论
课程名称：MSBI、SSIS、SSAS与SSRS面试问题及答案 课程概述：本课程旨在帮助学员准备MSBI面试，涵盖超过25个问题及答案，并结合实际演示。课程内容包括ETL过程、SSIS控制流及其他SSIS概念的相关问题。例如： 1. ETL过程的定义及示例 2. SSIS中的控制流与数据流之区别 3. SSIS架构的解释 4. SSIS的Perfmon计数器类型 5. SSIS查找组件中的缓存模式类型 6. SSIS变量与参数的比较 7. 如何安排SQL Server集成服务(SSIS)包的执行 8. 在执行SQL任务中如何将变量作为参数传递 9. 如何在SSIS中发送邮件 10. SSIS中的Pivot与Unpivot 此外，还有关于SSAS与SSRS的相关问题： 1. SSAS中的聚合及其重要性 2. SSAS中的分区 3. SSRS中不同数据区域的定义及多值参数化报告的创建 4. 如何发送自动报告交付 课程还包括错误处理、SSIS容器及部署的问题，比如： - 如何在SSIS中处理错误 - SSIS包的类型及其部署方法 - 事物与检查点的概述 并涵盖SSIS日志记录、合并与联合、数据分析任务等主题。最后，课程探讨MSBI中的连接类型、OLAP与OLTP的区别、星型模式与雪花模式、SSAS立方体的创建等重要概念，以及CDC、SSRS报告、层级参数等内容。 本课程是为希望深入了解MSBI组件及其在实际工作中应用的学员设计的，以帮助他们在面试中脱颖而出。
Prepare for MSBI Interview with over 25 questions and answers with practical demonstrations:-Questions on ETL Process, SSIS Control Flow and other SSIS concepts:-Question 1: What is ETL Process with example?Question 2: Difference between control flow and data flow in SSIS?Question 3: Explain the architecture of SSIS?Question 4: Explain the types of Perfmon counters for SSIS?Question 5: Explain the types of Cache Mode in SSIS Lookup component?Question 6: SSIS Variables vs Parameters?Question 7: How to Schedule SQL Server Integration Services (SSIS) Package?Question 8: How to pass variable as a parameter in Execute SQL Task SSIS?Question 9: How to send mails in SSIS?Question 10: SSIS Pivot and Unpivot?Question 11: What is Aggregation in SSAS?Question 12: What are Partitions in SSAS?Question 13: Explain Types of SSAS Storage Modes?Question 14: SSAS Relationships Types?Question 15: Named calculation vs Named query in SSAS?Question 16: What are the different data regions in SSRS?Question 17: How to Create Multi Valued Parameterized Report in SSRS?Question 18: Explain the different types of reports in SSRS?Question 19: How to send Automatic Report Delivery in SSRS?Question 20: Mention some of the open source softwares which are an alternative to SQL Server Reporting Services (SSRS)?Questions on Error Handling, SSIS Containers, Deploy SSIS Package:-Question 21 - How to do Error Handling in SSIS.Question 22- Types of Containers in SSIS.Question 23 - How to do SSIS Package Deployment to SQL Server?Question 24 - What are Transactions?Question 25 - What are Checkpoints?Questions on SSIS Logging, Union All vs Merge, Data Profiling Task:-Question 26: What is Logging in SSIS?Question 27: How to create File System Deployment?Question 28: Difference between Merge and Union All?Question 29: What is the Data Profiling task?Question 30: What is Precedence Constraints?Questions on Joins in MSBI, OLAP VS OLTP, Star Schema, Snow Flake, SSAS Cube:-Question 31: What is Merge Join and explain its different types of Joins?Question 32: Difference between OLTP & OLAP.Question 33: What is Fact, Dimension, Cube, Star Schema and Snow Flake?Question 34: How to create a Cube in SSAS?Question 35: What is SCD?Questions on CDC, SSRS Report, Tabular Report, Matrix Report and Page Break:-Question 36:- What is CDC?Question 37:- What is SSRS, what is Data Region, can embed/display SSRS Reports in any application, File extension and Code behind of SSRS Report.Question 38:- How to Deploy SSRS reports?Question 39:- Difference between Tabular and Matrix Report.Question 40:- What is Page Break in SSRS?Question 41:- Difference between Drilldown Report & Sub Report.Explain creating cascade parameters and defining clickable areas in SSRS Reports?Question 42:- How to Create Cascade Parameters in SSRS Report ?Question 43:- How to define clickable areas in SSRS Report?
