BI 面试题，看看你能答对几个 (英文)
http://www.bridata.ca/blog/?p=909
别用搜索引擎, 如果你能回答个八九不离十，跟我联系，我们这正找人做项目呢。
[解决办法]
Basic about SQL Server
勉强能答
Reporting Services
Integration Services
Analysis Services
没做过
[解决办法]
看看,先帮顶.
[解决办法]
看懂问题了，但是就是打不上来。
只能友情UP了。
[解决办法]
我正在做，有所了解，不知是否可以加入你们的团队。
[解决办法]
帮顶一下，前面的还可以，后面的就答不上来了，呵呵
[解决办法]
友情帮顶
[解决办法]
只对基础和SSIs熟悉，As和RS有待提高。
[解决办法]
给微软做了3年的数据仓库 bi项目 你的问题基本都回 希望能和你联系
[解决办法]
自测了一把。要学的还有很多啊！~~
+------------------------+-----------+--------------------------+
| Skill Category | Developer | Sr.Developer/Tech Leader |
+------------------------+-----------+--------------------------+
| Basic about SQL Server | 100% | 70% |
| Reporting Services | 80% | 10% |
| Integration Services | 80% | 20% |
| Analysis Services | N/A | N/A |
+------------------------+-----------+--------------------------+
[解决办法]
额。。。页面没打开。。。还是帮忙顶下吧
[解决办法]
Reporting Services 没怎么做过。
Sr. SSAS 大概30%
其他应该都没问题
看来还是要去搞一搞SSRS和SSAS，一年多没用过了。
[解决办法]
大概能看懂，回答么就。。。
[解决办法]
BI真的一点都不会
[解决办法]
会的东西不多，感兴趣的是待遇多少？？
[解决办法]
偶一直用微软商业智能解决方案，这些问题还是比较简单的
[解决办法]
路过,帮顶.
[解决办法]
如楼主在24楼所说，如果单纯看题目，都是基础题目。
如果再深究下去，每个又是个小课题。呵呵。
[解决办法]
不好用啊
[解决办法]
ＢＩ本来就难，为什么还靠英文的啊。
[解决办法]
Reporting Services 0%
Developer 90%
Sr.Developer/Tech lead position 40%
前端不使用RS，看需要加。
[解决办法]
[解决办法]
太全面了，实在答不上来，胡乱答了点，给大家参考参考。。。
- SQL code
Questions I asked candidates who are applying for Developer position:
Basic about SQL Server
1. How long have you been using SQL Server 2005 or SQL Server 2008 (or Oracle/DB2 if mentioned in resume)?
>> I have been using SQL Server 2008 for half a year .
2. How can you do the SQL script (T-SQL, SP…) performance tuning?
>> I think SQL performace tunning is a complex issue,you need to consider the IO consuming,time elapsed ,logical reads and so on .
>> But we need to know about the way Query Optimize working at the beginning,and know how to read the execute plan.
3. What’s CTE (Common Table Expression)? What’s the benifit for develpers to use it?
>>I never use the CTE,but I think it is used for intermediate result.With CTE, we need not use temp table or table variable.
4. What’s difference between the SQL Server datatype nVarchar and Varchar?
>>The 'N' idicate that this is a unicode type ,can store the national character.
5. What’s difference between the SQL Server datatype Varchar and Char?
>>The biggest difference between varchar and char is that the length of char is fixed,you can not use char to adjust the space well.
6. What’s difference between Union and Union All, which one is faster if same records retrieved?
>>The Union All will not take the duplicate rows ,and Union will.
>>The Union All will be faster,because it does not need to care about the duplicate row.
Reporting Services
1. How long time have you been using SQL Server Reporting Services 2005/2008?
>> I have been using SSRS 2008 for half a month to build a DBA management repository.
2. What’s difference between SSRS 2005 and SSRS 2008 (if the candidate answered yes when asking if used SSRS 2005)?
>>Well, What I know is SSRS 2008 does not need the IIS again, and the xmlns also change.
3. What’s difference between List control, Table control and Matrix control?
>>List control is used for list the value,
>>Table control is used for print the value in a table,
>>Matrix control is used for print the value in a table-chart mixed style.
>>Just Guess :)
4. How to implement the cascading parameters in Report Designer?
>>Don't know.
5. How to deploy reports to reports server?
>>First,we need to startup the SSRS service,and setup the report database and page URLS.
>>Then,input the page URLS in the destination URL.
>>At last, run the deploy on right click the SSRS solution.
6. How to deploy reports to Sharepoint server? (if use Sharepoint server to host reports)
>>Don't know.
Questions I asked candidates who are applying Sr.Developer/Tech lead position:
Basic about SQL Server
1. How long have you been using SQL Server 2005 or SQL Server 2008 (or Oracle/DB2 if mentioned in resume)?
>>The same answer.
2. How to use the Ranking function ?
>>Rank over ( <order by clause>)
3. What’s policy and strategy to desion the table partition?
>>Have not use the table partition yet, But I think the table partition is not immature.I will not take it before I have test it well .
4. What’s the key point to setup the SQL Sever remote connection?
>>In my option , it is the security and performance .
5. How to detect and release the deadlock?
>>In 2000,you can use the sp_who,and sp_lock ,or to turn on the trace 1222;
>>In 2005,you can use the sys.dm_tran_locks or SQL SERVER PROFILER to dectect the dead lock.
>>The SQL Server will charge the deadlock itself in most sutiation ,and need not pepole to interact with it.
>>But the best way to solve deadlock is change the application code.
6. What’s the difference between phisical ER and logical ER design?
>>Have foget the database theory .
7. Conditions to use index view.
>>The value come from the view will not change frequently.
[解决办法]
支持一下
[解决办法]
[解决办法]
楼主的问题看得懂,就会basic,还有SSIS,SSAS这些啊
都不会
唉,技术是学不完的啊
[解决办法]
开始学习中。。。
[解决办法]
我英文不好~看来这个问题比较严重~
[解决办法]
诶，顶下，懂的不多！
[解决办法]
保存一下以后面试用.
[解决办法]
学习中正在努力！
[解决办法]
这种要求下能提供什么薪资？
[解决办法]
我的老天，现在都考状元呢，那么多勋章的人都答不上来~这考题可以去死了