70-467 Exam
Update Microsoft 70-467 - An Overview 31 to 40
Accurate of 70-467 braindumps materials and bible for Microsoft certification for customers, Real Success Guaranteed with Updated 70-467 pdf dumps vce Materials. 100% PASS Designing Business Intelligence Solutions with Microsoft SQL Server 2012 exam Today!
Q31. You need to fix the PowerPivot data refresh problem by using the least amount of administrative effort.
What should you do?
A. Use the PowerPivot Configuration Tool and select the Upgrade Features, Services,
Applications and Solutions option.
B. Use the PowerPivot Configuration Tool and select the Configure or Repair PowerPivot
for SharePoint option.
C Reinstall SSAS in PowerPivot for SharePoint mode by using the SQL Server 2012
installation media.
C. In SharePoint Central Administration, create a target application and configure the
PowerPivot service application settings to use the target application.
Answer: B
Q32. You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.
You have the following requirements:
. Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time. . Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
. Maximize performance at execution time.
. Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use a package deployment model. Use a SQL Server package configuration with a common filter. Change the contents of the SSIS Configurations table at runtime.
B. Use a project deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.
C. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
D. Use a project deployment model. Modify connection manager properties to use project parameters. Ensure that the SSISDB database is created.
Answer: A
Q33. You need to ensure that the Sales Per Capita calculated measure produces correct results.
What should you do?
A. Set the DataType property of the Population column of the FactPopulation data source view table to System.Int64.
B. Set the Source DataType property of the Population measure to Biglnt.
C. Set the data type of the Population column of the FactPopulation data warehouse table to BIGINT.
D. Set the DataType property of the Population measure to Biglnt.
Answer: B
Q34. A group of report writers develop reports. The report writers currently use Report Builder
1.0 and report models. The report writers are not trained on SQL Server query writing. Their report assignments come from various departments within the organization.
The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode. After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables.
You are designing the data access strategy. You have the following requirements:
. Ensure that report writers can create only reports that display data which they have database permissions to view. . Minimize the effort required to update connection strings for all reports developed by the report writers. . Minimize the number of fields visible in a specific report for report writers who work for multiple departments.
You need to design the data access strategy.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create report models by using SQL Server Data Tools (SSDT). Include data sources and data source views for each department's data requirements. Configure each data source to use integrated security.
B. Create one shared data source that uses integrated security. Create an embedded dataset for each report.
C. Create one shared data source that uses integrated security. Create one shared dataset that includes all tables required by the report writers.
D. Create one shared data source that uses integrated security. Create a shared dataset for each department's data requirements.
Answer: D
Q35. You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy.
You need to return only the female customers in the Geography hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q36. You need to create the factCustomerContact table.
Which type of table should you create?
A. A fact table with a non-additive measure
B. A factless fact table
C. A periodic snapshot fact table
D. A fact table with an additive measure
Answer: B
Q37. You need to develop the tabular project to support the date analysis requirements.
What should you do?
A.
Create one date table named Date.
. Create an active relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
. Create an inactive relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
B.
.Create two date tables, one named Order Date and one named Ship Date.
. Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
. Create an inactive relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
C.
. Create one date table named Date.
. Create an active relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
. Create an inactive relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
D.
. Create two date tables, one named Order Date and one named Ship Date.
. Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
. Create an active relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
Answer: C
Q38. You need to configure a parameter for the database connection string.
What should you do?
A. Use a required package parameter.
B. Use a required project parameter.
C. Use a package configuration.
D. Use a global variable.
Answer: B
Q39. You need to develop a BISM that meets the business requirements for ad-hoc and daily operational analysis. You must minimize development effort.
Which development approach and mode should you use?
A. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to DirectQuery.
B. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to In-Memory with DirectQuery.
C. Develop a multidimensional project and configure the model with the DirectQuery mode setting off.
D. Develop a multidimensional project and configure the cube to use hybrid OLAP (HOLAP) storage mode.
Answer: B
Q40. You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with which users can filter the report by a single date. The parameter value cannot be directly used to filter the Multidimensional Expressions (MDX) query for the dataset.
You need to ensure that the report displays data filtered by the user-entered value. You must achieve this goal by using the least amount of development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Edit the dataset query parameter. Change the Value property of the report parameter to an expression that uses the same format as the date dimension member key value.
B. Edit the dataset query parameter. Change the Name property of the dataset query parameter so that it points to a name value for each date dimension member.
C. Edit the dataset query parameter. Create a subcube subquery that uses the StrToSet MDX function and accepts the report parameter value.
D. Change the dataset query to Transact-SQL (T-SQL). Use the OPENROWSET function to query the cube. Output the cube results to the T-SQL query and use a Convert function to change the report parameter value into the same format as the date dimension member.
Answer: A