Online Access Free 070-467 Exam Questions

You need to ensure that the Sales Per Capita calculated measure produces correct results.
What should you do?

• A.Set the Source DataType property of the Population measure to Biglnt.
• B.Set the 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 column of the FactPopulation data source view table to System.Int64.

You need to select the appropriate storage settings for the cube.
Which settings should you choose?

• A.Hybrid OLAP (HOLAP) with proactive caching enabled
• B.Multidimensional OLAP (MOLAP) with proactive caching enabled and a rebuild interval of 24 hours
• C.Relational OLAP (ROLAP) with proactive caching enabled
• D.Hybrid OLAP (HOLAP) with proactive caching disabled

You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a Microsoft SharePoint
2010 farm.
You need to upgrade to SSRS 2014 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Perform an in-place upgrade of the SSRS environment.
• B.Install SSRS 2014 on a new SharePoint farm and migrate content to the new farm.
• C.Migrate SSRS content to a separate instance of SSRS 2014 on the same server.
• D.Migrate SSRS content to new servers that run SSRS 2014.

You need to create the factCustomerContact table.
Which type of table should you create?

• A.A factless fact table
• B.A periodic snapshot fact table
• C.A fact table with an additive measure
• D.A fact table with a non-additive measure

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 project deployment model. Modify connection manager properties to use project parameters.
  Ensure that the SSISDB database is created.
• D.Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.