Study CCNA, CCNP, Azure, A+, Network+ for free!
Here you can find articles and questons that will help you to pass exam.
EnsurepassQUESTION 81 Drag and Drop You are developing a SQL Server Analysis Services (SSAS) tabular project based on a SQL Azure database. The Processing Option property for the project is set to Do Not Process. Several calculated columns have been added to a table. The project has been deployed to the production server. You need […]
EnsurepassQUESTION 71 You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging. Some users report that they cannot access the server. You need to ascertain the IP addresses of the client computers that are accessing the server. What should you do? A. View the Windows System […]
EnsurepassQUESTION 61 You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM. The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of […]
EnsurepassQUESTION 51 You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products. The Invoice Line Items table has the following columns: Product Id Unit Sales Price The Unit Sales Price column stores the unit price of the product sold. […]
EnsurepassQUESTION 41 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 of customers Unique count of products sold Sum of sales You need to ensure that the cube meets the […]
EnsurepassQUESTION 31 You are modifying a SQL Server Analysis Services (SSAS) multidimensional database. You have identified a dimension that is no longer used by any cubes. You need to delete the dimension. What should you do? A. Deploy the project from the development environment by using SQL Server Management Studio. B. Script the deletion […]
EnsurepassQUESTION 21 You are modifying a SQL Server Analysis Services (SSAS) cube. Users of the cube report that the precision for the TransactionCost measure is five digits. You need to ensure that the TransactionCost measure stores values to two digits of precision. What should you do? A. Add a named query in the data […]
EnsurepassQUESTION 1 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 modify report caching parameters. You need to ensure that the Developer role can view and modify report caching parameters. Which task should you […]