Act now and download your Microsoft 70-466 test today! Do not waste time for the worthless Microsoft 70-466 tutorials. Download Down to date Microsoft Implementing Data Models and Reports with Microsoft SQL Server 2012 exam with real questions and answers and begin to learn Microsoft 70-466 with a classic professional.
Q61. - (Topic 3)
You need to ascertain why Marc did not receive his reports.
What should you do?
A. Search the ReportServerService_<timestamp>.log file for errors.
B. Search the registry for errors.
C. Use SQL Server Management Studio to search the SQL Server logs for errors.
D. Use the Windows Event Viewer to search the Application log for errors.
Answer: B
Q62. - (Topic 4)
You are designing a SQL Server Reporting Services (SSRS) report.
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a Microsoft Azure SQL Database database in the report.
What should you do?
A. Create a SQL Server data source and then add a dataset that uses the new data source.
B. Create a Microsoft Azure SQL Database data source and then add a dataset that uses the new data source.
C. Generate an Atom-compliant data feed for the report.
D. Create a Microsoft Azure SQL Database dataset that uses the existing data source.
Answer: C
Q63. - (Topic 4)
You have a SQL Server Analysis Services (SSAS) database named DB1 on a server named Server1.
You need to deploy DB1 from Server1 to four other servers. If the destination server already contains a copy of DB1, the database must be updated only. If the destination server does not contain a copy of DB1, the database must be copied to the destination server.
What is the best deployment option to use? More than one answer choice may achieve the goal. Select the BEST answer.
A. Analysis Services Deployment Wizard
B. Analysis Management Objects (AMO) automation
C. Backup and Restore
D. Synchronize Database Wizard
Answer: C
Q64. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise
specified in the connection string.
You need to configure the appropriate query mode.
Which query mode should you select?
A. In-Memory with DirectQuery
B. DirectQuery with In-Memory
C. In-Memory
D. DirectQuery
Answer: A
Q65. - (Topic 4)
You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has SQL Server Analysis Services (SSAS) installed. The model uses a relational data source named DB1.
You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1.
What should you do?
A. Register a Service Principal Name (SPN) for Server1.
B. From the SQL Server Data Tools, modify the impersonation settings.
C. From the Web.config file, modify the impersonation settings.
D. Register a Service Principal Name (SPN) for DB1.
Answer: A
Q66. - (Topic 4)
You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. Several report subscriptions are configured to deliver reports through email by using a shared schedule.
The email server will be going offline.
You need to temporarily suspend the shared schedule until the email server is brought back online.
What should you do?
A. In Report Manager, pause the shared schedule.
B. In SharePoint Central Administration, pause the shared schedule.
C. In Report Manager, delete the shared schedule.
D. In SharePoint Central Administration, delete the shared schedule.
Answer: B
Q67. HOTSPOT - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team.
The data warehouse used by the cube contains the time durations of taps run by each runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
. A measure named Measure1 that must contain the average time duration of the laps run by each runner. . A measure named Measure2 that must contain the lap-time duration and the name of the runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for each measure in the answer area.
Answer:
Q68. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?
A. City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])
B. City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey])
C. =RELATED(Geography[City]) =RELATED(Geography.City)
D. =VALUES(Geography[City])
E. City:=VALUES(Geography[City])
Answer: C
Explanation: * RELATED Function Returns a related value from another table.
Q69. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Answer:
Q70. - (Topic 4)
You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a Microsoft Azure SQL Database database and an OData data feed. The model will be deployed to a server with significantly more memory than the total size of the source data.
You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
. Maximize performance
. Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?
A. Select the multidimensional project type and use the ROLAP storage mode.
B. Select the tabular project type and use the In-Memory query mode.
C. Select the tabular project type and use the DirectQuery query mode.
D. Select the multidimensional project type and use the MOLAP storage mode.
Answer: B