MCTSMCTS(70-452)单项选择题每日一练(2019.03.21)

单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do？（）
A. Add a reference to the assemblies in the Report Properties References tab.
B. Write the calculation logic used by the calculations by using T-SQL functions.
C. Write the code of the calculation logic into the Report Properties Custom Code tab.
D. Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services （SSRS）.
单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services （SSAS） database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server. Each day， an application adds millions of fact rows and thousands of new customers. Currently， a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency. Which cube storage model should you use？（）
A. hybrid online analytical processing （HOLAP）
B. relational online analytical processing （ROLAP）
C. multidimensional online analytical processing （MOLAP）
D. automatic multidimensional online analytical processing （automatic MOLAP）
单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution contains a SQL Server 2008 Analysis Services （SSAS） database. A measure group in the database contains log entries of manufacturing events. These events include accidents， machine failures， production capacity metrics， and other activities. You need to implement a data mining model that meets the following requirements： Predict the frequency of different event types. Identify short-term and long-term patterns. Which algorithm should the data mining model use？（）
A. the Microsoft Time Series algorithm
B. the Microsoft Decision Trees algorithm
C. the Microsoft Linear Regression algorithm
D. the Microsoft Logistic Regression algorithm
单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. You need to load data into your online transaction processing （OLTP） database once a week by using data from a flat file. The file contains all the details about new employees who joined your company last week. The data must be loaded into the tables shown in the exhibit. （Click the Exhibit button.） Employee.EmployeeID is an identity. The safer ，easier way to help you pass any IT exams. A SQL Server 2008 Integration Services （SSIS） package contains one data flow for each of the destination tables. In the Employee Data Flow， an OLE DB Command transformation executes a stored procedure that loads the Employee record and returns the EmployeeID value. You need to accomplish the following tasks： Ensure that the EmployeeID is used as a foreign key （FK） in all child tables for the correct Employee record. Minimize the number of round trips to the database. Ensure that the package performs in the most efficient manner possible. What should you do？（）
A. Use a Lookup Transformation in each of the child table data flows to find the EmployeeID based on first name and last name.
B. Store the EmployeeID values in SSIS variables and use the variables to populate the FK columns in each of the child tables.
C. After the Employee table is loaded， write the data to a Raw File Destination and use the raw file as a source for each of the subsequent Data Flows.
D. After the Employee table is loaded， write the data to a Flat File Destination and use the flat file as a source for each of the subsequent Data Flows.
单项选择题
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.