70-466 Practice Questions
160 real 70-466 exam questions with expert-verified answers and explanations. Page 2 of 4.
- Question #52Build an analysis services database
You are developing a SQL Server Analysis Services (SSAS) cube. You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measu...
MDXPARALLELPERIODtime intelligencecalculated measures - Question #53Build an analysis services database
You are developing a SQL Server Analysis Services (SSAS) cube. You need to add a calculated member to the Customer dimension to evaluate the sum of values for France and Germany. W...
MDX calculated membersset aggregationCustomer dimensioncountry grouping - Question #54Build an analysis services database
You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department. You create a measure group named Exchange Rate that consists of measures pertaining to cu...
AggregationFunctionAverageOfChildrenexchange rate measuressemi-additive measures - Question #55Build an analysis services database
You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company. The sales department requires the following set of metrics: - Unique count o...
distinct countmeasure groupsquery optimizationaggregation functions - Question #56Build an analysis services database
You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services (SSAS) cube. You need to compute the aggregate value of the 10 most-ordered produces in the...
MDXTOPCOUNTAGGREGATEProduct Categories hierarchy - Question #57Build a tabular data model
You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. T...
BISM project typetabular modelPower ViewDirectQuery vs In-Memory - Question #58Configure and maintain an analysis services database
You are modifying a SQL Server Analysis Service (SSAS) cube. The cube consist of a single measure group that contains the following measures: - Total Quantity On Hand - Average Qua...
ROLAP storagereal-time updatesmeasure groupsmixed latency requirements - Question #59Build reports
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...
SSRS data sourcesdatasetsSQL Serverreport data configuration - Question #60Implement a reporting services solution
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 config...
shared schedulesSharePoint integrated modeSSRS subscriptionsCentral Administration - Question #61Build reports
You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the...
SSRS action propertiesemail actiontext box configurationReport Designer - Question #62Implement a reporting services solution
You manage a SQL Server Reporting Services (SSRS) instance running in native mode. You are troubleshooting a performance problem and need to know which reports are frequently execu...
SSRS execution loggingreport server configurationnative modeperformance monitoring - Question #63Build reports
You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data are stored in a S...
SSRS mapsspatial data sourcemap region filteringreport interactivity - Question #64Build reports
You are creating a new report in SQL Server Report Builder. You add a SQL Azure data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales. Y...
SSRS matrixrow groupingadjacent groupReport Builder layout - Question #65Implement a reporting services solution
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server. The Folder Access Controller role c...
SSRS rolesfolder permissionsitem-level securityReport Manager - Question #66Implement a reporting services solution
You reinstall SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?
SSRS encryptionsymmetric keyrskeymgmtkey restore - Question #67Implement a reporting services solution
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server. Members of the Developer Support ro...
SSRS system rolesexecution timeoutserver propertiesrole tasks - Question #68Implement a reporting services solution
You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server. The Developer role cannot view and modif...
SSRS item rolesreport cachingrole permissionscache parameters - Question #69Build a tabular data model
You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant permission for salespersons to be able to view only the data based on their sales territ...
SSAS tabular row-level securityDAX filterrole-based accesssales territory - Question #70Implement a reporting services solution
You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are building a shared dataset for your weekly performance reports. The shared dataset uses a data sou...
SSRS shared datasetdataset cachingshared schedulecache expiration - Question #71Build an analysis services database
You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a SQL Azure database. You plan to use multiple servers to p...
SSAS remote partitionsparallel partition processingdata source configurationmultidimensional partitioning - Question #72Configure and maintain an analysis services database
You manage a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is the only database on the instance. The application generat...
SQL Server memoryoptimize for ad hoc workloadsplan cacheserver advanced options - Question #73Configure and maintain an analysis services database
You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the...
deadlock monitoringExtended Eventsreal-time monitoringSQL Server tracing - Question #74Build an analysis services database
You plan to design an application that temporarily stores data in a SQL Azure database. You need to identify which types of database objects can be used to store data for the appli...
SQL Azuretemporary tablesschema modificationsession-scoped objects - Question #75Configure and maintain an analysis services database
You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain user-created stored procedures or user-created functions. You need to minimize...
plan cache optimizationoptimize for ad hoc workloadsSQL Server memorysingle-user database - Question #76Configure and maintain an analysis services database
You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance. You need to ascertain the memory consumed by each object in the SSAS...
SSAS memory monitoringdiscover_object_memory_usageDMVtabular model memory - Question #77Configure and maintain an analysis services database
You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings. The model has one cube and the cube has one measure group. The...
SSAS partition processingprocessing optionsincremental loadmultidimensional BISM - Question #78Build a tabular data model
You are planning to develop a SQL Server Analysis Services (SSAS) tabular project. The project will be deployed to a SSAS server that has 16 GB of RAM. The project will source data...
SSAS tabular DirectQueryIn-Memory modecolumnstore indexlarge fact table performance - Question #79Build a tabular data model
You need to create the KPI in the AdhocReports project. What should you do?
SSAS KPIDAX measuresSUM expressiontabular KPI creation - Question #80Configure and maintain an analysis services database
You need to deploy the StandardReports project. What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
SSAS deploymentXMLA deployment scriptSSDT deploymentAnalysis Services Deployment wizard - Question #81Configure and maintain an analysis services database
You need to deploy the StandardReports project at the end of the current business day. What should you do? (Each correct answer presents a complete solution. Choose all that apply....
XMLA deploymentAnalysis Services deployment wizardSSDT deployment - Question #82Build a tabular data model
You need to create the hierarchy in the AdhocReports project. What should you do?
tabular hierarchyRELATED functionDAXdimension columns - Question #83Implement a reporting services solution
You need to identify the reports that produce the errors that Marc is receiving. What should you do?
ExecutionLog3report server databaseSSRS troubleshootingreport errors - Question #84Build an analysis services database
You need to create the KPI in the AdhocReports project in time for the next production release cycle. What should you do?
KPIMDXCREATE KPI CURRENTCUBEmeasures - Question #85Implement a reporting services solution
You need to ascertain why Marc did not receive his reports. What should you do?
SSRS logsreport subscriptionstroubleshootingReportServerService log - Question #86Build an analysis services database
You need to create the data source view for the StandardReports project. What should you do?
data source viewDSV wizarddata sourcedata warehouse - Question #87Build an analysis services database
You need to create the sales territory and product measures. Which aggregate function should you use for both measures?
aggregate functionsdistinct countmeasurescube design - Question #88Build a tabular data model
You need to create a measure for DOD sales. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
DAXPARALLELPERIODMark as Date Tabletime intelligence - Question #89Build an analysis services database
You need to develop the multidimensional project to meet the requirements of the Excel users. What should you do?
perspectivesSSAS cubeExcel usersexecutive reporting - Question #90Implement a reporting services solution
You need to configure the permissions for the sales team members in the Sales Reports library. Which permissions should you use? (Each answer presents part of the solution. Choose...
SharePoint permissionsreport librarySSRS SharePoint modesecurity - Question #91Implement a reporting services solution
You need to configure the SSRS data source. What should you do?
data source credentialsWindows authenticationSSRS data sourcesecurity - Question #92Build an analysis services database
Drag and drop question. You need to optimize the Regions dimension. How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list o...
attribute relationshipsdimension optimizationhierarchyRegions dimension - Question #93Build reports
You need to develop the executive reports. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
report parametersdefault parameter valuesdata source authenticationSSRS reports - Question #94Configure and maintain an analysis services database
You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which SSAS feature should you use?
SSAS translationshierarchy modificationlocalizationSales Regions - Question #95Implement a reporting services solution
You need to configure SSRS to meet the maximum number of snapshots requirement. What should you do? (Each answer presents a complete solution. Choose all that apply.)
snapshot limitSSRS configurationreport historySharePoint mode - Question #96Implement a reporting services solution
You need to configure per-user security authentication for reporting against the Sales cube. What should you do? (Each correct answer presents part of the complete solution. Choose...
KerberosSPN configurationaccount delegationper-user security - Question #97Configure and maintain an analysis services database
You need to modify the Sales cube to support the planning requirements. Which SSAS feature should you use?
writeback partitionSSAS planningcube write-backpartition storage - Question #98Configure and maintain an analysis services database
You need to configure the UserRegions role. Which Multidimensional Expressions (MDX) function should you use?
MDX securityUSERNAME functiondimension securityroles - Question #99Configure and maintain an analysis services database
You need to configure the partition storage settings to support the reporting requirements. Which partition storage setting should you use?
partition storageMOLAPproactive cachinglow-latency MOLAP - Question #100Build reports
You need to develop an SSRS report that retrieves currency exchange rate data. How should you configure the data source for the report?
Azure SQL DatabaseSSRS data sourcecredentialsSQL Azure - Question #101Build an analysis services database
You need to create the AD Sales measure. Which aggregation function should you use?
measure aggregationAverageOfChildrenaccount intelligenceSSAS multidimensional