题目内容

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services (SSAS) solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers: ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do?()

A. Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.
B. Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.
Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.
D. Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.

查看答案
更多问题

甲上市公司2011年至2012年发生与其股票有关的业务如下:(1)2011年1月4日,经股东大会决议,并报有关部门核准,增发普通股40000万股,每股面值1元,每股发行价格5元,股款已全部收到并存入银行。假定不考虑相关税费。(2)2011年6月20日,经股东大会决议,并报有关部门核准,以资本公积4000万元转增股本。(3)2012年6月20日,经股东大会决议,并报有关部门核准,以银行存款回购本公司股票100万股,每股回购价格为3元。(4)2012年6月26日,经股东大会决议,并报有关部门核准,将回购的本公司股票100万股注销。要求:根据上述资料,不考虑其他因素,分析回答下列第(1)~(2)题。根据资料(1),下列说法正确的是()。

A. 计入股本的金额是40000万元
B. 计入股本的金额是200000万元
C. 计入股本溢价的金额是160000万元
D. 计入股本溢价的金额是40000万元

《电力安全工作规程(变电所部分)》3.0.16规定,在霜冻、雨雪后进行高处作业,应采取防滑措施和()措施。

A. 防寒防冻
B. 高空保护
C. 防倾斜
D. 倒杆

女,52岁,12小时前发生腹痛,始在脐周,为隐痛不适,发病后2小时突然腹痛加剧,扩散至全腹,呈持续性胀痛,伴恶心,呕吐1次,为少量胃内容物。轻度发热.37.5℃。查体:急性痛苦面容,BP130/80mmHg,P106次/分,心肺无异常,全腹均有压痛,但以右下腹部压痛明显,并有肌紧张和反跳痛。结肠充气试验(+),WBC25×109/L。此病人应考虑为()

A. 急性胆囊炎合并腹膜炎
B. 急性胰腺炎合并腹膜炎
C. 急性阑尾炎、穿孔腹膜炎
D. 右输卵管妊娠破裂出血
E. 溃疡病穿孔腹膜炎

女,52岁,12小时前发生腹痛,始在脐周,为隐痛不适,发病后2小时突然腹痛加剧,扩散至全腹,呈持续性胀痛,伴恶心,呕吐1次,为少量胃内容物。轻度发热.37.5℃。查体:急性痛苦面容,BP130/80mmHg,P106次/分,心肺无异常,全腹均有压痛,但以右下腹部压痛明显,并有肌紧张和反跳痛。结肠充气试验(+),WBC25×109/L。该患者应采取下列哪种治疗措施()

A. 胆囊切除术
B. 阑尾切除术
C. 胰腺病灶切除+引流术
D. 穿孔修补+引流术
E. (右)输卵管切除术

答案查题题库