当前位置:MCTS(70-452)题库

问题:

[单选] 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.
C .  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.

如何认识古王国时代埃及的专制王权? 用户可用的内存容量是指()。 RAM的容量。 ROM的容量。 RAM+ROM的容量。 CD-ROM的容量。 从学科性质上来看,犯罪社会学属于以下哪门学科的分支科学() 生物学。 社会学。 法学。 心理学。 切口与纤维排列呈垂直时() 创口哆开增大。 创口呈纺锤形。 创口哆开较小。 创口呈裂隙形。 创口呈菱形。 Your company has recently acquired a new subsidiary company in Quebec. The Active Directory administrators of the subsidiary company must use the French-language version of the administrative templates. You create a folder on the PDC emulator for the subsidiary domain in the path %systemroot% \SYSVOL\domain\Policies\PolicyDefinitions\FR. You need to ensure that the French-language version of the templates is available. What should you do() Download the Conf.adm, System.adm, Wuau.adm, and Inetres.adm files from the Microsoft Web site. Copy the ADM files to the FR folder.。 Copy ADML files from the French local installation media for Windows Server 2008 to the FR folder on the subsidiary PDC emulator.。 Copy the Install.WIM file from the French local installation media for Windows Server 2008 to the FR folder on the subsidiary PDC emulator.。 Copy ADMX files from the French local installation media for Windows Server 2008 to the FR folder on the subsidiary PDC emulator.。 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?()
参考答案:

  参考解析

本题暂无解析

在线 客服